Sandy Radjenovic
Board Regular
- Joined
- Nov 4, 2003
- Messages
- 76
How do I import a textfile via VBA & ActiveSheet.QueryTables.Add() without creating a named ranged in my worksheet?
I have code which imports correctly, however, with each import a new named range is created and since this import is done frequently, the # of named ranges from the import file grows quickly.
Any suggestions would be greatly appreciated.
I have code which imports correctly, however, with each import a new named range is created and since this import is done frequently, the # of named ranges from the import file grows quickly.
Any suggestions would be greatly appreciated.