MSG Box Disable

[McArthurGDM]

Hi,



I have a loop in Access that will open Excel files and pull their data in a specified folder. A lot of these Excel files have message box warnings upon opening. The code stops to allow the user to click yes or no and you continue. There are a lot of files, so it is cumbersome to do this many times.

Is there a line of code to put in Access VBA that will allow me to disable MSG boxes as they pop up in Excel?

Thanks,

[June7]

Exactly what is the warning?

Post your code for analysis.

[McArthurGDM]

Sorry. That wasn't clear.

These particular Excel files have a On Workbook Open sub routine that displays a message telling the user that the Workbook is a macro-enabled workbook and to Enable and trust the source.

[June7]

Can users set Excel application to accept all macro enabled files? This is Trust Center settings in the Excel application.

Seems I saw this same topic in another recent thread, but was about Access macro warning.

I don't think code can accomplish this because then what use would the Trust Center be? Macros must be enabled to allow code to run therefore code cannot run that would enable macros. Catch-22.