VBA Workbooks.Open - Suppress File Currupt Message

M

macmeldrum

Hi,

Application.displauAlerts = false
and
On error resume next

These don't stop a vba procedure that it's opening a workbook that is
corrupted.

Is there any way to suppress (or detect) all dialogs, alerts etc
whilst a procedure is running?

Thanks

Mac
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Workbooks.Open always have 1
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Suppress "Opening File" Alert 0
VBA--Suppress error message,corrupt file or unrecognizable format 6
Opening workbook - get error message : unreadable content, lostvbproject 4
VBA for Dependents shortcut menu 0
VBA Export to PDF 0
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3

Top