Even if someone uses the excel file, I still want to copy some rows and paste it into new

[Goodstart14]

Hi,
I want to copy some rows even if that excel using by some one.
I used below code;

Set wbSource = Workbooks.Open("C:\Documet\Share Document\MonthlyReport.xlsm", Password:="xxxx", ReadOnly:=True)

wbSource is workbook.

When someone is using, I want to open as 'ReadOnly', but I got an error "Runtime 9, script out of range".
When nobody is using, then this code works well.

What is wrong and how can I fix this problem?

Thanks

[nigelog]

Add this code into Workbook section

Please Login or Register  to view this content.

When file is already in use you will be alerted