Macro copy range from xlsm file to open csv file

[Hudco]

I have created the following macro however it stops at "Range(B2:AI3").Select (line 5):

ChDir "C:\Wages"
Workbooks.Open Filename:="C:\FE Template.csv"
Windows("Wage Record.xlsm").Activate
Sheets("CSVUpload").Select
Range("B2:AI3").Select
Selection.Copy
Windows("FE Template.csv").Activate
Range("A2").Select
Selection.PasteSpecial Paste:=xlPasteAllUsingSourceTheme, Operation:=xlNone , SkipBlanks:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Windows("Wage Record.xlsm").Activate

Can someone please advise why it wants this line debugged?
Thank you

 

[Joe4]

What is the exact error message it gives?
Are any cells in that range protected that they cannot be selected?

 

[Hudco]

What is the exact error message it gives?
Are any cells in that range protected that they cannot be selected?

Thanks for response Joe,
There are no protected cells.
The message is the standard debug - Run-time error '1004': select method of range class failed.

 

[Joe4]

What is the name of the module where you have placed this code?
Have you placed it in a Sheet module, or a General/Standard module?

 

[Hudco]

Thanks for response Joe,
There are no protected cells.
The message is the standard debug - Run-time error '1004': select method of range class failed.

Hi Joe,
I have 10 sheets in the workbook and the macro is in sheet1 under Microsoft Excel Objects. I have created an active X control button on sheet1

 

[Joe4]

Try moving it to a Standard/General module.
When trying to work across multiple sheets and files, it is best not to have the code in a Sheet module.

 

[Hudco]

Hmmm... That's not an area I have used before. I will need to do some research & training.

Thanks Joe

 

[Joe4]

See here: