Link to home
Start Free TrialLog in
Avatar of Borgs8472
Borgs8472

asked on

Opening an excel document with initialation parameters

Our server configurations live in version controlled excel spreadsheets.

From our wiki, I would like to be able to deep link into these spreadsheets so that information can be quickly accessed.

Is there a way of opening a spreadsheet and passing additional parameters to excel, e.g. so a specified row will be initially highlighted, or the page will scroll to the requested point - so that I can deep link from my wiki?
Avatar of Steven Harris
Steven Harris
Flag of United States of America image

How do you want to pass those 'parameters' to excel?  If it is something that will very rarely change, you can add VBA code that will perform a certain action upon the excel file opening.  This will also require that the file format be changed (in Office 2007 or higher).
Avatar of Borgs8472
Borgs8472

ASKER

I would like to pass the parameters over via a specially crafted link from my wiki, so something triggered from a web browser.

I'd want to do stuff like:

"Networkmaster.xlsx+servername arg" type syntax
ASKER CERTIFIED SOLUTION
Avatar of Borgs8472
Borgs8472

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
This is what I did