Greetings,
Would you be so kind and let me know how I can make wizard prompt user to select a file to open instead of haing a specific file linked to the connection like in the following example.
Thank you for your help.
Please Login or Register to view this content.
Last edited by Leith Ross; 07-10-2008 at 11:42 AM.
Hello iguss,
I have added some code to allow the user to select the file. The "Open" file dialog defaults to the file path you have in your code.
Sincerely,Please Login or Register to view this content.
Leith Ross
Thank you so much, I will buy you a dring when I will be in the area.
There seems to be a small problem though, I get an error at
With ActiveSheet.QueryTables.Add(Connection:= _
FileToOpen _
, Destination:=Range("A1"))
Would you be able to identify the problem.
Thank you in advance
Hello iguss,
Sorry about that, I made a typographical error in the code. I have tested this version. I changed the macro name. You should not use keywords or event names for macros.
Sincerely,Please Login or Register to view this content.
Leith Ross
Query Table
Thank you so much, works like a charm.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks