Disabling Splashscreens and macros from external aps

[Guest]

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?
(e-mail address removed)

 

[James Butler]

I had exactly the same problem where message boxs were in the open
workbook event, however it is very easy to overcome just disable the
events. The code is:

Application.EnableEvents = False

Just remember to switch them back on at the end of your code!

I hope that helps.

James

 

[Guest]

Thanks. I'll give that a try.


(e-mail address removed)

 

[Guest]

Is there code to stop calculation from happening with formulas?


(e-mail address removed)

 

[James Butler]

Yeah you just need to switch the automatic calculation off, you can do
this with the following:

Application.Calculation = xlManual

The other option you have is whether to calculate the spreadsheet
before saving it which is:

Application.CalculateBeforeSave = False

But that all depends on what you are trying to do.

Again I think you may need to switch these both back on when your
finished so you can you use:

Application.Calculation = xlAutomatic

Any Problems then give me a shout.

James