+ Reply to Thread
Results 1 to 4 of 4

SaveAs FileName: Date in Cell

  1. 02-14-2016, 02:56 PM #1
    melleniam
    melleniam is offline
    Registered User
    Join Date
    05-23-2007
    Posts
    41

    SaveAs FileName: Date in Cell

    Hi would you please assist me !

    I need a VBA to save as the file based on the value on a specific Cell

    the value is a Date, for example 14/02/2016 in Cell G9

    so the file name will be "Liquidity Report - 14022016"

    i tried the below VBA but it didn't work

    Please Login or Register  to view this content.
    Regards and Thanks
    Reply With QuoteRegister To Reply
  2. 02-14-2016, 03:05 PM #2
    mrice
    mrice is offline
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: SaveAs FileName: Date in Cell

    Try specifying the filename as a simple string rather than a formula.

    Please Login or Register  to view this content.
    Martin
    Reply With QuoteRegister To Reply
  3. 02-14-2016, 04:56 PM #3
    melleniam
    melleniam is offline
    Registered User
    Join Date
    05-23-2007
    Posts
    41

    Re: SaveAs FileName: Date in Cell

    it didn't work
    Reply With QuoteRegister To Reply
  4. 02-14-2016, 04:58 PM #4
    mrice
    mrice is offline
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: SaveAs FileName: Date in Cell

    What is the value of the filename variable after this line has executed?

    Add

    [CODE][/
    Debug.Print Fileline
    CODE]

    just after the line to see the value in the immediate window (Control G)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] SaveAs and Kill filename
    By milo1984 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-02-2014, 02:08 PM
  2. saveas filename=inputbox value?
    By jazbath in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-01-2008, 07:26 PM
  3. Use VBA to change a filename while using SaveAs
    By BigBas in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-14-2007, 01:55 AM
  4. VBA- SaveAs filename and add
    By Lucifix in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-21-2007, 06:09 AM
  5. [SOLVED] SaveAs with a pre-defined filename
    By Stefi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-09-2005, 11:10 AM
  6. SaveAs using two cells for filename
    By David in forum Excel General
    Replies: 5
    Last Post: 06-04-2005, 07:05 AM
  7. FileName SaveAs
    By alanford in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-18-2005, 10:48 AM
  8. [SOLVED] 'ActiveWorkbook.SaveAs Filename'
    By TOMB in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-15-2005, 08:07 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1