Demand now is in the file FileB. Write a Macro in the XLS, by the user option to select a directory FolderA, judge whether there is files in the directory FolderA FileA. XLSM, if any, will file FileA. XLSM worksheetA and worksheetB complete copy to FileB. The specified in the XLS worksheets (contains formula),. If you don't find FileA XLSM, given prompts,
I can in the new VBA, please feel free to comment, thank you.
CodePudding user response:
That, if I didn't describe clearly