Discussion Article

[ Home | Contents | Search | Reply | Previous | Next ]

Subject:
RE: Passing Variables Between Applications in VBA
Name:
Jim Moran
Email (spam proof):
Email the originator of this post
Date:
Saturday, March 13, 2004
Hits:
62
Discussion (Terms and Conditions):
I can offer you a very �clunky� way to do this. It works fine for me for a similar purpose. You can have Application #1 leave a simple output file in some common folder (Just a basic �Open filename for Output as #1�). I established a folder in c:\Program Files on all of my groups PCs that we use for this purpose. You can do that automatically with a small VBA macro launched as an E-mail attachment. The file has some fixed name, say �LaunchTransferInfo.txt�. Have Application #1 create the transfer file, then open Application #2. Excel has a Workbook_Open event trap (I assume Access has a similar event trap, although I am strictly an Excel hacker). Put some code in that event trap to look for the existence of the transfer file. If it exists, then load in the desired info and move on accordingly. Remember to Kill$ the transfer file. (note this little transfer file will only exist for about a second!). Like I said, it�s clunky, but it works for this amateur programmer! Subject: Passing Variables Between Applications in VBA Name: Rich G Email: canislupus@ntlworld.com Date: Wednesday, March 10, 2004 Discussion: We have a suite of various Access and Excel applications for use with a specific set of databases. What we wish to do is create a control application using either Access or Excel which will have some VBA controling which database the user wishes to apply the tools to. What we are having trouble doing is passing information between the applications when they are launched, e.g. the database name, user name and password. Can anyone advise how we could do this?

Sponsored by the best FTP application on the internet: