Opening a specific Excel spreadsheet from Access

[Hilo]

How do I open a specifice Excel spreadsheet from Access
via code behind forms (click a button)? Any help would be
appreciated.

Hilo

 

[nath]

-----Original Message-----
How do I open a specifice Excel spreadsheet from Access
via code behind forms (click a button)? Any help would be
appreciated.

Hilo
.
Dim xl as object

set xl = createobject("excel.application")
xl.visible = true
xl.workbooks.open (filename)

 

[Hilo]

It works! Thanks Nath!

-----Original Message-----


set xl = createobject("excel.application")
xl.visible = true
xl.workbooks.open (filename)


.