+ Reply to Thread
Results 1 to 4 of 4

Auto-fill Save as field

  1. #1
    Registered User
    Join Date
    01-29-2015
    Location
    Brazil
    MS-Off Ver
    2007
    Posts
    2

    Auto-fill Save as field

    Hi all,

    I am trying to make an excel spreadsheet as simple as possible for multiple users, most of whom do not know how to use excel, nor will they admit to it.
    I thought what i wanted to do was simple, i guess not.

    I want the 'save as' field to automatically populate with the information from a specific cell.

    For example: B2 has John Doe as the cell's content. I want to be able to click 'Save as' and have either the 'save as' box populate with John Doe, or to have the document save as John Doe without a prompt.

    Is this possible?

    Jimy

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    6,257

    Re: Auto-fill Save as field

    Sure: to save it as a macro-enabled xlsm workbook

    Please Login or Register  to view this content.
    Or as a xlsx:

    Please Login or Register  to view this content.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Registered User
    Join Date
    01-29-2015
    Location
    Brazil
    MS-Off Ver
    2007
    Posts
    2

    Re: Auto-fill Save as field

    Hi Bernie,

    I can't seem to get it working. I'm not sure if it is because i am using an xltm document or because i have a second code being applied.

    Sub Worksheet_Change(ByVal Target As Range)

    Dim cell As Range
    Application.EnableEvents = False

    For Each cell In Target
    Select Case cell.Row
    Case 10, 11, 12, 13, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 39, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52
    cell = UCase(cell)
    End Select
    Next cell

    Application.EnableEvents = True

    End Sub
    Sub Worksheet_autosave()

    ActiveWorkbook.SaveAs "C:\Users\Pessoal\Desktop\Historico_2015.2" & Range("B10").Value & ".xlsm", 52

    End Sub

  4. #4
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    6,257

    Re: Auto-fill Save as field

    You need to put your second macro into a standard codemodule, and then call it manually. There is no autosave event.....

+ 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. macro to bring up stored workbook, auto save to a new folder, then auto fill
    By Rick23 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-29-2014, 06:58 PM
  2. Auto fill macro for fields below the active field
    By Macgyver7 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-11-2014, 06:26 PM
  3. Auto Complete/Auto Fill address field
    By moates in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 05-09-2012, 09:15 AM
  4. Auto Fill last field
    By doubl3d80 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-10-2011, 08:08 PM
  5. Auto-Fill a field based on who is signed on to XP
    By rcgus in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-23-2009, 10:51 AM
  6. Auto Fill Field macro
    By chris99923 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-31-2007, 07:35 AM
  7. [SOLVED] Macro Auto-Fill Field.
    By Josh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2005, 06:07 PM

Tags for this Thread

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