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
|
|
0
|
|
|
|
Reply
|
G
|
3/13/2010 4:43:15 PM |
|