Hyperlink to a specific page in Excel

F

forest8

Hi there

Is it possible to set up a hyperlink to a specific page in Excel?

Currently, the hyperlink is to the first page of the Excel file but I want
it to link to the second page of the file.

Thank you in advance for your help.
 
G

Guest

forest8 said:
Hi there

Is it possible to set up a hyperlink to a specific page in Excel?

Currently, the hyperlink is to the first page of the Excel file but I want
it to link to the second page of the file.

Thank you in advance for your help.
Click to expand...
 
J

James A. Fortune

Hi there

Is it possible to set up a hyperlink to a specific page in Excel?

Currently, the hyperlink is to the first page of the Excel file but I want
it to link to the second page of the file.

Thank you in advance for your help.
Click to expand...

If you are creating the hyperlink in an Access Form, put something
like Sheet2!A1 in the Hyperlink Subaddress.

In a query, try something like:

SELECT * FROM [Excel 8.0;DATABASE=C:\MyExcel.xls;HDR=No;IMEX=1].
[Sheet2$];

or

SELECT * FROM [Excel 8.0;DATABASE=C:\MyExcel.xls;HDR=No;IMEX=1].['My
Sheet'$]

if the name of the sheet contains a space.

James A. Fortune
[email protected]
 
D

De Jager

forest8 said:
Hi there

Is it possible to set up a hyperlink to a specific page in Excel?

Currently, the hyperlink is to the first page of the Excel file but I want
it to link to the second page of the file.

Thank you in advance for your help.
Click to expand...
 
Top