Hyperlink to a specific Excel Worksheet

[perikillo]

hi,

I'm trying to make hyperlinks to specific pages of a workbook to excel. If I put the hyperlink of the form as follows then works properly:
C: \ Users \ Desktop \ test.xlsx # Sheet2!A1 -> leads me to Sheet2 document "test".

The big problem comes when the leaves have spaces in its name, that is, if the sheet is called Sheet 2:
C: \ Users \ Desktop \test.xlsx # Sheet 2!A1 -> does not work ...
C: \ Users \ Desktop \ test.xlsx # 'Sheet 2'!A1 -> does not work ....

The solution to rename the sheets is not possible ... anyone knows how to solve this problem?

Greetings.

 

[kevlray]

I thought it was the same as Access field names with spaces, surround the name with the square brackets.

 

[perikillo]

Do you mean like this?
C:\Users\Desktop\test.xlsx#[Hoja 2]!A1

 

[perikillo]

Well, it doesn't work. I suppose that there is any way to do this, but I don't know how to do it. Any suggestion?

 

[Mihail]

Try this:
Open the Sheet (in Excel)
Navigate to "Developer" menu.
Under "Controls" tab click properties. The "Properties" window should open.
In the "Properties" window, the very first row is "(Name)". As I write, with rounded brackets.
Try to use THIS name instead the sheet name that you see in Excel (or in Properties window few rows down).

 

[perikillo]

It doens't work, when I change the name of the workbook the name (without rounded brackets) in properties also changes..and I think that Access uses this..
Also, if I change the name of "(Name)" with rounded brackets, the program returns an error saying that "Sheet 1" is not an allowed name for an object.

I don't know what to do....but I think that it must be possible...

 

[kevlray]

I do not remember how I did it, but I know I have in the past. Not sure about the #. I am sure it is documented somewhere.

 

[kevlray]

Try this (worked for me on Excel 2007), C:\Users\Desktop\test.xlsx![Sheet 2]!A1