Creating and running macros for excel in access As on click event.

Joined
Feb 16, 2006
Messages
88
Reaction score
0
Creating and running macros for excel in access As on click event.

I have a long process of changing some data through excel and command prompt. I wanna make it all part of an onclick event. So far the user clicks the command button, the command prompt event begins, it creates folders and changes name values. Now i want to export data into excel, change data in excel by running a macro on it. The macro has been created, and i have made a spreadsheet template, so what i want to do is after the data has been added to the template, run the macro which adds columns and stuff. Can someone give me some tips and where i should be looking and if im going the correct way about it.

Thanks,
Marley.
 
Back
Top