+ Reply to Thread
Results 1 to 8 of 8

Send PDf file - debug error with filename when date is added

  1. 10-16-2015, 06:20 AM #1
    michelle 1
    michelle 1 is offline
    Forum Contributor
    Join Date
    07-02-2013
    Location
    abbots langley
    MS-Off Ver
    Excel 2010
    Posts
    316

    Send PDf file - debug error with filename when date is added

    Dear all

    I am trying to convert an excel file to PDF and email. The code worked fine until i added the date which seems to be a problem when attaching the pdf. I would be really grateful if someone could let me know where i am going wrong.
    Please Login or Register  to view this content.
    Many thanks in advance for your help
    Last edited by michelle 1; 10-16-2015 at 06:35 AM.
    Reply With QuoteRegister To Reply
  2. 10-16-2015, 07:00 AM #2
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Send PDf file - debug error with filename when date is added

    What's the error message?
    If posting code please use code tags, see here.
    Reply With QuoteRegister To Reply
  3. 10-16-2015, 07:11 AM #3
    michelle 1
    michelle 1 is offline
    Forum Contributor
    Join Date
    07-02-2013
    Location
    abbots langley
    MS-Off Ver
    Excel 2010
    Posts
    316

    Re: Send PDf file - debug error with filename when date is added

    Dear Norie,

    The error message i am receiving is Cannot find this file. Verify the path and filename are correct.

    I can see that the file has been saved as "My report 16-10-2015.pdf"

    Thanks for looking.
    Reply With QuoteRegister To Reply
  4. 10-16-2015, 08:24 AM #4
    Kenneth Hobson
    Kenneth Hobson is offline
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: Send PDf file - debug error with filename when date is added

    Try concatenating the pdf file extension.
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 10-16-2015, 08:55 AM #5
    michelle 1
    michelle 1 is offline
    Forum Contributor
    Join Date
    07-02-2013
    Location
    abbots langley
    MS-Off Ver
    Excel 2010
    Posts
    316

    Re: Send PDf file - debug error with filename when date is added

    Thanks so much this works perfectly, really appreciate your help.
    Reply With QuoteRegister To Reply
  6. 10-16-2015, 09:00 AM #6
    michelle 1
    michelle 1 is offline
    Forum Contributor
    Join Date
    07-02-2013
    Location
    abbots langley
    MS-Off Ver
    Excel 2010
    Posts
    316

    Re: Send PDf file - debug error with filename when date is added

    Would it be possible to add a second email address into this code?
    Reply With QuoteRegister To Reply
  7. 10-16-2015, 09:25 AM #7
    Kenneth Hobson
    Kenneth Hobson is offline
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: Send PDf file - debug error with filename when date is added 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 10-17-2015, 10:40 AM #8
    michelle 1
    michelle 1 is offline
    Forum Contributor
    Join Date
    07-02-2013
    Location
    abbots langley
    MS-Off Ver
    Excel 2010
    Posts
    316

    Re: Send PDf file - debug error with filename when date is added

    Thank you so much for your help.
    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. Record Filename and Creation date of file used in another file
    By garveyarmy in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-21-2014, 04:00 PM
  2. Macro has debug error when closing a file that is not checked out from a sharepoint
    By jrosko1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-25-2014, 10:12 AM
  3. VBA Code Runs in Debug Mode But Returns Type Mismatch Error Outside Debug Mode
    By valerie.k.chiang in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-24-2014, 03:48 PM
  4. [SOLVED] VBA Save a file with filename and last Sundays date.
    By Lady_Shaz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-04-2012, 06:36 PM
  5. Search for Filename with Date and Open File
    By Gingeiko in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-29-2011, 08:11 PM
  6. How to Stop Error and Debug if filename is not found
    By pmarsella in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-19-2009, 05:59 AM
  7. Any way to autosave new file with creation date as filename?
    By vk2003 in forum Excel General
    Replies: 4
    Last Post: 11-14-2005, 02:40 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