Results 1 to 3 of 3

Thread: [RESOLVED] [Merge WorkBooks]Two Different Excel report saved in one! Is that possible?

Threaded View

  1. Aug 17th, 2012, 03:34 PM #1
    brss
    brss is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jun 2012
    Location
    I'm living in VBForum bcz its members deserve respect and appreciation
    Posts
    333

    Resolved [RESOLVED] [Merge WorkBooks]Two Different Excel report saved in one! Is that possible?

    Hello Folk, I'm generating two different excel report, Report 1 save to Sheet1 and Report2 saved to Sheet2, I'm actually looking forward to save those report in on Excel worksheet. What I'm facing now when generate report1 it save to [Sheet1] and generate Report2 and saved to [Sheet2] I did found only Sheet2 Data and Sheet1 blank. Is it possible when generate report1 and save it under name [ReceivedAsia] then generate report2 and save it under same name without delete report1 [Sheet1] Data?. I'm using save as as code below. Thank you very much

    Code:
    'Report1 procedure code
xlwk.Worksheets("Sheet1").SaveAs "E:Reports\ReceivedAsia" & vernum & Format(Date, "~mm-dd-yyyy") & ".xls"
    Code:
    'Report2 procedure code
xlwk.Worksheets("Sheet2").SaveAs "E:Reports\ReceivedAsia" & vernum & Format(Date, "~mm-dd-yyyy") & ".xls"
    Edited: To combine those report1 to [Sheet1] and report2 to [Sheet2] i did use COPY and PASTE after generating report1, 2. Very annoying right.
    Last edited by brss; Aug 27th, 2012 at 03:52 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width