Hi unknown,

please post your real name...


>-----Original Message-----
>In my current code I've set both the above attributes to
false, but when I
>try to open a workbook someone else is in using the code
I still get the
>dialog box asking if I want to open it Read Only, Notify
when it's read-write
>or Cancel.

The thing is that you have to give something back to that
window - otherwise the workbook wouldnt open - so excel
asks you even if you turned the window.updating to false...

but with the open dialog you can also give the command to
open it read-only by:

Workbooks.Open FileName:="abcd.xls", ReadOnly:=True

for Read-Only:

Optional Variant. True to open the workbook in read-only
mode.


This is from the Excel help in Windows...

Best Markus



>
>I want to try and automate this as much as possible
because I need to open
>10 spreadsheet and take one tab from each into a master
sheet and I don't
>want to sit there clicking Read Only each time.
>
>Any ideas??
>.
>