problem with ActiveSheet.QueryTables.Add for text file

  • Follow


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


0 Replies
1260 Views

(page loaded in 0.037 seconds)

Similiar Articles:
















7/29/2012 12:25:45 PM


Reply: