CommonDialog Excel 2007 wont work

**dryan83** · 06-30-2010, 08:33 AM

hey,

the CommonDialog function works fine in excel 2003 for my function, but not in excel 2007, is there some way to turn CommonDialog on in excel 2007? here is the code is that is of any help:

Please Login or Register  to view this content.

**Andy Pope** · 06-30-2010, 11:17 AM

Check your xl2003 project for references.

Your code in xl2003 reports an error with regards CommonDialog.

**dryan83** · 06-30-2010, 11:30 AM

how do i check the references in the attached file? sorry but iv never had to add anything in to makes these work before!

**Andy Pope** · 06-30-2010, 11:34 AM

In VBE use menu Tools > References.

Your project has the following references,

VBA Visual Basic For Applications
Excel Microsoft Excel 11.0 Object Library
stdole OLE Automation
Office Microsoft Office 11.0 Object Library
MSForms Microsoft Forms 2.0 Object Library
MSComDlg Microsoft Common Dialog Control 6.0 (SP6)
VBScript_RegExp_10 Microsoft VBScript Regular Expressions 1.0
RefEdit Ref Edit Control
ADODB Microsoft ActiveX Data Objects 2.0 Library
RDO Microsoft Remote Data Object 2.0
RDSServer Microsoft Remote Data Services Server 6.0 Library
RDS Microsoft Remote Data Services 6.0 Library

Those are not all standard so somebody at some point has made those references.

**dryan83** · 06-30-2010, 11:39 AM

ok thanks, is there any way to transfer the references to 2007? this file has been around for years so tracking who originally did it in 2003 would probably be impossible!

**Andy Pope** · 06-30-2010, 11:42 AM

Not transfer as such.

You need to open the file in xl2007, goto VBE, use Tools > References. And then browse for the dll files to include a reference.

If you are not sure of the location check in xl2003 on the Reference dialog for the folder location.