I Need VBA Assistance regarding passing a variable from Access

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 do I
do and what syntax
do I use, also where must I put the variable in my Access module and Excel
macros? Thanks.

You need to either run the code in Access and use automation to link to
Excel and run that macro, or vice versa.

If you want to go down this route, more detail, including the Access
variable and a bit of that code.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Brent E" <[email protected]> wrote in message
news:[email protected]...
> 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 do I
> do and what syntax
> do I use, also where must I put the variable in my Access module and Excel
> macros? Thanks.
>