Opening and closing workbooks

[b-radexcel]

hi all-

I have a small vba app where I open existing workbooks and copy certain ranges onto a new workbook - basically compiling data.

I am using Workbooks.Open Filename:=file_Name, UpdateLinks:=0, ReadOnly:=True to open files. the problem is, when i close workbook.close excel keeps prompting me if I want to save changes. Excel also asks if I want to update links when I open these files. Is there a way to activate these workbooks without getting prompts?

 

[Smitty]

You can use Application.DisplayAlerts = False to suppress messages, just set it to True at the end as the VBE won't reset it.

As for the Links prompt you can goto Tools-->Options-->Edit -->Uncheck "Ask to Update Automatic Links".

Smitty

 

[Joe4]

There are a few ways. One is to use this line before that step:

Application.DisplayAlerts = False

Then you can turn it backon afterwards with:

Application.DisplayAlerts = True