Macro Help

[mijofr]

How do I instruct a macro to open other spreadsheets in a "read only" format?

I have a macro in spreadsheet "A" that opens a variety of other spreadsheets, does calculations in those other spreadsheets, then summarizes the resultant data back in spreadsheet "A". The problem is that it is opening those other spreadsheets as read-write then overwriting the existing data when it closes them. I do not want this to happen and I can't always be sure that someone else won't be working in those other spreadsheets when I run my macro. I want my macro to open those other spreadsheets in "read only" mode, then close without saving changes.

How do I do that?

Thanks

 

[JamesW]

Hi there,

Try:

    Workbooks.Open Filename:="C:\myfile\Book1.xls", ReadOnly:=True
    Windows("Book1.xls").Close SaveChanges:=False