I Need VBA Assistance for global variable question
 

Good morning,

I am curious if Excel macros stored in personal.xls can use a variable
entered in a Microsoft Access form or module, can this variable be passed
into an Excel Maco as a parameter or as a global variable? If so what syntax
do I use, and where must I put the variable in my Access module and Excel
macros? Thanks.

hi,
see your post in access programming.

-----Original Message-----
Good morning,

I am curious if Excel macros stored in personal.xls can
use a variable
entered in a Microsoft Access form or module, can this
variable be passed
into an Excel Maco as a parameter or as a global
variable? If so what syntax
do I use, and where must I put the variable in my Access
module and Excel
macros? Thanks.
.