how do I call an Excel sub routine from Access?

J

June Macleod

I have used getobject to open an excel workbook (Test1.xls) and would like
to run a sub-routine (SetUpResults) that already exists in the workbook.
Can someone tell me the syntax I should use?

Thanks

June
 

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

Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Need Help with Macro Security 1
Adding custom menus to existing excel application 0
VBA to do a mailmerge from a Specific Excel worksheet 0
non basic code in call stack 3
How do I set focus (and select text) on a text box on a modeless userform? 0
Calling Subroutines from sub-routine 4
VBA Coding Help for Beginner 0

Top