VBA macro work only when workbook is activated

[NileshAPatel]

Hi everyone

I had prepared one macro which is working fine one source file is activated but it doesn't work when destination file is active not source. (Both files are open)
Is there any way that when Master file is active and data get copied from CustomerOrderReport file and paste in master file.

This macro is running fine when I select CustomerOrderReport file as active and showing on screen
but didn't work when Master file is active and showing on screen

Sub test()
'Copy paste only values
Workbooks("CustomerOrderReport.xls").ActiveSheet.Range(Range("A3").End(xlToRight), Range("A3").End(xlDown)).Copy
Workbooks("Master").Worksheets("Today").Range("D1").PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False
End Sub



Thanks in advance

 

[Fluff]

How about

Sub test()
'Copy paste only values
With Workbooks("CustomerOrderReport.xls").ActiveSheet
   .Range(.Range("A3").End(xlToRight), .Range("A3").End(xlDown)).Copy
   Workbooks("Master").Worksheets("Today").Range("D1").PasteSpecial Paste:=xlPasteValues
   Application.CutCopyMode = False
End With
End Sub

 

[NileshAPatel]

How about

Sub test()
'Copy paste only values
With Workbooks("CustomerOrderReport.xls").ActiveSheet
   .Range(.Range("A3").End(xlToRight), .Range("A3").End(xlDown)).Copy
   Workbooks("Master").Worksheets("Today").Range("D1").PasteSpecial Paste:=xlPasteValues
   Application.CutCopyMode = False
End With
End Sub

Thanks for quick reply

Error is showing "Run-time error '1004' Application-defined or object-defined error


Regards

 

[NileshAPatel]

Thanks for quick reply

Error is showing "Run-time error '1004' Application-defined or object-defined error


Regards

I am very much sorry, it's work perfactly...
I did a mistake in editing my code which later on i compare with your and found mistake.

Thanks once again for your quick and grateful support.

Regards
Nilesh Patel

 

[Fluff]

You're welcome & thanks for the feedback.