Debug error with macro

[Jyggalag]

Hi all,

I currently have a macro that saves my sheet as a PDF, however when I try to do this, it brings me this error:

If I debug it highlights this in my VBA code:

The code is this:

Option Explicit

Sub SaveFileWithMacro()

Dim Path As String
Dim fn As String
Path = "R:Path\PDF files\"
fn = Range("A39")
ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, _
    Filename:=Path & fn & ".pdf"

End Sub

Can somebody help me fix this issue please? Would be much appreciated!

 

[Jyggalag]

As I said yesterday, there's nothing wrong with the code syntax, so it's either environmental (permissions etc) or the values of your variables are not actually valid. If you add a Debug.Print Path & fn line, does the output look correct? Can you copy the path into an explorer window and have it actually open?

Hi Rory,

I fixed the issue!

The issue was that I had the cell, for which the file were saved under, naming the file "XYZ dddd/mm/yy".

However, documents will not allow names to be saved with a backslash in them "/", so this is what caused the issue.

I have amended my formula so it now saves the file as "XYZ dddd-mm-yy" instead

Apologies for the confusion and issues, turned out the code was just as you said (of course ). Thank you so much for your help nonetheless, it definitely sped up the process!