Maybe you could rename the .csv file to .txt and record a macro when you do it
once.
Then just rerun that macro the next time you need to import that file.
(Keep recording while you add headers/footers/filters/etc and make it really
useful.)
djr wrote:
I need to change the default settings for importing .csv files into Excel so
that I don't have to change the settings every time I do the action.
Is this possible?
Many thanks to anyone who can help me!!!
--
Dave Peterson
|