How To Open Any Excel Application

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
 
S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to Fix Damaged Excel File That Won't Open? 3
Open Office 11
Excel AddIn - Keeping windows form always visible while w/in Excel 0
Excel 1
Trouble Installing Excel VBA Code Cleaner into Office 365 0
Excel How to enable engineering functions in MS Excel 2000? 3
using excel from dotnet 11
adding reference to an COM-object in VB doesn't work 1

Top