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