MACRO HELP
 

Morning, i have an excel workbook to automatically open at a specified time,
i have code to run a macro to and close the excel sheet after a certain time.

The trouble i'm having is when the excel opens its asking to update links
YES or no, is they anyway i can automatically update the links instead of
having to press yes?

Thanks,

MACRO HELP
 

Hi,

Tools|Options|Edit

Un-check 'Ask to update links'

Mike

"Neil Holden" wrote:

Morning, i have an excel workbook to automatically open at a specified time,
i have code to run a macro to and close the excel sheet after a certain time.

The trouble i'm having is when the excel opens its asking to update links
YES or no, is they anyway i can automatically update the links instead of
having to press yes?

Thanks,

MACRO HELP
 

Or for 2007

Office button|Excel options - Advanced and scroll down and un-check

Mike

"Neil Holden" wrote:

Morning, i have an excel workbook to automatically open at a specified time,
i have code to run a macro to and close the excel sheet after a certain time.

The trouble i'm having is when the excel opens its asking to update links
YES or no, is they anyway i can automatically update the links instead of
having to press yes?

Thanks,