View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
G.R. Toro G.R. Toro is offline
external usenet poster
 
Posts: 16
Default 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