How can I run VBA code as RunMacro?

I

itmgr

Joined
Jun 21, 2007
Messages
1
Reaction score
0
in Access 2003, i wrote a function module that starts Excel (hidden) and runs a VBA where i have Excel convert an XLS to the newest version of Excel. from Access i can "manually" run this function successfully.

what i can NOT get to work is running this function from Access as a RunMacro. i want it to run in sequence with other queries and RunMacro's i have.

what am i doing wrong?

i simply want it to run with my other things.

is it possible to code the Excel VBA directly in Access?
(i tried but couldn't get that to work either)
 

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

Pause Macro 1
RunMacro action was canceled error 0
[Access/VBA] How to convert a RunMacro with a "repeat expression" in a simple function call ? (no mo 3
OnAction - Adding a command bar 4
Override Access's Current Internal Choices 4
Run Macro Problems 3
Excel VBA - counting cells by colors and names to it in two different rows. 0
Excel Transfer of customized excel tabs with UI Editor but VBA code not working 0

Back
Top