Running Excel Macro from Access

[Yugo]

Hello,

a similar problem to one already solved just below... In my procedure in Access I can open my excel document no problems but what I would like to do run a macro from that spreadsheet. How do I do that?

Also is it possible to import a module into an Excel workbook from a procedure in Access?

Cheers

Yugo

 

[Yugo]

Forgot to say we still use v97 at work...

 

[Cbrine]

This code will allow you to open and control Excel from Access. Once you open the application and Workbook, you should be able to call your macro directly from the Access VBA Code.

HTH
Cal

Dim XL As Object
Dim Excel As Object
Dim FullPath as String

FullPath = 'Your Path & FileName
Set XL = CreateObject("Excel.Application")
XL.Workbooks.Open (FullPath)
XL.Visible = False

Add you macro call here

WB.Close
XL.Quit

 

[Yugo]

hmmm as easy as just calling the procedure as normal... cool.

i read Chip Pearson's guide to working with code within code... so both questions are sorted

Thanks

 

[Cbrine]

Quick Note. I ran some tests(Since I've never actually ran a Excel Macro from Access). You need to call the macro using the xl.run and then the macro name in qoutes. Otherwise Access chokes on it as a undefined function.

XL.Run "message"

 

[Yugo]

I see. I did think I would need something to tell Access to look for the macro in excel....

Thanks again...