mortgageman
Well-known Member
- Joined
- Jun 30, 2005
- Messages
- 2,015
I tried to use the macro recorder for this. I have a workbook with 7 sheet. Lets call the sheets one, two, three, four, five, six, and seven.
I want to save 6 of these sheets as PDFs. Lets say the sheets that I want to save are two, three, ..., seven. I do not want the save as prompt as part of the macro (here is where I run into problems with the macro recorder). I just want to run the macro and have them all saved.
(Even better, I would like them saved to sub directory "My Online Files" - but that is a minor point that I could live without).
Thanks for any help here
Gene Klein
I want to save 6 of these sheets as PDFs. Lets say the sheets that I want to save are two, three, ..., seven. I do not want the save as prompt as part of the macro (here is where I run into problems with the macro recorder). I just want to run the macro and have them all saved.
(Even better, I would like them saved to sub directory "My Online Files" - but that is a minor point that I could live without).
Thanks for any help here
Gene Klein