I Need VBA Assistance regarding passing a variable from Access

G

Guest

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.
 
B

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I Need VBA Assistance for global variable question 1
I need to VBA Assistance to pass an Access variable as a parameter 7
Passing variable to Access 4
I need VBA Assistance for evaluating words in a filename 1
Passing variable values from userforms 1
Declaring Variables 3
Variables- Multiple forms 3
Passing Variable HELP HELP HELP 6

Top