logicalman
Programmer
Greetings,
We have an ASP from which the user selects a record. This writes a record of the requested ID and the User Id to a table, and then opens an Excel file which runs a macro that looks for the current user's ID logged onto the machine and checks the table for which record ID was requested.
This works well, when the user logging onto the web page is the same as the user currently logged onto the machine.
Unfortunately, we have now been asked for the scenario whereby the web user logon is different from that logged onto the machine.
We therefore need to pass the web User ID (string) to the excel file when it opens, but can find no code to do this.
Anyone have any ideas?
We are competent in both ASP (javascript/vb script) and VBA coding.
Thanks,
Logicalman
We have an ASP from which the user selects a record. This writes a record of the requested ID and the User Id to a table, and then opens an Excel file which runs a macro that looks for the current user's ID logged onto the machine and checks the table for which record ID was requested.
This works well, when the user logging onto the web page is the same as the user currently logged onto the machine.
Unfortunately, we have now been asked for the scenario whereby the web user logon is different from that logged onto the machine.
We therefore need to pass the web User ID (string) to the excel file when it opens, but can find no code to do this.
Anyone have any ideas?
We are competent in both ASP (javascript/vb script) and VBA coding.
Thanks,
Logicalman
