Hi All,
Im trying to write a small proceure from access to call excel and construct a small macro. My question is how do I write a macro to make a macro? For example in my Access applicaiton the user would click an export to excel button. THis button would launch excel and populate it with data. I then want to have a small button that would do some basic sorting. But i havnet been able to figure out how to 1) write code to create the macro 2) assign the macro to the button. I want to do this without creating an excel addin.
Regards,
Scott
