Posted to microsoft.public.excel.programming

Glen[_5_]

external usenet poster

Posts: 31

setting a dynamic path in an excel query

Tom Ogilvy provided me with the solution to his problem.

remove the single qutoes from this section of code to make it work.
DBQ='" & pathname &
"'\MatCompile.mdb;DefaultDir='" & pathname & "'" _

Thanks again Tom and Vic.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
microsoft query in excel default save path	George Applegate	Excel Discussion (Misc queries)	0	January 2nd 07 11:06 PM
Dynamic web query in Excel 2003	Farhomer	Excel Discussion (Misc queries)	0	October 3rd 06 10:53 PM
Excel 2k3 query path to current directory	busypgmr	Excel Discussion (Misc queries)	1	September 5th 06 10:05 PM
Setting a path to a folder	Boots	Excel Discussion (Misc queries)	2	August 10th 06 02:14 PM
Try to change the path of the Query of pivot table in Excel 2000	Victor[_3_]	Excel Programming	0	December 29th 03 05:03 PM

All times are GMT +1. The time now is 08:47 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us