Macro - Export data to an already existing file

[lrmedina89]

Hi all,

I am having some troubles when it comes to create a macro to export data to an already existing file.

I have a file which will be changed every day (soruce file) and another one which I want to use as an archive (final destination file).

Can any of you give me soem hints? I am creating my own code but it doesn't do what I want and also modifiying some other codes that I found on the internet.

Thanks!

 

[lrmedina89]

This is the code that I am using
I would also like the macro to stop if there is a blank cell.

Sub Exportdata()


Application.ScreenUpdating = False
Range("B7:J27").Select
Selection.Copy

Workbooks.Open filename:="C:\Archive - orders.xlsm"
Range("B" & Rows.Count).End(xlUp).Offset(1, 0).Select
ActiveSheet.Paste Link:=True
Application.CutCopyMode = False
ActiveWorkbook.Save
ActiveWindow.Close
Range("B7").Select
Application.ScreenUpdating = True



End Sub