Automate Macros in ACCESS 2003

[VBmatta via AccessMonster.com]

Hi

I have completed an application in ACCESS 2003 ,the input data is inform of
an excel spreadsheet.I had gotten my desired output.However i have to do the
same procedure on 12 more spreadsheets.Each spreadsheet is unique and the
results are unique.

How can i automate the process? , ACCESS VBA Macros ? .. Which codes do i
have to copy and paste, How can i create a robust automation of the macros
Replies to all these would be very helpful

Thank you

Matta

 

[Steve Schapel]

Matta,

First point... In Access, there is no such thing as VBA Macros. You
could possibly use a VBA procedure. You could possibly use a macro.
They're two different things.

Apart from that, I don't think I could advise more specifically at this
point. You did not mention what you are doing with the data, and what
is the meaning of "input" and "output" in your context.