Macro to select all worksheet and save file as file name

[Luis Ferreira]

Good Afternoon,

I want to create a macro that will select all the worksheets (names and quantity will vary) and saves the file as the current file's name but in PDF. Since I only know how to record a macro it specifies the worksheet names but I need it for various workbooks. The name will vary plus the number of tabs can go anywhere from 3 to 40.

Thank you,

Luis

 

[Luis Ferreira]

I am Sorry, just one more question. Why does it move one folder back when it saves intead of its current location?

 

[Mohammad Basem]

Sorry, couldn't get your point. What do you mean by Folder? Is it disk Folder? Do you mean the file is saved to the wrong folder?

 

[Luis Ferreira]

For example:

if the file is saved in this folder
F:/Accounting/2012

but is saves in:
F:/Accounting

 

[Mohammad Basem]

So you want to save the PDF file to the same folder of the original workbook. Correct?

You can select the folder via the folder dialog window and it will stay there until you change it.

Or, am I missing something?

 

[Luis Ferreira]

The window dialog is not opening

 

[Mohammad Basem]

What Excel version are you using? This should work with 2007 and 2010.

 

[Luis Ferreira]

Sorry, the window opens but goes back one folder, I was wondering if there is a way to keep it in the same folder (current location)

 

[Luis Ferreira]

2007

 

[Mohammad Basem]

This is weird!

So when you run the macro you just get your PDF file, and nothing else?

The only advise i can give right now is to double check the code has been copied without any missing line. It is working just fine on my system.

When running the macro, you are supposed to see a window to select destination folder, then you get your PDF file preview. If the file already exists, then you will get a warning box.

Please check the above and let me know which part is not working.

 

[Luis Ferreira]

The window opens to select a folder, but I would like to save it on it is current location without having to select a folder.