I am looking for a simple code to do the following:
1. Copy ONE spreadsheet from an excel workbook into a new workbook.
2. Create the new workbook as part of the macro.
3. Save the new workbook as part of the macro.
4. The saved filepath will be different only in the FILENAME, which somehow must be referenced from the original excel file (possibly from a specific cell reference from a different spreadsheet).
5. Fantasy macro - do the same to word.
I have tried several variations on macros offerend in this website and others, and can't get anything to work. I am not a programmer at all, but have been able to modify other macros in the past to work.
Any help is appreciated!!!!!!!
1. Copy ONE spreadsheet from an excel workbook into a new workbook.
2. Create the new workbook as part of the macro.
3. Save the new workbook as part of the macro.
4. The saved filepath will be different only in the FILENAME, which somehow must be referenced from the original excel file (possibly from a specific cell reference from a different spreadsheet).
5. Fantasy macro - do the same to word.
I have tried several variations on macros offerend in this website and others, and can't get anything to work. I am not a programmer at all, but have been able to modify other macros in the past to work.
Any help is appreciated!!!!!!!