i inherited this situation, there must be a simpler way:
i have this table that i export to excel. once it is there, i copy and paste a macro, then highlight all the info to run the macro. then i have to open the file and add a code to the first line. whatever the case, it is slow and cumbersome and leaves room for a lot of error. i want to automate it.
essentially what needs to be done is the follows:
all the fields must be enclosed in quotations. the first line needs the code "108" added to it. the whole file needs to be saved as a .dat file.
is there a simpler way?
i have this table that i export to excel. once it is there, i copy and paste a macro, then highlight all the info to run the macro. then i have to open the file and add a code to the first line. whatever the case, it is slow and cumbersome and leaves room for a lot of error. i want to automate it.
essentially what needs to be done is the follows:
all the fields must be enclosed in quotations. the first line needs the code "108" added to it. the whole file needs to be saved as a .dat file.
is there a simpler way?
