Browser URI to open Excel at a specific Cell

[CMIIandExcel]

Hi all

Is it possible to create a browser URI to open a excel workbook at a specific cell?

Thanks in advance

Michael

 

[Andrew Poulsom]

Example:

=HYPERLINK("[C:\Users\Andrew\Desktop\Book1.xls]Sheet2!D10","Book1")

 

[CMIIandExcel]

Andrew

Thanks for the quick response: That link will work if linking from an excel book. My question was relating to working from a web browser.
To use your example, If i entered C:\Users\Andrew\Desktop\Book1.xls in the browser address I would be prompted to open the excel book. Can you pass the range address through to open the book at the given cell, in this case Sheet2!D10.

Hope that makes sense

Thanks in advance

Michael

 

[Andrew Poulsom]

It works for me in IE9 if I name the target cell, eg MyName:

C:\Users\Andrew\Desktop\Book1.xls#MyName

 

[CMIIandExcel]

Andrew

Thanks for getting back, It doesnt work for me but I am in IE7 (dont ask :/), I will try and jump on somones machine who has IE9 and test there.

regards

Michael