Running MS Excel in background OR minimized.

Is there a way to run macros in the background? I currently have several hundred VBA macros (Only coding language available to our company) integrated into a private application used for program delivery. Every time a macro is run, excel has to open up.

I know VBA uses the application, so it has to open - but is there a way to keep excel in the background or keep it minimized so users can't see it?


Also many of the macros use user forms. Will this impact excels visibility if the above is possible?


Thanks for everyone's help.

- Shane

You can set the application's visible property:

Please Login or Register  to view this content.

Dom

Got any jobs going? Always fancied Canada

You can have a hidden instance of Excel that runs macros to its heart's content.

In a code module in some workbook:

Please Login or Register  to view this content.

In myMacroController.xls ThisWorkbook:

Please Login or Register  to view this content.

In a myMacroController.xls code module:

Please Login or Register  to view this content.

Sign the project in myMacroController so that the code runs without prompting.