Bypass "File has Macros" warning when opening a series of excel files to extract data?

I have a working Excel macro that combines data from several other files that all have the same layout. My annoyance is that it prompts me for each file being opened saying that it contains macros, etc and do I want to continue.

Is there a way to bypass this so the entire process is more streamlined?

Additional info: The OPEN file statements are shown below in bold. Is there an option to ignore the 'File Contains Macros' message?

Here is the macro code to open the files….

Please Login or Register  to view this content.

Try putting

Please Login or Register  to view this content.

before opening the file.

Don't forget to switch it back to True after processing the file.

Thanks bakerman2 for the tip. I had forgotten about that.

Unfortunately, it did not do the trick when I grid it. :-(

I had my doubts it would work since this is a Security feature against malicious software.

One other option is to add the location of the files to the Trusted Locations in Excel Options.

as bakerman pointed out
its a security feature which you need to bypass

some step by step
http://blog.contextures.com/archives...urity-warning/

comments at end gives other suggests other things you may want to try

Hi

I suggest

Please Login or Register  to view this content.