Link to home
Start Free TrialLog in
Avatar of edrstone
edrstone

asked on

Is there a Mac version of VBA filedialog object?

I am using the VBA scripting in Microsoft Excel to write a conversion routine for a client. My client is now wanting to run this conversion on Mac's version of Excel. The conversion crashes when it gets to the 'filedialog' object that I use to allow the user to browse to a file on the computer. Is there a 'Mac Version' of the filedialog object that will do the same thing from withing the Excel Macro?

Thank you in advance for your help.

Ed
ASKER CERTIFIED SOLUTION
Avatar of strung
strung
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of edrstone
edrstone

ASKER

Oh sorry that I didn't respond. My bad:

The links you provided where helpful. My end solution was to use the MacScript Function to open a file dialogue.