Hyperlinks from Access to Excel worksheets

Kai90

Board Regular
Joined
Jul 15, 2005
Messages
85
Hello,

I am using Access'97 and Excel'97.
I am trying to create several buttons on a form that link to an Excel sheet on the Network. The link to the sheet itself works fine.
The problem is: I can't link to the other worksheets within that Excel file. No matter what I put in the 'SubAddress' field, it always just jumps to the first worksheet.
e.g. the 2nd worksheet is called Red Parts, so I enter the following in the SubAddress field: #Red Parts!A1
It is supposed to jump/open to that worksheet with the highlight on cell A1. Instead, I jumps to the first worksheet.
I tried all kinds of OTHER possible combinations, only to get 'Invalid reference' errors.

Any ideas? I know it might be more of an Access problem.
Thanks a lot

Kai
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Tried that too

I did that,too.
The path was \\xyz\sheet.xls#Red Parts!A1

When I do that I get an invalid reference error.
 
Upvote 0

Forum statistics

Threads
1,213,552
Messages
6,114,278
Members
448,559
Latest member
MrPJ_Harper

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top