PC Review


Reply
Thread Tools Rate Thread

Defining XLApp as 2007 App on a machine with 2003 and 2007 loaded

 
 
Barb Reinhardt
Guest
Posts: n/a
 
      6th May 2009
We've just deployed Office 2007 enterprise wide and I've just discovered that
some users still have Office 2003 on their machines because an application
they use hasn't been upgraded to Office 2007. Anyway, I have the following
snippet of code

On Error Resume Next
Set XLApp = GetObject(, "Excel.Application")
On Error GoTo 0

If XLApp Is Nothing Then
Set XLApp = CreateObject("Excel.application")
End If

where XLApp is declared as Excel.Application.

On a machine with Excel 2003, it finds the Excel 2003 application, not the
Excel 2007 application. Is there something that can be done so that the
Excel 2007 is found (without changing the code)? I know what I'd do so
this isn't a problem programmatically, but it probably affects 100 or more
folks and deploying a change is probably not the best option at this point.

Thanks,
Barb Reinhardt
 
Reply With Quote
 
 
 
Reply

Thread Tools
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
2003 and 2007 on the same machine Arturo Microsoft Access 3 19th Mar 2010 08:39 PM
Re: Outlook 2003 form cannot be loaded in 2007 Sue Mosher [MVP] Microsoft Outlook Form Programming 0 11th Dec 2009 01:38 AM
Outlook 2003 form cannot be loaded in 2007 form_rookie Microsoft Outlook Form Programming 0 11th Dec 2009 12:59 AM
Defining a template that will work in both 2003 and 2007 PFflyer Microsoft Powerpoint 1 21st Apr 2009 05:00 PM
2003 & 2007 on same machine =?Utf-8?B?U2VjcmV0IFNxdWlycmVs?= Microsoft Access 29 31st Jan 2008 03:37 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:05 PM.