open excel file through access

[Guest]

i have a form in microsoft access with buttons used to open tables and run
simple queries. I would like to add buttons that would open specific word
and excel files.

excel and word are located on a local hard drive, while the files i would
like to open are on a network drive.

what do i have to do so that all you have to do is click a button in an
access form to have a word or excel file open

 

[Guest]

It depends on what you want to do once you open the files. If you just want
to launch the app from Access, then see the Shell statement in Access Help.
If you want to manipulate them from within Access, here is a sample of
opening an Excel file:

Set xlApp = New Excel.Application
Set xlBook = xlApp.Workbooks.Open _
("C:\Documents and Settings\hargida\My Documents\SELRec_ITM-PM YTD
ApriL2005.xls")
Set xlSheet = xlBook.Worksheets(1)
xlSheet.Activate

 

[Van T. Dinh]

You can simply use the FollowHyperlink Mehod in the CommandButton_Click
Event.

Check Access VB Help on FollowHyperlink.

 

[Guest]

That is fine if you have a Hyperlink defined for the file. I did not see in
the original post that there is one.

 

[Van T. Dinh]

All you have to do is to stick "file:" in front of the full-path and you get
the required hyperlink.