Using variables outside of Access

[timotai]

Hi all

I have created a vb script that starts a program called PCOMM and runs a macro in that program which is written in VBscript to process certain actions. It then closes down and the Access database detects when it closes and then processes other actions.

There are currently 2 occasions that a user has to type in a username and password, I want to reduce it to 1.

The 2 are:

In Pcomm to logon, I have vb inputboxes appear which request this info and then automatically put it in.

In Access to create a text file that if run in dos to connect via ftp to download a file from an AS400.

I want to just type the username and password into access, make variables with the values of the username and password and use them in the vb script in PCOMM.

The question is how. I have been trying but cannot use the variable externally.

I know that I have described this very badly so if you have any qustions please ask.

All help and advise if greatly appreciated.

Many Thanks

Tim

 

[Craig0201]

To the best of my knowledge, you can't. Windows will isolate each process and only those variables related to that process are visible.

There may be a way of passing them into the PCOMM process on starting it but these variables are not shared.

Craig

 

[PHV]

Have you tried to play with the WshShell.Environment object ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244