Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ActiveSheet.QueryTables.Add David Excel Programming 0 March 10th 08 10:39 PM
ActiveSheet.QueryTables.Add using InputBox and/or a URL list in a .txt file list crazy_vba[_5_] Excel Programming 4 April 29th 06 10:54 PM
ActiveSheet.QueryTables.Add Rick Excel Programming 4 November 10th 05 04:24 AM
ActiveSheet.QueryTables.Add using a File DSN Brian Howenstein Excel Programming 1 April 6th 04 11:45 AM
With ActiveSheet.QueryTables.Add [email protected] Excel Programming 4 January 6th 04 04:58 PM


All times are GMT +1. The time now is 03:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"