Hello,
How do I start a macro in an Excel file in Access 2000?

Dim appExcel as Excel.Application

appExcel.Run("Public Sub or Function name", Argument1, Argument2,
Argument_etc)

If it is a function and you want to return a value then

Variable = appExcel.Run(...

|-----Original Message-----
|From: Steven Van Aken [mailto:svanaken@m...]
|Sent: Monday, April 22, 2002 9:33 AM
|To: Access
|Subject: [access] Excel macro started in Access
|
|
|Hello,
|How do I start a macro in an Excel file in Access 2000?
|