Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Compilation using Application.Version
Chip Pearson posted this: You can use Conditional Compilation combined with CallByName to do what you want. For example, #If VBA6 Then If CInt(Application.Version) 9 Then ' Excel 2002 or 2003 CallByName Application.CommandBars, "DisableCustomize", VbLet, True Else ' Excel 2000 End If #Else ' Excel 97 #End If Philip wrote: Hi, I need to do something like this: #If Application.Version = 11 Then Application.CommandBars.disablecustomize = True #End If the reason is, the desktop pc's are being migrated from Office 2000 to Office 2003 and I want this code to run if the version is greater then 11 (Office 2002 ?) The 'disablecustomize' member is not available in Office 2000... So how can I do this...? thanks Philip -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Office application version does not match. | Excel Discussion (Misc queries) | |||
Late Bind to Specific version of Application | Excel Programming | |||
Help in using Application.Version | Excel Programming | |||
Office automation application which will work with any version of office C#.NET | Excel Programming | |||
Conditional compilation | Excel Programming |