+ Reply to Thread
Results 1 to 3 of 3

Save only certains worksheets

  1. #1
    Forum Contributor MariaPap's Avatar
    Join Date
    10-19-2013
    Location
    Chania-Crete-Greece
    MS-Off Ver
    Excel 2003-2010
    Posts
    319

    Save only certains worksheets

    Hello

    I have a big workbook with many(50) workshhets and almost 100 userforms.

    In one of these userforms for security reasons i use the code
    Please Login or Register  to view this content.

    ThisWorkbook.Save
    at the end of my whole code.

    As the book is very big it's takes much time, so as i need (in fact) to save only the data of certain 2 sheets, i think that i'll reduse the time saving only these 2 sheets.

    Any idea how to do it?

    Thnks in advance for any idea.

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,198

    Re: Save only certains worksheets

    What is the purpose of saving the sheets? They can be exported to a new workbook and saved, which would be much smaller. However do links need preserving and is the data needed in your master workbook.

    If it is needed in your master workbook (or does it refresh each time it is run, so you don't need to save it?)

  3. #3
    Forum Contributor MariaPap's Avatar
    Join Date
    10-19-2013
    Location
    Chania-Crete-Greece
    MS-Off Ver
    Excel 2003-2010
    Posts
    319

    Re: Save only certains worksheets

    Thanks for your reply

    I save eatch time that specific code, runs, because i need to be sure that in any case, i would not loose data that i tranfered.

    That's why i asked to save only 2 sheets, after specific code is runing.

+ 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. VBA if cell value = “no” then copy certains cells from same row to next blank row
    By millen182 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-04-2013, 04:35 PM
  2. How to I tell UsedRange to not include certains rows?
    By Ejb123erok in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2013, 06:15 AM
  3. If a cell contains a specific value, then certains cells require to be totaled
    By unreal_event_horizon in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-12-2013, 04:46 AM
  4. How to save more than one but not all worksheets?
    By ksagermann in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-20-2011, 04:58 PM
  5. Delete entire row if certains cells are blank
    By ZH1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-11-2011, 01:42 PM
  6. Save Worksheets as CSV
    By jregan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-11-2010, 07:11 AM
  7. Counting numbers (if) certains cells have txt
    By Hondoshaver in forum Excel General
    Replies: 4
    Last Post: 04-02-2010, 05:48 PM
  8. Save worksheets as PDF
    By Edward HS in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2008, 10:07 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1