Hi everyone again. I am here looking for your help on further develop this macro to copy data from one workbook to another.
This macro, from the help of arlu1201, can copy data from one workbook to another. However, I have tried for many days to
make this macro to copy values and not formulas or links. All the data on “Stats” sheet should be copied as values to
workbook report2012.xls. I have used .PasteSpecial or Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
This is the macro the I am currently using:
Dim MFile As String
Dim lastrow As Long
Dim frow As Long
Dim lrow As Long
MFile = "C:KBD projectreport2012.xls"
If MFile = "" Then
MsgBox "Please open the KBD Shop Floor Reports 2012", vbCritical
MFile = ActiveWorkbook.Name
lastrow = ThisWorkbook.Worksheets("Stats").Range("A" & Rows.Count).End(xlUp).Row
ThisWorkbook.Worksheets("Stats").Range("A2:V" & lastrow).Copy _
Workbooks(MFile).Worksheets("Libros").Range("A" & Rows.Count).End(xlUp).Offset(1, 0)
Could someone explain to me what I am doing wrong? I am very new to VBA, but I am willing to work hard and learn. See
attachment for detail.s
Again, thank you everyone, specially my friends for your time and knowledge.