open a specific excel file from access form

  • Thread starter Thread starter Phil
  • Start date Start date
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.
 
Dim XL as object
Set XL = CreateObject("Excel.Application")
XL.Visible = true
XL.WorkBooks.Open ("FullPathToFile")
 
Back
Top