ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Passing data to excel on open (https://www.excelbanter.com/excel-programming/369209-passing-data-excel-open.html)

fred

Passing data to excel on open
 
If I have a shortcut that has has a workbook as a target then can I also
pass a number to the workbook from the shortcut by have a parameter after
the target file name?
for example: if I have in the target of a shortcut
C:\book1.xls "1234"
then is there anyway for me to retreive that number (1234) during the
workbook.open event.

Thanks for any help.
Fred



NickHK

Passing data to excel on open
 
Fred,
There's this:
http://j-walk.com/ss/excel/eee/eee002.txt

NickHK

"Fred" <leavemealone@home wrote in message
...
If I have a shortcut that has has a workbook as a target then can I also
pass a number to the workbook from the shortcut by have a parameter after
the target file name?
for example: if I have in the target of a shortcut
C:\book1.xls "1234"
then is there anyway for me to retreive that number (1234) during the
workbook.open event.

Thanks for any help.
Fred






All times are GMT +1. The time now is 10:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com