Hi! I am really new to VBA and had to trying to figure out my question in two weeks. Any help would be much appreciated!
I need to merge multiple word documents in FolderA into one document (either doc or pdf, doesn't matter) and then print it. (Print step can be done manually if can't be done through vba.) When merging the word documents, it needs to start with a new page every time (page break.) ---I have done this successfully with word vba but not through excel vba.
After the merging step, I need to archive the word documents into different folders based on the date information in the file name. The format of the filename is A_001_03012020.docx. I need to read the "03012020" information from the file name and then move this file to a new folder called "Completed.03012020". This new folder should contain every file with data"03012020" in file name in the original FolderA. ---In my word vba, I can move all the printed files into one new-created-folder, but can't move them distinguishably based on the date information in the file name.
If the file name is not easy to extract and use, created date will work in my case as well. The process of archive into different new-created-folder(if the folder already exists, just simply move into) based on the date information is the most critical and complex part. Thank you again for your kindly help!!
I need to merge multiple word documents in FolderA into one document (either doc or pdf, doesn't matter) and then print it. (Print step can be done manually if can't be done through vba.) When merging the word documents, it needs to start with a new page every time (page break.) ---I have done this successfully with word vba but not through excel vba.
After the merging step, I need to archive the word documents into different folders based on the date information in the file name. The format of the filename is A_001_03012020.docx. I need to read the "03012020" information from the file name and then move this file to a new folder called "Completed.03012020". This new folder should contain every file with data"03012020" in file name in the original FolderA. ---In my word vba, I can move all the printed files into one new-created-folder, but can't move them distinguishably based on the date information in the file name.
If the file name is not easy to extract and use, created date will work in my case as well. The process of archive into different new-created-folder(if the folder already exists, just simply move into) based on the date information is the most critical and complex part. Thank you again for your kindly help!!