Hi, I have some code which i believe is copy and pasting the full contents of one file into another inc Formula and formatting. what i need is for the VB to write the info as values only
Could you let me know what to change - Thanks
With Workbooks.Open(Application.GetOpenFilename("Excel Files, *.xls*"), UpdateLinks = True)
.Sheets("DW IN").Range("A1:CK15").Copy _
wsDest1.Range("A1:CK15")
.Close False
End With
Could you let me know what to change - Thanks
With Workbooks.Open(Application.GetOpenFilename("Excel Files, *.xls*"), UpdateLinks = True)
.Sheets("DW IN").Range("A1:CK15").Copy _
wsDest1.Range("A1:CK15")
.Close False
End With