Hello,
I am hoping someone can help me with a VBA that looks into a specific folder "C:\2019\Q1_2019" for a file extension ".jcp" that will open each file in excel and save those excel files in another folder "C:\Horse Racing Data\JCP Files\2019". I would like to have those saved excel files have the same naming conventions as the .jcp files which have the same format look like this, MVR0128.jcp. Would also be great if I can run the excel VBA once a week and only copies the files from my first folder that are not include in the second folder.
I really appreciate everyones help on this.
Bookmarks