Hi everyone,

Does anyone know how to create a macro in an Access 2000 file using C#. I need to create a report programatically. However, I think I am better off writing a macro that will create the report and let the user run it. However, I could not find a way where I could create a macro from outside Access. If anyone knows of a way or can point me to a resource, I would be really greateful.

Thanks,

Sincerely,

Pankaj

I very much doubt that you can do this. I know you can create a table within a Access db from C# but that is as far as you can go. I believe that creating reports/forms/macros is something that can only be done from within Access itself.

Why is it that you want to do it in C#? and why do you want it done outside of Access?

I am a loud man with a very large hat. This means I am in charge

I presume you would have to create a Comwrapper using tlbimp.exe and use the native Access methods. Do you mean an Access Macro that shows up in the Macros section or a block of VBA code?

--

Joe