If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Reference to external program

Thread starter Jos Vens
Start date Jul 28, 2009
Tags

object reference reference a file

Jos Vens

New Member

Jul 28, 2009

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).

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

Thanks in advance
Jos Vens