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: 4
Default Reference to external program

Hi,

I'd like to know if it is possible to make a reference in vba to an external
program.

Now, I can make an object-reference to Excel like this:

Set xlExcel = New Excel.Application
xlExcel.Visible = True
xlExcel.Workbooks.Open vFile, False, True

I'd like to do the same, but now to a different (not registered in windows)
program. The reason is this: I made a portable version of excel (including
VBA) and I want to let my application start with that portable version
(Excel 2003), even if Excel 2007 is installed. In that case, I do not depend
on the caprices of Microsoft for my further development (like menu's which
disappear in office 2007).

My new code should be (Excel2003 = portable version of Excel 2003)

Set xlExcel = New Excel2003.Application
xlExcel.Visible = True
xlExcel.Workbooks.Open vFile, False, True

It would also be interesting to do this to other programs I use within VBA.
I think it has to go within the Class Module-section, but I don't know how
to start.

Thanks in advance
Jos Vens


 
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
calling external program from VBA [email protected] Excel Programming 1 January 26th 07 08:58 AM
Run external program. Tom Excel Programming 1 April 14th 05 01:03 PM
Can I run an external program? [email protected] Excel Programming 17 December 7th 04 11:23 PM
How do I run an external program? Phillips Excel Programming 1 November 25th 03 05:23 PM
Open external program bondy Excel Programming 1 October 22nd 03 01:57 PM


All times are GMT +1. The time now is 04:41 AM.

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

About Us

"It's about Microsoft Excel"