Shawnique Horton
11-17-2000, 01:03 AM
HI ! Can anyone help me. I need to create a macro that can do two things. One: I need to convert all worksheets within a workbook to pdf files and than save those files to another drive. The pdf macro that I have on my Excel toolbar does not do what I want it to do. It only converts one worksheets at a time and prompts a save as box. I do not want it to prompt a box for me to save as. I want this macro to automatically convert and save all. I have the code from that macro, but what VBscript should I add or change to make it do what I want ? Please help. Thanks !