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?
If this needs to be a macro, can someone give me something to cut and paste?
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?
If this needs to be a macro, can someone give me something to cut and paste?