Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 compatability, VBA Reference, MicrosoftOffice12. Object Library
Hi, does anyone know how best to distribute a project developed in
Excel 2007 that forces vba object references to substitue Office12 objects for the appropriate Office 11 references. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 compatability, VBA Reference, MicrosoftOffice12. ObjectLibrary
I don't understand.
If you developed in xl2007 (office 12) and set your references to those office 12 references, wouldn't they still be pointing at the office 12 version when you distributed the workbook? Most people want the opposite--not to force a specific version, but to use whatever is on the recipients pc. If that's what you meant... You may want to look at these links that Tom Ogilvy posted recently: Here are some more extensive references on binding: Use late binding - don't have a reference to excel. http://support.microsoft.com/default...b;EN-US;244167 INFO: Writing Automation Clients for Multiple Office Versions http://support.microsoft.com/default...b;en-us;245115 INFO: Using Early Binding and Late Binding in Automation http://support.microsoft.com/default...b;en-us;247579 INFO: Use DISPID Binding to Automate Office Applications Whenever Possible and Dick Kusleika has a web page at: http://www.dicks-clicks.com/excel/olBinding.htm that explains this with Outlook wrote: Hi, does anyone know how best to distribute a project developed in Excel 2007 that forces vba object references to substitue Office12 objects for the appropriate Office 11 references. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 compatability, VBA Reference, MicrosoftOffice12. Ob
Hi Dave, thanks for this.
In hidsight my post was not very clear,you are right in that I want my distribution to force relevant bindings to User PCs reference sets. I will work through these posts and let you know how I went on. Thanks Samanco "Dave Peterson" wrote: I don't understand. If you developed in xl2007 (office 12) and set your references to those office 12 references, wouldn't they still be pointing at the office 12 version when you distributed the workbook? Most people want the opposite--not to force a specific version, but to use whatever is on the recipients pc. If that's what you meant... You may want to look at these links that Tom Ogilvy posted recently: Here are some more extensive references on binding: Use late binding - don't have a reference to excel. http://support.microsoft.com/default...b;EN-US;244167 INFO: Writing Automation Clients for Multiple Office Versions http://support.microsoft.com/default...b;en-us;245115 INFO: Using Early Binding and Late Binding in Automation http://support.microsoft.com/default...b;en-us;247579 INFO: Use DISPID Binding to Automate Office Applications Whenever Possible and Dick Kusleika has a web page at: http://www.dicks-clicks.com/excel/olBinding.htm that explains this with Outlook wrote: Hi, does anyone know how best to distribute a project developed in Excel 2007 that forces vba object references to substitue Office12 objects for the appropriate Office 11 references. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 compatability, VBA Reference, MicrosoftOffice12. Ob
Another point is that you are asking for trouble if you develop in one
version of Excel and your users are using an earlier version. VBA code is much more likely to be compatible when you run older code on a newer version of Office. However, keywords are frequently added in newer versions, and it's not easy to remember what's new or to avoid using the newer things. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Samanco" wrote in message ... Hi Dave, thanks for this. In hidsight my post was not very clear,you are right in that I want my distribution to force relevant bindings to User PCs reference sets. I will work through these posts and let you know how I went on. Thanks Samanco "Dave Peterson" wrote: I don't understand. If you developed in xl2007 (office 12) and set your references to those office 12 references, wouldn't they still be pointing at the office 12 version when you distributed the workbook? Most people want the opposite--not to force a specific version, but to use whatever is on the recipients pc. If that's what you meant... You may want to look at these links that Tom Ogilvy posted recently: Here are some more extensive references on binding: Use late binding - don't have a reference to excel. http://support.microsoft.com/default...b;EN-US;244167 INFO: Writing Automation Clients for Multiple Office Versions http://support.microsoft.com/default...b;en-us;245115 INFO: Using Early Binding and Late Binding in Automation http://support.microsoft.com/default...b;en-us;247579 INFO: Use DISPID Binding to Automate Office Applications Whenever Possible and Dick Kusleika has a web page at: http://www.dicks-clicks.com/excel/olBinding.htm that explains this with Outlook wrote: Hi, does anyone know how best to distribute a project developed in Excel 2007 that forces vba object references to substitue Office12 objects for the appropriate Office 11 references. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft Excel 11.0 Object Library documentation? | Charts and Charting in Excel | |||
Microsoft Word Object Library in Excel | Excel Discussion (Misc queries) | |||
Excel 2007 Compatability | Excel Discussion (Misc queries) | |||
missing object library | Excel Discussion (Misc queries) | |||
Object library missing | Excel Discussion (Misc queries) |