File block settings in the trust center

Hello,

The code below was placed in module1 in book2. What it does it copied the data from book1 A1:A10.

I received an error "you are attempting to open file type(Web Pages and excell 2003 XML Spreadsheet) that has been Block by your file block Settings in the Trust Center."

So I went to File/Option/Trust Center/File Block Settings and I removed the check from Web Pages and Excel 2003 XML Spreadsheets and even I checked it or uncheck the code still not working.

When I clicked the macro button, it does something but it's not copying the data from Book1.
I did input the Full Path File under the Book1.xlm.

Please help!
Thank you

Please Login or Register  to view this content.

Ok... I found where is the correct file path.
I still get an error when the macro buttong click.

The error say Error 438 "Object doesn't support this property or method".
It highlight this section "Wb1.Sheet1.Range("A1:A10").Copy".

Please Login or Register  to view this content.

My book1 where I want to copy is in Sheet1.


Thank you

Hello,

such a bad syntax ! Wb1.Sheets1 so just compare with your initial post code …