VBA to save one sheet as PDF DO NOT PRINT

[FORTYSIX]

I’m not very familiar with VBA but I think I’ve managed to get the basics. USING MAC

What I’m looking for:

I want VBA to save sheet1 (NB) as a PDF

we have multiple users, not too sure how to make it accessible for all. (Using Mac)

Want file to save as cell text in Cell A4


What’s currently happening is the PDF is trying to find a printer and not saving?

Any advice would be much appreciated!

Code below:

Sub TESTINGMACRO()
Dim path As String
path= “/Users/Sue/Documents/business name/External Documents/NB Docs/“& Sheets(“NB”). Range(“A4”).Text
Sheets(“NB”).ExportAsFixedFormat Type:=x1TypePDF, _
FileName:= path
End Sub

[Artik]

Probably the problem is related to the wrong constant name. Instead of x1TypePDF, it should be xlTypePDF.

Artik

[FORTYSIX]

Probably the problem is related to the wrong constant name. Instead of x1TypePDF, it should be xlTypePDF.

Artik

doh!

Regarding the user in the path section, have you any idea how I can get this to change per username via Mac?

[Artik]

I don't use a Mac. Try to build the path chain this way

Please Login or Register  to view this content.

Artik