View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Object Library problem

Sounds like you are using early binding (adding the reference at design time
instead of run time). Change to late binding something like this...

dim appOutLook as object

set appOutLook = CreateObject("OutLook.Application")

Now you are not hooked into any specific version of OutLook...
--
HTH...

Jim Thomlinson


"djExcel" wrote:

Problem is like this: I've made a system, where one user fills in the title
area of a worksheet and system sends an e-mail to selected user. After that
the other user fills in the rest of the worksheet and press 'Ready'-button,
which sends again an e-mail to the user, who originally filled in the title
area. System works ok, but if these two users have different version of Excel
(e.g. 2000 and 2003), then the newer version changes the version of Microsoft
Outlook Object Library (Tools / References in Visual Basic Editor) and after
that the older version can't open the file (gives an error message). Is it
possible to set appropriate version of Object Library programmatically
instead of choosing Tools / References command in Visual Basic Editor and
selecting Object Library there?