View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Spammastergrand Spammastergrand is offline
external usenet poster
 
Posts: 23
Default Disabling Splashscreens and macros from external aps

I have a program that collects information on Access or Excel files from
Access. But when run it sometimes brings up splashscreens or something that
requires action, which I don;t want in a batch process.

Is there a way of supressing it? Application.displayalerts doesn't work.
Can you supress code being run in a workbook open event?

I'm using one workbook to open others. Can I open another in a way that
prevents that workbooks open event from running a splashscreen or other code?