I'm getting the error "Application" is ambiguous in the namespace 'microsoft.office.interop.excel'
I don't think you should have the line as Imports Microsoft.Office.Interop
.
Either use
Imports Excel = Microsoft.Office.Interop.Excel
And then use it as:
Dim xl As Excel.Application
Or remove the Imports
all together and use the full name everywhere, as:
Dim xl As Microsoft.Office.Interop.Excel.Application
Removing and re-adding the reference solved this issue.