+ Reply to Thread
Results 1 to 2 of 2

saving excel files by cell data automatically

  1. #1
    Registered User
    Join Date
    06-17-2007
    Posts
    1

    saving excel files by cell data automatically

    I got a Tough One here.

    How can i make an excel spreadsheet ALWAYS save automatically by just closing it with the X on the top right corner, BUT, it will have to save it with the requirements below:

    1. This spreadsheets must have " Avery " as the prefix
    2. This spreadsheets must contain whatever data is in cell (B6) AFTER the prefix
    3. This spreadsheets must contain whatever data is in cell (B4) as the suffix.

    IE:
    Cell (b4)'s data is "C15" and cell (b6)'s data is "Joe Blow".

    Once i open the spreadsheet, input the daily data in (A1:F23) all i have to do is close it, and it will save as " AveryJoeBlowC15 " in the specified folder of my choice.
    Can anyone help me. I need this badly. I spend too much time making another spreadsheet with different data ( a lot of the times i save over another file...grrrrr) and i would like to use the same spreadsheet over and over again, with different customer names, and know i couldn't mess it up even though i tried. This will help me get organized, look up spreadsheets by customers names, and quicker to get from a finished spreadsheet to a blank spreadsheet.
    Thanks in advance.

  2. #2
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983
    The code may need to be modified to include a Path directory as well

    'These instructions pre typed & are worded to cater for the novice programmer

    'To install macro to correct location

    'Copy this macro
    'GoTo Excel
    'Open VB Editor by pressing Alt + F11
    'Just below the menus & toolbars on the left you should see Project - VbaProject window
    'In this window you will see ThisWorkbook
    'double click on ThisWorkbook - opens ThisWorkbook module sheet
    'Paste macro code into big window on right


    Please Login or Register  to view this content.
    Last edited by mudraker; 06-17-2007 at 08:29 AM.
    Please Read Forum Rules Before Posting
    Wrap VBA code by selecting the code and clicking the # icon or Read This
    How To Cross Post politely

    Top Excel links for beginners to Experts

    If you are pleased with a member's answer then use the Scales icon to rate it
    If my reply has assisted or failed to assist you I welcome your Feedback.

+ 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