Results 1 to 8 of 8

Copy Worksheets to new book without formulas then email

Threaded View

fastcar Copy Worksheets to new book... 05-13-2022, 10:02 AM
alansidman Re: Copy Worksheets to new... 05-13-2022, 10:31 AM
fastcar Re: Copy Worksheets to new... 05-13-2022, 10:55 AM
alansidman Re: Copy Worksheets to new... 05-13-2022, 11:35 AM
fastcar Re: Copy Worksheets to new... 05-13-2022, 12:13 PM
alansidman Re: Copy Worksheets to new... 05-13-2022, 06:48 PM
fastcar Re: Copy Worksheets to new... 05-13-2022, 08:04 PM
alansidman Re: Copy Worksheets to new... 05-13-2022, 08:21 PM
  1. 05-13-2022, 06:48 PM #6
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,705

    Re: Copy Worksheets to new book without formulas then email

    Instead of writing some code to do all this, why not just save your file as a pdf and email it then. Would save you a lot of aggravation. Any reason your recipients could not see the results as a pdf? Otherwise, look at this link where Mumps has provided code to do exactly what you wish

    https://www.mrexcel.com/board/thread...-only.1103800/
    Last edited by alansidman; 05-13-2022 at 06:54 PM.
    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] Copy Worksheets to a new book in a recorded Macro
    By LesleyB ATL in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-04-2019, 05:10 AM
  2. [SOLVED] Need to copy text between worksheets in same workbook to consolidated sheet in same book
    By Darc in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-06-2014, 07:03 AM
  3. Incorporate in existing PDF Email code 'copy data to another work book without opening it'
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-19-2014, 04:01 PM
  4. VBA macro to copy active sheet plus 4 days(variable) to new book and email
    By hawkeyemc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-03-2013, 06:23 PM
  5. Excel 2007 : Cannot copy Excel worksheets to a new book
    By jbosco1988 in forum Excel General
    Replies: 0
    Last Post: 06-08-2011, 04:42 PM
  6. Any way to Copy Multiple Worksheets into 1 Book
    By Rich Kniatt in forum Excel General
    Replies: 0
    Last Post: 03-01-2005, 08:47 PM
  7. Copy worksheets from one book to another
    By Grotifant in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-18-2005, 10:06 AM

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