Date format when using Text Input Wizard and recording a macro

D

Dave H.

I'm using Text Input Wizard to import a 'fixed width' text file into Excel.
At Step 3 of 3, I change the 'Column Data Format' (specifically 'Date:YMD').
It works ok, but my objective is to get the whole process to work in a
macro. Everything works, except the macro doesn't import the date in the
format I recorded.
Any suggestions?
Thanks,
Dave H.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Which Excel event to call when opening a .txt file 1
fixed width import 3
Texttocolumns and Date Format using Macro - UK International setti 6
Extracting date file modified from a text file. 4
type mismatch error in macro in excel 0
Importing text files using macro 2
Creating a date under the MacroName in VBE when recording a macro 1
Simple Macro freezes the whole Excel and PC! 5

Top