Windows Desktop Shortcut

MrDB4Excel

Active Member
Joined
Jan 29, 2004
Messages
334
Office Version
  1. 2013
Platform
  1. Windows
How can I create a Windows Shortcut to a specific Excel file and specific sheet and specific cell that would auto-populate the data contained in that one cell?
I have searched and found nothing, but I also do not want to involve VBA.
It seems maybe it is possible to create this information in the shortcut properties.
Something as in the following but not to open the file, only to keep the shortcut auto-populated with the data in cell N2, which only always shows a number. In this case, today showing 23.7561000.
F:\Finances\CSOB\Cu
CurrencyConversionRatesWebQuery.jpg
rrencyConversionRatesWebQuery.xlsm#"Currency Rates"!N2
I highly suspect this is not possible, but sure would be nice if it could.
Many thanks for any help.
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
You could do this with (a shortcut to) a VBScript (.vbs) file. The VBScript would open the Excel workbook and write the N2 cell value and close the workbook. The current N2 cell value could be stored in the script itself (say in the first line as a comment) and the script could read/write its own .vbs file to update the stored N2 value.
 
Upvote 0
Just as easy to open the Excel file, but thanks anyway for your suggestion.
 
Upvote 0

Forum statistics

Threads
1,215,545
Messages
6,125,455
Members
449,228
Latest member
moaz_cma

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top