Solved

Copy an excel sheet from a workbook

Posted on 2014-04-23
6
12 Views
Last Modified: 2016-05-18
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
Comment
Question by:alam747
  • 2
  • 2
6 Comments
 
LVL 33

Accepted Solution

by:
Norie earned 500 total points
ID: 40018911
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
 

Author Comment

by:alam747
ID: 40019176
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
 
LVL 33

Expert Comment

by:Norie
ID: 40020512
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
 

Author Comment

by:alam747
ID: 40024110
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Sorting the contents of a text string in Excel in Alphabetical order. 8 54
Re-indent word doc 5 33
Excel Max 6 32
Check version 13 61
Outlook Free & Paid Tools
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now