opening an excel file from access

[St0rm]

I have look thought the old threads and can not find the answer.

I have a form and when i click a button i need it to open an excel file.

the closes i have got is :-

Set oApp = CreateObject("Excel.Application&quot
oApp.Visible = True
On Error Resume Next
oApp.UserControl = True

but this will not open a file just opens excel.

 

[pedlar]

Try adding the following line to your code where fname is the name and path of the file you wish to open.

oApp.Workbooks.Open fname

 

[St0rm]

That worked thanks.