How to get the applications folder path

[Mac Office Developer]

what is the VBA command to get the application folder path in mac office 2004?

 

[John McGhie]

Can't be done in VBA: look in the AppleScript dictionary.

what is the VBA command to get the application folder path in mac office 2004?

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:[email protected]

 

[Peter Jamieson]

You could try:

Function getApplicationsPath() As String
getApplicationsPath = MacScript("path to applications folder as text")
End Function

Peter Jamieson

http://tips.pjmsn.me.uk

 

[Mac Office Developer]

that works perfectly... thanks!

You could try:

Function getApplicationsPath() As String
getApplicationsPath = MacScript("path to applications folder as text")
End Function

Peter Jamieson

http://tips.pjmsn.me.uk


.