why?

"Markus Scheible" wrote:

> 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??
> >.
> >
>