Answer the question
In order to leave comments, you need to log in
Is there a way to pass to a google sheets document the path to a shortcut on the computer that opens google sheets?
Hello!
I have a shortcut on my desktop that opens a specific google sheets.
Is there a way to pass the location of this label to the google sheets document? It is necessary that the path to the shortcut on my computer be registered as a value in the cell "A1" of Sheet1 opened by the google sheets shortcut.
Answer the question
In order to leave comments, you need to log in
It will not work to register a value, but it is easy to select a specific cell. Right-click on any cell - "Get a link to this cell".
Or make a script, expand it, pass the name of the shortcut as a parameter, and the script will already write it.
Inside the script, use goGet ()
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question