+ Reply to Thread
Results 1 to 2 of 2

pdf save and send (date range filename)

  1. #1
    Registered User
    Join Date
    10-13-2009
    Location
    Newcastle
    MS-Off Ver
    Excel 2003
    Posts
    27

    pdf save and send (date range filename)

    Hi,
    Can someone please help; I have the below VBA code which is great, it requests a location to save the pdf and chooses the workbook name as the file name.
    I'm looking to edit this so that I can pre-set the location and also change the file name to the contents of cell C7. The information in this cell is a date which I believe also causes issues as it has /'s in.

    Please Login or Register  to view this content.
    Thanks in advance

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: pdf save and send (date range filename)

    Not sure what you mean by pre-set the location. I think you want to replace this:
    Please Login or Register  to view this content.
    With something like this:
    Please Login or Register  to view this content.
    If C7 has a date, and the file name is simply the date, yes you're right that "/" is an illegal character in a Windows file name. You can do this:
    Please Login or Register  to view this content.
    for dd-mm-yyyy format. You can, of course use any format. (I personally prefer yyyy-mm-dd so the the files can be sorted properly by name.)
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. [SOLVED] How to append date to the filename and save it in a different folder?
    By chunkyp in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-16-2017, 07:33 AM
  2. Dynamic Print Range + Filename to save as PDF
    By Alcotraz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-24-2016, 04:04 PM
  3. [SOLVED] Send PDf file - debug error with filename when date is added
    By michelle 1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-17-2015, 10:40 AM
  4. [SOLVED] Save Filename as Date
    By Krayvok in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-17-2015, 02:49 AM
  5. [SOLVED] Save Filename With Date In It
    By timbo1957 in forum Excel Programming / VBA / Macros
    Replies: 28
    Last Post: 05-20-2011, 08:08 AM
  6. Save xls with date appended to end of filename
    By mattmac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-29-2008, 06:41 AM
  7. [SOLVED] Date + Filename using save copy as
    By SKelley in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-27-2005, 05:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1