Error in vba code (macro) that saves my file in folder?

[Jyggalag]

Hi all,

I have this macro:

Once I press the macro "Save file to folder", I get the error above, and debugging it leads me to this:

I want to save my file as a PDF file in the path above. Any idea why it does not work and how I can fix it?

Kind regards,
Jyggalag

 

[Domenic]

When the error occurs, enter the following line in the Immediate Window (Ctrl+G) . . .

? Path & fn & ".pdf"

Does it return the correct path and filename? And, if so, does the file actually exist in the folder?

 

[Jyggalag]

Hi

When the error occurs, enter the following line in the Immediate Window (Ctrl+G) . . .

? Path & fn & ".pdf"

Does it return the correct path and filename? And, if so, does the file actually exist in the folder?

Hi Domenic,

I have never used the Immediate Window. I have typed the code you gave me into it now, but no idea what to do now? if I run the code the error still pops.

P.S. The file path is correct, I just tested it and I can go there through the link from the VBA and see my files.

I have another backup file of this excel document that does work, but once I started recording some macros in this file, it messed up my VBA (even though I have now deleted those macros).

Super weird and really dont get it

 

[Jyggalag]

When the error occurs, enter the following line in the Immediate Window (Ctrl+G) . . .

? Path & fn & ".pdf"

Does it return the correct path and filename? And, if so, does the file actually exist in the folder?

 

[Jyggalag]

Ne

When the error occurs, enter the following line in the Immediate Window (Ctrl+G) . . .

? Path & fn & ".pdf"

Does it return the correct path and filename? And, if so, does the file actually exist in the folder?

I fixed it!

It was because my cell range had moved from A35 to A39. I missed this.

My bad, apologies for the confusion! Very new to VBA and macros