Saving certain sheets as pdf

[sdts]

hi guys

im trying to select sheets "file" & "file copy" to automatically save as pdf

the thing is i have some existing code ( thanks to Ken Puls )

what i need the macro to do is select "file" & "file copy" then get the macro to save them automatically to a file that is specified with the help of the code below"

Please Login or Register  to view this content.

[sdts]

what i should add is that this code i use above works very well but slightly different to what i want

in cell a2 is a job number that corresponds with a file saved on server

if anyone can help it would be much appreciated
kind regards

[sdts]

bump bump bump

[sdts]

disappointed

[sdts]

first time never got a reply

[royUK]

You don't actually say what the problem is with the code that you have. I can't even se how the code saves as a pdf

[sdts]

hi roy

im trying to select sheets "file" & "file copy" to automatically save as pdf to a specific folder within a folder so it will need to locate the folder based on the number thats in a specific cell

[royUK]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!