+ Reply to Thread
Results 1 to 6 of 6

including a date (value from cell) in a Filename

  1. 04-23-2013, 10:44 PM #1
    mr_mango81
    mr_mango81 is offline
    Registered User
    Join Date
    02-05-2013
    Location
    Canberra, Australia
    MS-Off Ver
    Excel 2010
    Posts
    39

    including a date (value from cell) in a Filename

    I'm try to create a PDF export with the file name to be saved e.g. "Weekly Fuel Report 3-3-2013" where the date is a value found in cell S1. When I run the vba code without trying to insert a date it works fine, but as soon as the cell has a date value, it will not proceed.

    Please Login or Register  to view this content.
    Can anyone help me with this?
    Reply With QuoteRegister To Reply
  2. 04-23-2013, 11:15 PM #2
    JapanDave
    JapanDave is offline
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: including a date (value from cell) in a Filename

    I am assuming that srtname is the date,

    Please Login or Register  to view this content.
    Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
    I am the real 'Napster'
    The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...

    If you receive help please give thanks. Click the * in the bottom left hand corner.

    snb's VBA Help Files
    Reply With QuoteRegister To Reply
  3. 04-24-2013, 01:23 AM #3
    mr_mango81
    mr_mango81 is offline
    Registered User
    Join Date
    02-05-2013
    Location
    Canberra, Australia
    MS-Off Ver
    Excel 2010
    Posts
    39

    Re: including a date (value from cell) in a Filename

    Thanks JapanDave! That works beautifully!
    Reply With QuoteRegister To Reply
  4. 04-24-2013, 01:26 AM #4
    JapanDave
    JapanDave is offline
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: including a date (value from cell) in a Filename

    Not a problem.

    How is it down in Cold Canberra? I was born there.
    Reply With QuoteRegister To Reply
  5. 04-24-2013, 01:34 AM #5
    mr_mango81
    mr_mango81 is offline
    Registered User
    Join Date
    02-05-2013
    Location
    Canberra, Australia
    MS-Off Ver
    Excel 2010
    Posts
    39

    Re: including a date (value from cell) in a Filename

    It's great here mate, just starting to get cold though!
    Reply With QuoteRegister To Reply
  6. 04-24-2013, 01:36 AM #6
    JapanDave
    JapanDave is offline
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: including a date (value from cell) in a Filename

    Already! LOL
    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)

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