Print PDF using VBA on Mac without specifying path

[Nicoaus]

Hey guys,
I'm trying to make a macro that can save a pdf from an active sheet to the desktop without me specifying the user. Is this possible? I'm asking as the file is going to be used by multiple people and I'll have to replicate the macro 10 times. So to avoid changing the code 100 times to specify the user, is there a way to avoid any access issues by not mentioning the user and somehow getting the document saved on desktop?

Kind Regards,
Nico

 

[Jim Gordon]

You can use VBA to determine current file path using CURDIR and then manipulate the text string to whatever you want.

 

[JumboCactuar]

you can find the desktop location of current user with this:

Dim strPath As String
strPath = Environ("USERPROFILE") & "\Desktop\"

 

[Jim Gordon]

When in Mac OS you can't use Windows file path separators \ you must use forward slashes / and also use complete file paths