Deploying Excel 2007 VBA Project in an Office 2007 Standard enviro

D

dsimcox

Last year I developed an Excel VBA application in XL2003, and recently
converted it to XL2007.

The application uses the MS Date Time Picker in several User Forms, and in
the XL2007 version, the Date Time Picker is not recognized.

The PC's at my customer's business were upgraded from Office 2003 to Office
2007 Standard. Based the other information I've found, it appears that the
Office 2007 Standard installation does not install the .Net Framework, or the
Date Time Picker control (as well as some others).

Are there any options to correct this situation besides upgrading the
installation (on multiple PC's) to Office 2007 Professional? Can one install
the .NET Framework (and other missing components) separately to achieve
compatibility with my application?
 
J

Jon Peltier

The DateTimePicker is installed when Access is installed. If you don't have
it, you can download and install it yourself. I don't know from where, but
Google should be able to help.

- Jon
 

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

Excel 2007 MS Common Controls 2
date and time picker control in excel vba 1
Fixing Excel 2003 VBA that appears broken in Excel 2007 2
Yield VBA function missing in Excel 2007 11
Running Excel 12.0 Application on Office 2003 2
Change Ribbon in Excel 2007 3
Where do I locate and install VBA CONVERTER for Excel 2007. 3
Programming a macro in Excel Office 2007 to create Pivot Table 1

Top