Anybody know how to create a Macro to format a comma-deliminated file
Posted by Jim on November 27, 2000 1:12 PM
I have a comma delimited file and I'd like to open
it with excel and have a macro format the data into
the appropriate column headings.
I'm in the development stage and I need to know
how to create an excel macro which will run
when the application (excel) opens the comma delimited
file. I will potentially have up to 300 data fields so
the task of reformating the comma delimited file
everytime the file is generated wil will be tedious
Appreciate any feedback even if it's a nother resource.