VB Code tweak help please

[Rich4689]

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

 

[Fluff]

Hi & welcome to MrExcel.
How about

With Workbooks.Open(Application.GetOpenFilename("Excel Files, *.xls*"), UpdateLinks = True)
   wsDest1.Range("A1:CK15").Value = .Sheets("DW IN").Range("A1:CK15").Value
   .Close False
End With

 

[Rich4689]

Hi & welcome to MrExcel.
How about

With Workbooks.Open(Application.GetOpenFilename("Excel Files, *.xls*"), UpdateLinks = True)
   wsDest1.Range("A1:CK15").Value = .Sheets("DW IN").Range("A1:CK15").Value
   .Close False
End With

Your a star - Thank you very much, it worked treat

 

[Fluff]

You're welcome & thanks for the feedback.