opening an excel file from a form

A

Alylia

Hello,

i want to open a specific excel file from a form that is part of a database
that i have designed.

Sggestions as to how this can be acheived will be greatly appreciated.

Regards.
 
S

SusanV

How to determine where the file lives is impossible to say without more
info, but if you already have that in the database, then:
Application.FollowHyperlink "full path to file"
ie,
Application.FollowHyperlink "\\Server\share\file.xls"
Application.FollowHyperlink "C:\Excelfiles\file.xls"
 
A

Alylia

Thanks for your kind response.

I have tried it out and the excel programme opens quite alright but the
content of the workbook does not show.

Please guide as to what next can be done.

Regards
 
Top