How do i create an external link that automatically opens specified cell/range in workbook?

[chrisignm]

Hey,

I want to send a link to an Excel workbook over HTML email.

A link only to the workbook itself works fine, but when it comes to specifying a cell/range it won't find the file anymore. To make this work, I would need to know: how can I actually open the workbook and redirect it immediately to the cell?

Let's say my file is in C:\testfolder\testfile.xlsm

I can just put this path into the windows search and it will open.
If i want to go straight to the sheet "Internal" and Cell A3, it won't work anymore.

I've tried the following versions:
'C:\testfolder\[testfile.xlsm]Internal'!$A$3
C:\testfolder\testfile.xlsm'Internal'!$A$3
C:\testfolder\testfile.xlsm#'Internal'!$A$3
C:\testfolder\testfile.xlsm-'Internal'!$A$3

and some other combinations...

it seems that the Excel-style referencing does not work outside.
How can i achieve it?

Thank you!

 

[chrisignm]

Do I need to clarify it somehow?

Any advice appreciated!

 

[chrisignm]

Specifying my question, I did further research:

https://support.microsoft.com/en-us/kb/197922

It seems that it works, when the file is on a webpage, but not if it is on the local computer. (calling it with file://)

Any way, to achieve the same with file:// ?

Thanks

 

[chrisignm]

up