Results 1 to 6 of 6

Copy Data to New Workbook with VBA Code without saving new Workbook

Threaded View

SimonCampbell Copy Data to New Workbook... 10-19-2021, 05:45 AM
AliGW Re: Copy Data to New Workbook... 10-19-2021, 05:51 AM
SimonCampbell Re: Copy Data to New Workbook... 10-19-2021, 06:39 AM
AliGW Re: Copy Data to New Workbook... 10-19-2021, 06:42 AM
SimonCampbell Re: Copy Data to New Workbook... 10-19-2021, 06:52 AM
KOKOSEK Re: Copy Data to New Workbook... 10-19-2021, 06:53 AM
  1. 10-19-2021, 05:45 AM #1
    SimonCampbell is offline
    Registered User
    Join Date
    10-09-2017
    Location
    Stavanger, Norway
    MS-Off Ver
    O365
    Posts
    78

    Copy Data to New Workbook with VBA Code without saving new Workbook

    This should be easy but I can't seem to work it out. I have a worksheet, and want to copy (Range A1:O300) to a NEW Workbook and PASTESPECIAL Values and Formats
    Google and YouTube are just not delivering anything this simple. I want the VBA Code to do this.


    Hope someone can help
    Last edited by SimonCampbell; 10-19-2021 at 06:48 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VB Code to copy certain data to another workbook
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-31-2020, 12:16 PM
  2. [SOLVED] Copy data workbook to another workbook vba code
    By sbvaram in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-16-2019, 03:23 AM
  3. VBA code to copy data from current workbook to another workbook and send email
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-05-2015, 06:47 AM
  4. [SOLVED] VBA code to copy data to new workbook
    By AndyFarrell79 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-06-2014, 12:38 AM
  5. VBA code for copy data from closed workbook to "Data " sheet of current workbook
    By satputenandkumar0 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-13-2014, 02:23 AM
  6. [SOLVED] Code to copy data from a closed workbook and paste in active workbook using named range.
    By paullie1912 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-28-2014, 02:38 AM
  7. VBA code to copy data from one workbook to another workbook if one criteria is met.
    By mph1527 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-22-2013, 01:33 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1