Common Dialog Box

G

Guest

I'm creating an application in Excel. In my Visual Basic sheet, I checked the
box in tools-references for 'Microsoft Common Dialog Control 6.0'. But when I
try to insert a 'Microsoft Common Dialog Control, version 6.0', I get the
message, "Cannot insert object". I'm trying to insert a 'showopen' dialog.
I've tried everything to get the object inserted but without success. Can
someone help?
 
J

Jim Rech

Excel developers typically use the Application.GetOpenFilename method.

--
Jim Rech
Excel MVP
| I'm creating an application in Excel. In my Visual Basic sheet, I checked
the
| box in tools-references for 'Microsoft Common Dialog Control 6.0'. But
when I
| try to insert a 'Microsoft Common Dialog Control, version 6.0', I get the
| message, "Cannot insert object". I'm trying to insert a 'showopen' dialog.
| I've tried everything to get the object inserted but without success. Can
| someone help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Microsoft Common Dialog Control 2
Workbook code works on my machine but noy others 6
Excel 97 - Common Dialog Control Help 5
How to reference shdocvw? 2
References Different on different machines 3
common dialog box 1
Open File Dialog Box on UserForm 1
Common Dialog Box 2

Top