Solved

Is there a Mac version of VBA filedialog object?

Posted on 2006-11-29
3
1,269 Views
Last Modified: 2010-04-25
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
0
Comment
Question by:edrstone
3 Comments
 
LVL 53

Accepted Solution

by:
strung earned 500 total points
ID: 18038157
0
 

Author Comment

by:edrstone
ID: 18386382
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.
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Hi Folks, This article is intended to throw some light or basically give an idea towards taking the first step in the world of Systems Administration. This would in the real context of the word "Systems Administration" which would mean right from…
In this article we will discuss some EI Capitan Mail app issues and provide some manual process to resolve them.
Users will learn how resize a batch of photos from a single command in Photoshop via Photoshop's Image Processor. Open up an Image you'd like to resize in Adobe Photoshop: Adjust the image size according to your preferences. Image > Adjustments > …
Users will learn how to set proper sequence settings, scale images, paste attributes, add transitions, fades, and music. Open up Final Cut Pro 7 and Create a new Project: Set the Sequence Settings. a) Click File > Easy Setup > Format > Apple ProRe…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now