MrDB4Excel
Active Member
- Joined
- Jan 29, 2004
- Messages
- 334
- Office Version
- 2013
- Platform
- 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
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.
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
I highly suspect this is not possible, but sure would be nice if it could.
Many thanks for any help.