Macro to Save a PDF in folder by month

Hi all,

Thanks in advance for your time and apologies if there is a similar post somewhere with in the forum. I've searched around but can't seem to find what I'm looking for.

I was to save my worksheet as a PDF in a folder based on the month in a specific cell. I've previously acheived this but can't for the life of me figure out how I managed it. The worksheet got corrupted and I had to start again.

Here is my current code:

Please Login or Register  to view this content.

Basically, I want it to save in a folder based on a month in a date cell (G13) with the actual file name being "inv 'G15' - 'A14'.pdf" The save name bit currently works but I can't seem to get it to save in the specific folder, which are already generated, if that makes sense.

I've tried something similar as

Please Login or Register  to view this content.

and inserted it as

Please Login or Register  to view this content.

but it saves to a different location with the file name as either "False.pdf" or "invFALSE.pdf"

Any help is much appriciated.

Cheers

Tom

Hi, Tom,

maybe like this

Please Login or Register  to view this content.

Ciao,
Holger

Hi, Tom,

1004 is the worst documented error in Excel VBA to my taste - it could mean about anything, and definitely nothing in specific.

How does the date in Range("G13") look like - that could be one issue. Is the name of the folder Apr if it´s today´s date in G13? Do you have rights to write to the folder? Trusted Location? I altered the path for my computer and the file was saved like I expected it to be:

Please Login or Register  to view this content.

Ciao,
Holger