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.

[June7]

Maybe Allen Browne can help http://allenbrowne.com/func-GoHyperlink.html

[perikillo]

I don't know how to apply this to my problem...

[June7]

You are trying to 'make hyperlinks' - what does this mean - you want to save a hyperlink string to a hyperlink field (which is a special kind of text field)?
What does 'does not work' mean - error message, wrong results, nothing?
Are you trying to use FollowHyperlink to open the Excel file?

With Allen's code the string can be saved into a regular text field and still open the file. Whether or not it will open to specific sheet I can't say, never tried.