Creating and running macros for excel in access

M

marleyuk

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.
 

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

Creating and running macros for excel in access As on click event. 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Open an excel spreadsheet and run a macro from Access VB 2
Running excel macro from an Access Macro 3
Relpicating an Excel Macro in Access 4
Automating Excel report Using Data from MS Access 3
Excel Macro for deleting Rows containing dates greater than "today" 0
Excel Run macro upon cell edit 0

Back
Top