Calling excel from a form

[E-D]

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

thanks

 

[pcs]

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

al

 

[E-D]

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

 

[pcs]

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).]