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