+ Reply to Thread
Results 1 to 3 of 3

VBA/Macro to copy and paste special to 2 new workbooks and save each with different name

Hybrid View

  1. #1
    Registered User
    Join Date
    07-10-2013
    Location
    Toronto
    MS-Off Ver
    Excel 2007
    Posts
    25

    VBA/Macro to copy and paste special to 2 new workbooks and save each with different name

    Hi can anyone help me with some code to :

    1) Take original workbook named "Original.xlsm"
    2) create new workbook and copy and paste special values and formats for all sheets
    3) save this new one as New.xlsx
    4) create new workbook from this sheet and copy and paste special values and formats for all sheets
    5) save this new one as New2.csv

    help on any or all of this is great - very much appreciated, thank you so much, don't know code very well

  2. #2
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: VBA/Macro to copy and paste special to 2 new workbooks and save each with different na

    Please provide sample excel workbook, mean while i will work on this
    Thanks - Naveed
    -----------------------------
    If the suggestion helps you, then Click * to Add Reputation
    To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
    1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

  3. #3
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: VBA/Macro to copy and paste special to 2 new workbooks and save each with different na

    Maybe:

    Sub oddinho2()
    Dim wbk As Workbook
    Set wbk = ActiveWorkbook
    Workbooks("Original.xlsm").Activate
    ActiveWorkbook.SaveAs "New" & ".xlsx"
    Workbooks.Open "Original" & ".xlsm"
    ActiveWorkbook.SaveAs "New2" & ".csv"
    Workbooks.Open "Original" & ".xlsm"
    wbk.Activate
    End Sub
    Have the macro code in a separate workbook.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Simple copy and paste macro- Paste special help needed.
    By hernancrespo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-20-2012, 07:02 AM
  2. copy and paste special values between two workbooks
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-25-2012, 02:27 AM
  3. Copy and Paste special Macro
    By montego in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-10-2010, 05:40 PM
  4. Macro to Paste Special Values, Remove Sheets and Save
    By Dexta_Dark in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-10-2008, 11:58 PM
  5. [SOLVED] Can't Copy and Paste or Paste Special between Excel Workbooks
    By wllee in forum Excel General
    Replies: 6
    Last Post: 04-05-2005, 03:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1