12.0 Object Library Automatically inserted in 2003 VBA

markb

Guest

Posts: n/a

10th Apr 2008

Hi folks,

I have created spreadsheets with a lot of VBA coding in Excel 2003. I am
using the 10.0 object library reference. When the file is openned with 2007,
the 12.0 object library is automatically referenced. It then works fine on a
2007 machine, but throws an error when it is openned with a machine running
2003 because of the 12.0 object library reference. I am also seeing this
problem on a Mac running Office 2004.

Please help.
--
Markb

« Writing Excel formulas in macros - Help!! | Viewing/Editing/Error Checking KB shortcuts assigned to macros »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Outlook 2003 - Inserted (Embedded) object icon	Helen	Microsoft Outlook Discussion	0	25th Jan 2010 09:16 PM
automatically load an object library in real time	dtshedd@yahoo.com	Microsoft Excel Programming	4	24th Aug 2009 12:59 AM
Re: Excel 2003 sp2 autosum gets inserted automatically	Pete_UK	Microsoft Excel Worksheet Functions	0	10th Nov 2007 12:58 AM
Excel 2003 sp2 autosum gets inserted automatically	=?Utf-8?B?RGF2aWQgU3Rpcmxpbmc=?=	Microsoft Excel Worksheet Functions	0	10th Nov 2007 12:41 AM
In Word 2003, How do I prevent inserted date from automatically u.	=?Utf-8?B?d2RhdmlkXzk5?=	Microsoft Word Document Management	4	11th Apr 2005 03:53 PM