Macro to reformat and save document
Posted on 2009-05-19
Every morning I have to download about 40 .doc and then open each file, reformat the margins and fonts and save it as a .docx file with the same name as before (yesterdaytransactions.doc reformated and saved as yesterdaytransactions.docx). I used the record macro to create a macro to reformat it, but then I have to manually save it and close the file. Then delete all the .doc files.
Is there a way I can do this without opening each file in word? If not is there a way to make the same macro save the file. I know very little VB.