Save current WS as PDF, under specific name & location

[amar05]

Hi guys,
One of the co-workers I work with, made a macro that will save the current worksheet in a specific folder and under a specific name. Please find the code below:

Please Login or Register  to view this content.

Cell B50 contains the following:

Please Login or Register  to view this content.

Cell B25 contains the coworkers' information.

My question is: Instead of referencing cell B50, can the formula be integrated into the macro?

Thanks.

[protonLeah]

Please Login or Register  to view this content.

[amar05]

Hi protonLeah,
Thank you for your reply. Most of the code works. The only thing that's it not doing is; when B25 is empty, it doesn't include "2000". Any ideas why?

Thanks

[protonLeah]

amar05: "Cell B25 contains the coworkers' information."

Since I don't know what that info is, you can try this mod:

Please Login or Register  to view this content.

[amar05]

It works like a charm.

Thank you so much.