Compile error on workbooks statement

[vasek1192]

Hi, I am having trouble reffering to any workbook using workbooks statement. Every time I try using the workbooks statement I get compile error despite copying the code from tutorial. Example in the image. Any suggestions? Thanks

 

[RoryA]

Have you named something (eg a module) Workbooks by any chance?

 

[vasek1192]

Have you named something (eg a module) Workbooks by any chance?

Yes I did. I changed the name of the module and it works fine now. Thanks a lot