bs0d
Well-known Member
- Joined
- Dec 29, 2006
- Messages
- 622
I'm curious if it would be possible to send a query string to an Excel file, similar in the way you would to a server-side webpage in the URL?
For example, a link in a Word document:
Click (or CTRL+CLICK) opens file in Excel, Workbook_Open() is called where VBA code exists to see the value '123' of ID passed along in the file name, and handles that data appropriately to display results in the workbook.
For example, a link in a Word document:
Code:
\\path\to\file\my_workbook.xlsm?id=123
Click (or CTRL+CLICK) opens file in Excel, Workbook_Open() is called where VBA code exists to see the value '123' of ID passed along in the file name, and handles that data appropriately to display results in the workbook.