Opening a specific Excel spreadsheet from Access

  • Thread starter Thread starter Hilo
  • Start date Start date
H

Hilo

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

Hilo
 
-----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
Click to expand...

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