open a specific excel file from access form

P

Phil

Dear helper,

I would like to open a specific excel file and get focus
via visual basic. I am very appreciated if anyone can
help. My file location is “I:\Home Interiors\HI mailing
database\NewDataStandardFile.xls”

Thank you.
 
S

Steve

Dim XL as object
Set XL = CreateObject("Excel.Application")
XL.Visible = true
XL.WorkBooks.Open ("FullPathToFile")
 
Top