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!

 

[RoryA]

What precisely is in A39 on the active sheet?

Edit: just noticed your path is missing a backslash after the colon

 

[Jyggalag]

Hi

What precisely is in A39 on the active sheet?

Edit: just noticed your path is missing a backslash after the colon

Please ignore the path, I just inserted something to hide my actual path, I think the path is alright

In A39 the cell is blank actually, well spotted!

I cant remember if im supposed to have something here, this is an old file I dug up, can you tell based on the code?

 

[Jyggalag]

What precisely is in A39 on the active sheet?

Edit: just noticed your path is missing a backslash after the colon

I think it is the cell that names what the file should be named.

however, if I change this to A51 (which is the correct cell, dont know why it was changed), it still gives me an error:

And debug highlights this:

 

[RoryA]

The code itself is fine, so there is either something wrong with the path (doesn't end in a backslash for example) or the file name, or you don't have permission to write to that location.

 

[Jyggalag]

The code itself is fine, so there is either something wrong with the path (doesn't end in a backslash for example) or the file name, or you don't have permission to write to that location.

that is so weird

the path is 100% fine I am sure of this and nobody has the PDF open

never seen this error before and no idea how to fix

 

[RoryA]

Does a PDF with that name already exist at the specified location?

 

[Jyggalag]

Does a PDF with that name already exist at the specified location?

I don't think so,

It saves the name with a number rather than as a PDF.

However, I tried removing all the PDF files and it still did not work, even with an empty folder

 

[Jyggalag]

Bump

 

[RoryA]

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?