Hello,

I have written a wicked VB program in Excel to consolidate information I am extracting from numerous separate Excel files that I need to open as read only, but don't want to sit there clicking OK for every file. Is there some VB code to automatically accept read-only?

Many thanks

Anders

Hi Anders,
Use ReadOnly parameter and you don´t have to hit Enter key

Workbooks.Open Filename:= "C:\Book1.xls", ReadOnly:=True

-vemaju