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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update several ppt documents from a single excel file 0
Default local file location - folder redirection slowness 0
Creating a Chart on form from selected data in query. 0
You'll need a new app to open this about link 1
Integrating information from Word to Excel (not mail merge) 1
Access Lock File .LACCDB / Now shows as a notepad file 0
Merging from an Excel file with graphics 1
Autonumber field in Excel that behaves the same as Access 0

Top