+ Reply to Thread
Results 1 to 8 of 8

Automatic worksheet saving

  1. #1
    Registered User
    Join Date
    05-31-2012
    Location
    Newcastle
    MS-Off Ver
    Excel 2010
    Posts
    20

    Automatic worksheet saving

    Hi,

    I hope i am posting in the correct forum.

    I am trying to get the following and was wondering if anyone can help me on this as i am a noob with VBA but think it may be my only option.

    We have a workbook that holds all revenue figures for the month, and we add values for each sale made, this workbook is made up of several worksheets that are saved down as single web pages at the end of the day into the relevant team folders on the network. What i would like to do is have the workbook automatically save each of these sheets into their relevant folders and in the correct format each time the book is saved or updated. Is this a simple code or is it quite complicated?

    Thanks in advance.
    Dan Lake.

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Automatic worksheet saving

    not clear
    you want to change files in folders or add new ones?
    you need a mask to name them in the latter case.

  3. #3
    Registered User
    Join Date
    05-31-2012
    Location
    Newcastle
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: Automatic worksheet saving

    Hi Tim,

    Basically every time we update the workbook and save it i want the book to automatically save down each worksheet into a specific location (same principle as 'move or copy' and then new workbook) and saved as a .mht file format, i want it to overwrite the last version that will be present in this location too without it asking to do so. Does this make more sense or would you like me to illustrate the process i am after?

    Thanks
    Dan.

  4. #4
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Automatic worksheet saving

    enought
    just could you post a string illustrating the relevant team folder's name on the network?

  5. #5
    Registered User
    Join Date
    05-31-2012
    Location
    Newcastle
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: Automatic worksheet saving

    I have added a test workbook and detailed on the first worksheet what i am trying to get to.

    Thanks
    Dan.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    05-31-2012
    Location
    Newcastle
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: Automatic worksheet saving

    Ok, please see below:

    H:\Team Manager\RVT\
    H:\Sales Team 1\RVT\
    H:\Sales Team 2\RVT\

  7. #7
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Automatic worksheet saving

    this sub is to copy thisworkbook module
    Please Login or Register  to view this content.
    and this to module1 (insert it)
    Please Login or Register  to view this content.
    and save xlsb or xlsm
    and permit macros
    PS add to the thread name "as .mht"
    Last edited by tim201110; 07-13-2016 at 09:44 AM.

  8. #8
    Registered User
    Join Date
    05-31-2012
    Location
    Newcastle
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: Automatic worksheet saving

    Hi Tim,

    Thank you very much for your help, i can always rely on this forum to help

    Thanks
    Dan.

+ 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. Automatic worksheet saving
    By Dooberry in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-12-2016, 06:58 AM
  2. [SOLVED] Saving worksheet using a macro. Problem is that it is saving more rows than it needs to
    By Kammphoto in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-04-2013, 10:09 AM
  3. [SOLVED] Automatic Saving
    By shyam sundar in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-22-2013, 04:18 PM
  4. Replies: 9
    Last Post: 01-07-2009, 09:02 AM
  5. Automatic saving of worksheet with unique names
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-08-2005, 09:05 AM
  6. automatic file saving
    By Tom Haley in forum Excel General
    Replies: 6
    Last Post: 04-05-2005, 09:06 PM
  7. Automatic saving
    By please help me in forum Excel General
    Replies: 3
    Last Post: 02-01-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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1