ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   VBA Help (https://www.excelbanter.com/excel-discussion-misc-queries/146490-vba-help.html)

Chris

VBA Help
 
Hi

Is there any VBA that can carry out what the text import wizard does for a
tab delimited file? (.txt)

If so, can you provide the code and explain step by step what it does as i'm
still trying to grasp what does what!!

Many thanks in advance,
Chris

Bob Phillips

VBA Help
 
Execute the Excel facility with the macro recorder turned on, this will give
you the code.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Chris" wrote in message
...
Hi

Is there any VBA that can carry out what the text import wizard does for a
tab delimited file? (.txt)

If so, can you provide the code and explain step by step what it does as
i'm
still trying to grasp what does what!!

Many thanks in advance,
Chris





All times are GMT +1. The time now is 01:39 AM.

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