Hi Everyone,
I am trying to convert a txt file to excel as below. I did a lot of search via google, but no VBA code fit to my case. Can anyone offer some help on my problem, any input is greatly appreciated!
Attached is my sample .txt file.
Supplier Name Supplier Num Taxpayer ID Site Name Address1 City State Zip Code
Do you want to choose you TXT file manually? A window can be opened asking to select the file.
Are those fields the only ones you want to retreive?
Try this macro:Please note that it does not erase data before iimporting the TXT file. It appends data to the existing one.
Please Login or Register to view this content.
Last edited by p24leclerc; 03-20-2014 at 05:31 PM.
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks