opening an excel file from a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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"
 
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
 
Back
Top