problem with ActiveSheet.QueryTables.Add for text file

G

G.R. Toro

I am using ActiveSheet.QueryTables.Add in Excel 2003 to import
space-delimited text into a worksheet. The import works, but when I
re-execute the macro with ActiveSheet.QueryTables.Add to import new data
into the same sheet, all references to that sheet get shifted (i.e., what
was a reference to cell B1 of the sheet with the imported data becomes a
reference to cell C1.

I would appreciate any suggestions.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Browse 4 a file & disconnect a connection to external source 1
Help bringing in hyperlink into Excel from Web 3
ActiveSheet.QueryTables.Add using InputBox and/or a URL list in a .txt file list 4
Imported text file to begin from the first empty cell 3
Trying to create a dynamic filepath within VB 3
Assign Web Query Result to a Variable 7

Top