vba Run-Time error '1004':

[jreedp]

it worked once then i kept getting the same message

'1004'
Method 'ExportAsFixedFormat' of object 'Range' failed
my vba is:

Sub EXP_PDF()


Dim rng As Range
Set rng = Range("E3:N108")

Dim fileName As String
fileName = "Macintosh HD:Users:jamiecroft:Documents:JRC Music Services:Invoice PDF:Invoive test.pdf"

rng.ExportAsFixedFormat Type:=xlTypePDF, _
fileName:=fileName, Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=True, _
From:=1, To:=1, OpenAfterPublish:=True
End Sub

 

[jreedp]

thanks to anyone that can help me sort the problem.

 

[jreedp]

When i select debug it hight lights the bottom:

rng.ExportAsFixedFormat Type:=xlTypePDF, _
fileName:=fileName, Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=True, _
From:=1, To:=1, OpenAfterPublish:=True
End Sub

 

[shg]

Does the directory exist, ezzzactly as spelled?

 

[jreedp]

yeah i copied of from path

 

[shg]

No suggestion, sorry -- never touched a Mac.

 

[jreedp]

well if it was microsoft the file name would look something like this
Macintosh HD:Users:jamiecroft:Documents:JRC Music Services:Invoice PDF:Invoive test.pdf
C:/Users/jamiecroft/documents/jrc music services/invoice pdf/incoice .pdf

if that helps you at all

 

[jreedp]

i can save the workbook to .pdf.

its is having problems with saving a range to .pdf -- dose anyone no a way of getting a similar result please

 

[shg]

Works fine for me in W7.