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)
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)