Printing PDFs with a File Path linked to a cell.

Hi all,

I'm running into a problem when running the following piece of code:

PHP Code: 

ActiveWorkbook.Worksheets(SheetName).ExportAsFixedFormat _
    Type:=xlTypePDF, _
    Filename:=FilePath & Filename, _
    Quality:=xlQualityStandard, _
    IncludeDocProperties:=True, _
    IgnorePrintAreas:=False, _
    OpenAfterPublish:=False 


I'm linking the variable, "FilePath" to a cell on a sheet using:

PHP Code: 

FilePath = ActiveWorkbook.Worksheets(CommandSheet).Cells(2, 8) 


The value it returns is: C:\Users\Harry.Greenwood\Documents\Excel PDFs\

The code executes, but doesn't create a PDF.

When I manually paste the file path in, it works fine however.

Any ideas?

Apologies, the PDF's were just taking a long time to create!