ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   problem with ActiveSheet.QueryTables.Add for text file (https://www.excelbanter.com/excel-programming/440595-problem-activesheet-querytables-add-text-file.html)

G.R. Toro

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




All times are GMT +1. The time now is 08:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com