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?

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"dsimcox" wrote in message
...
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?