ASP has no interface to access Application data from other environment than VBS/JS in context of ASP page in the same application. But we can create a simple http interface and use the Application object from any other environment - wsh, VBA (Word, Excel), etc. The basic idea is to make simple ASP page, which will provide a text/http interface to ASP intrinsic objects (specially Application object). We can read/write variables in application dictionary using this ASP script. And we can specify name and value of application variable by a query string to read and write specified variable.
|