deadlyliquidx
New Member
- Joined
- Feb 6, 2015
- Messages
- 27
Hi,
I am using MS query and SQL syntax to update a pivot that reads the worksheets sheets within the same workbook.
Now I know that this works perfectly when the files that the query is reading off a seperate closed workbook but I need to have that workbook open. Is there something I can add to the connection string to allow this?
I tried readonly=0 and then false and then 1 and true and all variations,
the fact that I cant read internally from the workbook is the only major snag, can someone tell me what-else to add.
here is the string:
DBQ=C:user\blah\thisfile.xlsm;Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DriverId=1046;FIL=excel 12.0;MaxBufferSize=2048;PageTimeout=5;
Also if the DBQ can be made dynamic to read the files current name and path (without VBA but I will do VBA if need be, that be great too) thanks!
I am using MS query and SQL syntax to update a pivot that reads the worksheets sheets within the same workbook.
Now I know that this works perfectly when the files that the query is reading off a seperate closed workbook but I need to have that workbook open. Is there something I can add to the connection string to allow this?
I tried readonly=0 and then false and then 1 and true and all variations,
the fact that I cant read internally from the workbook is the only major snag, can someone tell me what-else to add.
here is the string:
DBQ=C:user\blah\thisfile.xlsm;Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DriverId=1046;FIL=excel 12.0;MaxBufferSize=2048;PageTimeout=5;
Also if the DBQ can be made dynamic to read the files current name and path (without VBA but I will do VBA if need be, that be great too) thanks!