fabriciofcmiranda
Board Regular
- Joined
- Jun 27, 2006
- Messages
- 62
Hi, there,
Sorry for asking such a dumb question, but I can't figure out how to set-up a macro that does the following:
1. Copy the specific sheet into a new workbook;
2. "Save as", so the user can choose the directory and the name of the file when saving it.
I'm sure it's really easy, but I couldn't program it or get it done through the "Record Macro" command.
Thank you very much!
Sorry for asking such a dumb question, but I can't figure out how to set-up a macro that does the following:
1. Copy the specific sheet into a new workbook;
2. "Save as", so the user can choose the directory and the name of the file when saving it.
I'm sure it's really easy, but I couldn't program it or get it done through the "Record Macro" command.
Thank you very much!