Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there anyway of using a calendar similar to the VB version in e
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there anyway of using a calendar similar to the VB version in e
The calendar object like most excel objects is giving you the version of the object that was available in windows 2000 to make it forward and backwards compatible from on everion of windows/Office to any other version. The objects like a calendar is really a DLL in you C:\windows\system32 folder. Microsoft has updated all the DLL over time to add new features. VBA has not upgraded the interfaces to these DLL to matain compatiblity. so Usually the solution to these problems is to call the DLL through different interfaces than the standard interfaces provided in VBA. For example the file picker dialog box which I use often is part of the shell32.dll file. In VBA there are at least three methods of getting to this DLL 1) Use GetOpenfilename 2) use the filedialog : Set fd = Application.FileDialog(msoFileDialogFilePicker) 3) Access the DLL directly like this code Declare Function SHGetPathFromIDListA Lib "shell32.dll" ( _ ByVal pidl As Long, _ ByVal pszBuffer As String) As Long Declare Function SHBrowseForFolderA Lib "shell32.dll" ( _ lpBrowseInfo As BrowseInfo) As Long I don't know which feature of the calendar you are trying to use so I don't know which is the best method of solving your problem. I have one program I wrote that uses the calendar but only for selection a date. I would need to know more information to help youi. -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=192441 http://www.thecodecage.com/forumz |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there anyway of using a calendar similar to the VB version in e
Ron de Bruin has some notes:
http://www.rondebruin.nl/calendar.htm RustyOnVBA wrote: -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I save an Excel 97-2003 version or 2007 version for Mac 200 | Excel Discussion (Misc queries) | |||
Strange listbox behavior in version 2003 after version 2007 | Excel Programming | |||
Help Required!!! Macro to load data from version 1 to version 2 | Excel Worksheet Functions | |||
Recover earlier version of excel sheet after new version saved? | Excel Discussion (Misc queries) | |||
Calendar control version conflict? | Excel Programming |