Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
I Need VBA Assistance regarding passing a variable from Access
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" wrote in 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 do I do and what syntax do I use, also where must I put the variable in my Access module and Excel macros? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import into Access from Excel, passing a variable for the field... | Excel Worksheet Functions | |||
Passing variable to VarType of other Variable | Excel Programming | |||
Passing a variable between workbooks | Excel Programming | |||
Passing variable from one sub to another | Excel Programming | |||
Passing a value to a variable from Userform | Excel Programming |