Macro to Press Button or Run VBA

[Johnny12]

I have a simple database that imports several excel files, churns them up and creates a new excel report. Currently you open the DB, the autoexec macro runs to do all the work, then a form opens with a button for you to press to run the report. I use VBA on the On Click event to export to Excel. There is no reason for the users to do anything else in this DB except run this report. Is there a way I can move the VBA to be run in the AutoExe macro or for the form to open and the button be pressed, then the DB close? Thanks!

[Gicu]

Just add an entry to your macro with RunCode(YourVBA_ExportFunction) as the action; note that you should have it as a VBA function not a sub.
Cheers,

[June7]

Can have function in general module called by the macro and that function executes button procedure. Button procedure cannot be Private.

Would be best to move the working code to a general module as a Function then it can be called by macro or button. But then I suppose the form is no longer needed.

What do you mean by "excel report" - just exports to a new Excel file?

[Johnny12]

Just add an entry to your macro with RunCode(YourVBA_ExportFunction) as the action; note that you should have it as a VBA function not a sub.
Cheers,

That worked perfectly, thank you!

[Gicu]