View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brent E Brent E is offline
external usenet poster
 
Posts: 74
Default 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.