Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem with ActiveSheet.QueryTables.Add for text file
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ActiveSheet.QueryTables.Add | Excel Programming | |||
ActiveSheet.QueryTables.Add using InputBox and/or a URL list in a .txt file list | Excel Programming | |||
ActiveSheet.QueryTables.Add | Excel Programming | |||
ActiveSheet.QueryTables.Add using a File DSN | Excel Programming | |||
With ActiveSheet.QueryTables.Add | Excel Programming |