Canadianexcel
New Member
- Joined
- Dec 23, 2010
- Messages
- 39
Good Evening,
I am hoping someone can get me started. I have done numerous google searches but didn't find exactly what I wanted to start me off. I have built out a xlsm file with multiple macros and VBA code due to security reason I had a request to build an export macro to export certain sheets to an xlsx file to prevent whoever we send the file to can't see the logic or VBA code which I completed and works well. The next step I would like to accomplish is when we receive the xlsx file I would like to compare the xlsx and xlsm file and copy columns C:E from sheet1 from whatever.xlsx file name is into myfile.xlsm sheet1. I could figure this out whoever the wall I am hitting is it maybe sheet 2 or what ever sheet may have been selected to send out to the person these could be one sheet or multiple sheets. I know about arrays and the For each code for sheets with one workbook but not quite sure how to do this with multiple files. I hope I explained this correctly for someone to give me a start.
I am hoping someone can get me started. I have done numerous google searches but didn't find exactly what I wanted to start me off. I have built out a xlsm file with multiple macros and VBA code due to security reason I had a request to build an export macro to export certain sheets to an xlsx file to prevent whoever we send the file to can't see the logic or VBA code which I completed and works well. The next step I would like to accomplish is when we receive the xlsx file I would like to compare the xlsx and xlsm file and copy columns C:E from sheet1 from whatever.xlsx file name is into myfile.xlsm sheet1. I could figure this out whoever the wall I am hitting is it maybe sheet 2 or what ever sheet may have been selected to send out to the person these could be one sheet or multiple sheets. I know about arrays and the For each code for sheets with one workbook but not quite sure how to do this with multiple files. I hope I explained this correctly for someone to give me a start.