Copy an excel sheet from a workbook
Posted on 2014-04-23
I did as below to copy a sheet from an excel workbook include all data include a windings a face character. while it creat workbook and copy the sheet winding face is disapear also source excel sheet background is white no grid but while copied the sheet with grid line which is normal background of an execel sheet while open.
Set ws_Source_04 = wb_Source_01.Sheets("Newtest") this is the source sheet which is in white backgroud with winding face character
Set wb_Source_02 = Workbooks.Add
wb_Source_02.Sheets(1).Name = "testresult_01"
Set ws_Source_05 = wb_Source_02.Sheets("testresult_01")
ws_Source_04.Cells.Copy Destination:=ws_Source_05.Cells(1, 1)
Would you advice where to change to get expecting result.