I just started learning excel macros.
I have a bunch of csv files which I was able to manipulate with a macro for the desired output. I tried to save the final csv files as xls files. If I auto closed all the active workbooks, xls files were saved, but somehow they do not contain the desired output data generated by the macro. If I left the active workbooks open, I can see the desired output data in each file. I must now use "save as" and change the format manually from csv to xls or xlsx and then save the files one by one.
Below is the final portion of my macro:
________________________________________________________________________________________________________________
________________________________________________________________________________________________________________Please Login or Register to view this content.
I wonder what did I do wrong. Also with the above, the xls files are saved to the c:\ root. I would like to save them to a designated folder instead.
Much appreciate if any one can help.
Thank you very much!
Henry
Bookmarks