Copy specific data from Workbook A to Workbook B by a button

[Pcwork2006]

I have set a button to run Marco for the subject action . However, the file name of Workbook A will change every day. I need to correct the file name of Workbook A in Marco before click button. I want to skip the correction step. Please help.
Thank you.

 

[footoo]

In the code use ActiveWorkbook instead of the workbook name.
Make sure the correct workbook is activated before running the macro.

 

[Pcwork2006]

In the code use ActiveWorkbook instead of the workbook name.
Make sure the correct workbook is activated before running the macro.

Thank your your reply !
But I dont know how to use ActiveWorkbook code..

Today , my code is:

Windows(“A.xlsx”).Activate
Range(“A3:Q18).Select
Selection.Copy
Windows(“B.xlsm”).Active
Rang(“A4”).Select
ActiveSheet.Paste

 

[footoo]

Manually activate workbook A then run this :

Range("A3:Q18").Select
Selection.Copy
Workbooks("B.xlsm").Activate
Range("A4").Select
ActiveSheet.Paste

Which can be reduced to :

Range("A3:Q18").Copy Workbooks("B.xlsm").Range("A4")

 

[Pcwork2006]

Manually activate workbook A then run this :

Range("A3:Q18").Select
Selection.Copy
Workbooks("B.xlsm").Activate
Range("A4").Select
ActiveSheet.Paste

Which can be reduced to :

Range("A3:Q18").Copy Workbooks("B.xlsm").Range("A4")

Ok, I will try this later.
If the button is assigned in workbook B.xslm. This is work or not?

 

[footoo]

Ok, I will try this later.
If the button is assigned in workbook B.xslm. This is work or not?

No, Because that would mean that Workbook B would be the active workbook when the macro starts.

 

[Pcwork2006]

No, Because that would mean that Workbook B would be the active workbook when the macro starts.

Oh. Then,have you any suggestion on it? Sinece Workbook book is the master data file for consolidate the data from Workbook A (its filename will change,i.e A_201907.xlxs and A_201908.xlxs etc.)

 

[footoo]

Put a button on each of the workbooks that need to be active before the macro is run (you can still store the macro in Workbook B).

 

[Pcwork2006]

I am not able to add the button in the Workbook A because workbook A is provided by clients every day. Therefore, the file name may has some change ( Workbook A )..

 

[footoo]

Maybe add a button to the QAT.