How To Open Any Excel Application

  • Thread starter Thread starter StinkyDuck
  • Start date Start date
S

StinkyDuck

Is there a way to open up any version of Excel without having to explicitly
add a reference? I know how to open up Excel 12 since its installed on my
machine. I just have to add a reference to the Office and Excel COM dll.

What I'm looking to do is open up any version of Excel. Anyone have any
ideas on how to go about doing that?

-StinkyDuck
 
I think I answered my own question. If someone else has some other ideas I
would love to hear/see them.

Dim xlApp As Object

Dim gsGetXLVersion As String

On Error GoTo ErrHandler

xlApp = CreateObject("Excel.Application")

gsGetXLVersion = xlApp.Version
 
Back
Top