Hyperlink - Excel spreadsheet

[Tracyice]

In my database, I have a field which stores a hyperlink. Is there a way, using VBA, that you can specify a specific worksheet in an excel workbook? Or is only possible to create the link to the entire workbook?

 

[PHV]

Take a look at the SubAddress property of the Hyperlink

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[subri1]

I have a DB Field that has a hyperlink - this hyperlink is actually a path to an EXCEL file. I have the hyperlink inserted on a form, but when I click on it, it doesn't do anything. Any ideas?

Thanks!

 

[PHV]

inserted on a form
As hyperlink ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244