On Sep 16, 11:15*am, Matthew Dyer wrote:
I have a question regarding the available scope of variables. I
understand that you can make variables function/routine specific,
module specific, project specific, etc. But here's my issue,

Currenly I am using a shell function to call a batch file which points
to an avaya cms script (coded in vb script, not sure if relevant or
not.

How would I go about setting a variable at the beginning of my VBA
module which can be utilized in the CMS Script? Are there additional
details you guys would need to help?

If your script can get to a cell's contents, have the VBA Dim the
variable to the proper level of scope, then have the VBA initialize
the variable, then have the VBA coding place the value in some cell's
contents for the script to retrieve.