[Mac] Start non-Excel non-commercial app

[ddaanntt]

I want to start a Mac app I've written (using Mac's Xcode) from an Excel VBA script. The app's signature is "DanT". My command is

Shell(MacID("DanT"))

If I substitute "MSWD" for "DanT" then Word starts up, as I'd expect, but with DanT there I get the message "Run-time error '68': Device unavailable". Is my command correct? Has anyone had any experience with this?

Thanks very much.

- Dan

 

[ddaanntt]

I hope *very* much to get an answer to my previous post, but in the event that I do not, I've come up with this:

Reserve an Excel cell to hold the path to the application that I want to start up. If this cell is empty (as it will be initially), then prompt for the path to the application using GetOpenFilename. But when I call GetOpenFilename, it grays out all applications. Arghhh!!! Is there a way to have the user point to the application? Also (minor but irritating point), the Mac version doesn't seem to provide a parameter to supply the prompt (e.g., "Please select the AdChecklist program.").

I *knew* they were all out to get me. Any ideas? Thanks.