How to open an Excel workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am able to open Excel through a button on an Access form, but I can't seam
to get Excel to open a specific workbook.

Any ideas?
 
Assuming you've correctly instantiated Excel, you need to use its Open
method.

For instance, here's code I use:

If fIsAppRunning("Excel") Then
Set xlCurr = GetObject(, "Excel.Application")
booXL = False
Else
Set xlCurr = CreateObject("Excel.Application")
booXL = True
End If

Set wkbCurr = xlCurr.Workbooks.Open(strFile)

(fIsAppRunning is from http://www.mvps.org/access/api/api0007.htm at "The
Access Web")
 
You must log in or register to reply here.

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 Protection 2
Excel How to Fix Damaged Excel File That Won't Open? 3
Using Already Open Workbook 3
Access - Excel Integration 1
Access VBA to open Excel workbook, save as a dbf (I think) 5
Excel shortcut options 0
Run Excel Macro from Access 2
Import same Excel ranges from many workbooks 3

Back
Top