• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 31
  • Last Modified:

Copy an excel sheet from a workbook

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"
    wb_Source_02.SaveAs FileName
   

    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.

Thanks
0
alam747
Asked:
alam747
  • 2
  • 2
1 Solution
 
NorieCommented:
Have you tried this?
Set ws_Source_04 = wb_Source_01.Sheets("Newtest")
ws_Source_04.Copy
Set wb_Source_02 = ActiveWorkbook
wb_Source_02.Sheets(1).Name = "testresult_01"

Open in new window

It shoud copy ws_Source_04 to a new workbook, with all the data and formatting should be intact, and rename the copied worksheet with the name 'testresult_01'.
0
 
alam747Author Commented:
The workbook ( wb_Source_02 ) has need to have two sheets
wb_Source_02.Sheets(1).Name = "testresult_01"
wb_Source_02.Sheets(2).Name = "testresult_02"

only want to copy ws_Source_04 to "testresult_01"

also want to define cell width of sheet "testresult_02"

Please advice.... Thanks
0
 
NorieCommented:
This will copy both worksheets to a new worksheet.
Set ws_Source_04 = wb_Source_01.Sheets("Newtest")

ws_Source_04.Copy

Set wb_Source_02 = ActiveWorkbook

wb_Source_02.Sheets(1).Name = "testresult_01" 

ws_Source_05.Copy After:=wb_Source_02.Sheets(1)

wb_Source_02.Sheets(2).Name = "testresult_02"

Open in new window

0
 
alam747Author Commented:
want to use first raw of the 2nd sheet as header in bold character and set the width as autofit of cell (A:A) to cell(M:M)
and color the header in light blue ( only the first raw of the cell A ~ M ).

Please advise.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now