Automating The Text Import Wizard Process

P

purceld2

Well-known Member
Joined
Aug 18, 2005
Messages
586
Office Version
  1. 2013
Platform
  1. Windows
My question is is it possible to automate the Text Import Process. The reasons why I want to do this is I get approximately 25 ".txt" files daily which I currently manually import into excel using the wizard which is time consuming and repetitive then I have to formatted and saved a an ".xls" file. I would like to automate the formatting part too.

Examples of the files names below

W080410.txt
W090410.txt
W100410.txt

See Post "VBA to removed unwanted rows" Posted on 19/04/201009:23 PM full detail of the above files.

Any assistance will be greatly appreciated.
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
Sort by date Sort by votes
Turn on the macro recorder and let it record the process of you importing one or two sheets manually the way you want them.

Post that code here and we can help you make the macro more dynamic and work on multiple text files in a folder.
 
Upvote 0
Thanks for your reply please see "Help With Some VBA Code" posted 12:07 today this is the code I recorded
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question
Help with automation
Replies
2
Views
226
Anonymous1378
A
jakeman
  • Question
VBA Solution for Parsing Information from Text file
Replies
1
Views
444
Bosquedeguate
Bosquedeguate
N
  • Question
Want to automate the Powershell Process
Replies
2
Views
359
RoryA
RoryA
R
  • Question
Generate Txt File VBA Question
Replies
6
Views
316
rlv01
R
S
  • Question
Importing multiple .txt files having the current date in the filename using VBA
Replies
0
Views
385
shubhamsinghrathore
S

Forum statistics

Threads
1,214,659
Messages
6,120,786
Members
448,992
Latest member
prabhuk279

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top