Forum Discussion
Using parameter as data source
What is the content of the parameter? It should be a path to the excel file.
And once you got that, you still have to find the cell in you workbook.
So, first solution gets you an error or en excel file as Source and second solution gets you some content from the workbook containing the query.
This is how it is supposed to work.
Excel.Workbook and Excel.CurrwntWorkbook return the same type of date, so you should use their results the same...
The content of the parameter is an excel file path.
Thanks for the explanation. The weird thing is that the first query using Excel.Workbook and using the parameter directly without having the extra step of creating the FilePath works for my colleague linking to the same excel file.
That's why I am uncertain why the same query does not work for me without the work around.