Linking to a specific cell and/or sheet in an Excel file

J

janabanana

I have Access 2000. I have created a column for my hyperlinks in my database.
I have even created the link. However, it will not let me narrow down the
destination/address to a specific sheet in my Excel file.

When I try to tweak the address when editing the hyperlink, it doesn't seem
to work. In the address, after the .xls, I have added #'name of sheet'
(pound sign and then the name of the sheet), and I have also tried -'name of
sheet' (dash sign and then the name of the sheet) what am I doing wrong?
 

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

Top