Import Text File Into Existing Workbook Using VBA

[Geth]

HI

Does anyone know how to import a text file (semi colon delimited) into an existing workbook in VBA. The name of the existing workbook changes daily, however the filename & path of the file to be imported does not change.

The only version I know of (by recording a macro) opens the file in a new workbook

 

[Norie]

Record a macro when you goto Data>Get External Data... Import Text File.

That should give you code to open the text file into an existing workbook.

 

[Glaswegian]

Chip Pearson has a routine for importing into an existing sheet here - should give you a start.

Regards

 

[Geth]

Unfortunately my version of excel (97) does not allow me to import a text file through that method.

It only allows the user to import by query or web or database etc

 

[Glaswegian]

Unfortunately my version of excel (97) does not allow me to import a text file through that method.

It only allows the user to import by query or web or database etc

Geth

I've used Chip's code successfully in XL97 to import a text file dropped on a server by our IT guys. The code opens a dialog box and the user changes directory/folder to find the file - thecode does the rest.

 

[Geth]

Eeep, Sorry Glaswegian, I was responding to Norries post - I'll try the code later

 

[Norie]

Geth

I thought that might be the case in 97.

Is there not an option under database query for text files?