Thread: Choosing the Version of Excel when opening an instance
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave[_76_] Dave[_76_] is offline
external usenet poster
  
Posts: 5
Default Choosing the Version of Excel when opening an instance
I'm using vba with ms project and excel, pulling the tasks from project to
excel. I have excel 2007 and 2003 installed on my computer. By default
when I use
Set xlApp = New Excel.Application
xlApp.Visible = True
AppActivate "Microsoft Excel"

The 2007 version is used. I would like to use the 2003 version. Any help
is appreciated.

Cheers


Reply With QuoteReply With Quote