hi. How do I call a specific excel file
using a Command button in Access ?

thanks

it depends...do you want to open it in excel or import it to access, or what?

al

I want to open the file in excel.

I used this code but it only opens a blank
excel shit:

Dim oApp As Object

Set oApp = createObject "Excel.Application")
oApp.Visible = True
oApp.UserControl = True

the code you posted will only create a new excel sheet (or shit...Freudian?).

you probably can use a hyperlink to open your desired sheet. check Help for hyperlink...

hth,
al


[This message has been edited by pcs (edited 01-20-2002).]