Open MS Excel file from Access VBA Code??? 2

[grobermatic]

Hi,

My code creates a MS Excel file from a query's results usinq SQL.

I want to give the user the option to open the file I just created from the VBA code.

Any Ideas?

Thanks

Craig

 

[GHolden]

If you add a reference to the Microsoft Excel Object Library you can use...

Dim appExcel As New Excel.Application

appExcel.Visible = True
appExcel.Workbooks.Open "C:\Test\Test.xls"

There are two ways to write error-free programs; only the third one works.

 

[jebry]

Hi!

Assuming you capture the path and name of the Excel workbook you create you can use the following:

Dim ExcelBook As Excel.Workbook

Set ExcelBook = Excel.Workbooks.Open(Yourfilenameandpath)
ExcelBook.Application.Visible = True

hth
Jeff Bridgham
bridgham@purdue.edu

 

[grobermatic]

thanks for the quick responses,

How do I add a reference to the Microsoft Excel Object Library?

I think I need to know this in both cases?


Craig

 

[jebry]

Hi Craig!

In your code window go to Tools/References. In the dialog box will be a list box, scroll down until you find MS Excel and put a check in the box beside the latest version. When you say ok the reference will be added.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[grobermatic]

Just the job... thanks for your help

Craig