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