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.
 
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.

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
(e-mail address removed)
 
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.
 

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