VBA for Excel

[SuitsyExcel]

I am using excel to record some data for my plant. As part of a daily entry
process, my user enters data, and my program uses that data to pluck more
information from other excel workbooks stored on the network. while the data
is extracted, I get this message:

"Links to 'file.xls' were not updated because 'file.xls' was not
recalculated before it was last saved.
To update links with current values in 'file.xls' , click OK
To cancel updating links in 'file.xls', click cancel"

And then you can reply OK or cancel.

My question is can I automate this response so my user doesn't have to hit
ok everytime this comes up? I get about 20 different number per day, and so
my user has to hit the enter key 20 times when running this program.

 

[SuitsyExcel]

I am using excel to record some data for my plant. As part of a daily entry
process, my user enters data, and my program uses that data to pluck more
information from other excel workbooks stored on the network. while the data
is extracted, I get this message:

"Links to 'file.xls' were not updated because 'file.xls' was not
recalculated before it was last saved.
To update links with current values in 'file.xls' , click OK
To cancel updating links in 'file.xls', click cancel"

And then you can reply OK or cancel.

My question is can I automate this response so my user doesn't have to hit
ok everytime this comes up? I get about 20 different number per day, and so
my user has to hit the enter key 20 times when running this program.

 

[ryguy7272]

Application.DisplayAlerts = False
'What you want to do goes in here...
Application.DisplayAlerts = True

A word of caution: set to true when done, so you will be alerted to other
messages that you do not intend to suppress elsewhere.

Regards,
Ryan--