I am trying to use a FileDialog(msoFileDialogFilePicker) dialog box to import either delimited text from a file, or content from a XLS sheet (all cells from the first worksheet). I have the delimited-import part working, but I am unable to get the XLS import to work.
My code is attachd. Any input is appreciated.
Welcome to the forum!
In the second QueryTables.Add, change Connection:="TEXT;" to Connection:="ODBC;" and see if that helps.
Bob
Click my star if my answer helped you. Mark the thread as [SOLVED] if it has been.
I appreciate the ODBC idea, but still no data unfortunately.
Any other input is appreciated.
I recorded the following macro by selecting Data->Import External Data->Import Data..., then selecting an Excel file and then Sheet1. This shows what things you need to specify in the ODBC connection string.
I suggest you record what you want to have happen and then adapt it to your needs.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks