Hyperlink to a specific page in Excel

  • Thread starter Thread starter forest8
  • Start date Start date
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.
 
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...
 
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
(e-mail address removed)
 
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...
 
Back
Top