+ Reply to Thread
Results 1 to 2 of 2

Save spreadsheet as cell data and autosave?

  1. #1
    Registered User
    Join Date
    03-27-2010
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    16

    Save spreadsheet as cell data and autosave?

    Hello.
    I have a spreadsheet that people need to load, [statstemplate.xls], which asks for there first name [A1] and last name [A2] of the person and basically they fill in the data, then click new work [macro], which creates a new work line for them, but i need it to save with the following info:

    I need the [statstemplate.xls] to change to datefirstname_lastname.xls
    so it would look like this 30052010joebloggs.xls
    Also what i need as well is for it to create a folder for eg [ c:\stats\ ]upon the first time they use the template, and if there is already a folder named that, that it doesnt say there is, it just autosaves in there.
    Then every 5 minutes it auto saves in there.
    So basically upon running the first macro it
    a) creates a new folder
    b) doesnt ask to create it, or say there is already a folder there
    c) saves the statestemplate.xls as datefirstname_lastname.xls
    d) autosaves every 5 minutes.

    Thanks

  2. #2
    Registered User
    Join Date
    03-27-2010
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: Save spreadsheet as cell data and autosave?

    anyone? just needing to know thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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