LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 23
Default appXL = CreateObject("Excel.Application")

Hi

Both Excel 2003 and Excel 2007 are installed on a subset of machines
How to control the object version open when this script line is executed ?
Set appXL = CreateObject("Excel.Application")

The test on two machines shows that it is the xcel 2003 (version 11.0) that
is opened, the same one you get if you doubleclick on an .xls file while
neither Excel 2k3 nor Excel 2k7 is opened...

Does it mean there is somewhere a variable that tell to Office which Excel
to open in case several would be installed ?

Thanks for your help
Alain


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CreateObject("Outlook.Application") Howard31 Excel Programming 5 January 26th 10 01:41 AM
CreateObject("Excel.Application") Olivia Towery Excel Worksheet Functions 4 June 12th 06 12:07 AM
Set OutApp = CreateObject("Outlook.Application") - Runtime error 429 Buffyslay Excel Programming 2 July 20th 05 05:06 PM
ASP: CreateObject("Excel.Application") IIS 6.0 Win2003 Mau[_2_] Excel Programming 0 July 20th 05 11:45 AM
CreateObject("Excel.Application") - Access denied Luca[_2_] Excel Programming 0 February 6th 04 01:21 PM


All times are GMT +1. The time now is 10:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"