VBA script error 1004

[leonardtan]

Hi,

Im new to vba. trying to automate my reports. The vb was working well but I received an error could you assist

 

[Hui]

Which line in which file causes the error?
Can you post the Excel file ?

 

[leonardtan]

Would like to but the data files is a bit on the sensitive side.

I tried a while ago it works only if I paste code in the VBA in the data file.
The code could not run if I save the code on another xlsm template.

 

[Hui]

Which line in which file causes the error?

 

[leonardtan]

Thanks i managed to solve the error.
i paste it in module 1 and module 2 to activate the macro