+ Reply to Thread
Results 1 to 3 of 3

Excel VBA to convert documents to PDF

  1. #1
    Registered User
    Join Date
    05-19-2015
    Location
    Amsterdam
    MS-Off Ver
    2007
    Posts
    3

    Excel VBA to convert documents to PDF

    Hi All,

    I am new to VBA and looking for help. This macro will save me lots of time daily.

    In excel 2013, I would like to create the following VBA.
    In Cell “A1” I have written of the directory where all the files are saved.
    I am now looking for a macro, which open the directory as mentioned in cell “A1”.

    Let say the directory mentioned in cell A1 is: U:\Testing Macro\Macro testing
    Now on that particular directory, I would like to convert the: *.xlsx; *xls; *.docx; *.doc; *.png and *.jpeg files to .pdf
    The converted files should be saved on the same directory and with the same name, only now as a PDF file
    I googled a lot and read a lot but cannot find this VBA.

    Please please help me out here.

    Thanks and regards,

    Anand

  2. #2
    Valued Forum Contributor
    Join Date
    12-01-2016
    Location
    Planet Earth
    MS-Off Ver
    95 - 2016
    Posts
    343

    Re: Excel VBA to convert documents to PDF

    Excel Forum have rules in place and you had just broken one of them.

    Rule 8. Don't cross-post without a link. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post. Expect cross-posts without a link to be closed.

    I found the same/exact post here: https://www.mrexcel.com/forum/excel-...files-pdf.html
    Last edited by Syrkrasi; 06-14-2017 at 09:25 AM.

  3. #3
    Registered User
    Join Date
    05-19-2015
    Location
    Amsterdam
    MS-Off Ver
    2007
    Posts
    3

    Re: Excel VBA to convert documents to PDF

    Hi Syrkrasi and other users,

    Please accept my sincerely apologies for this. I did not know this. I deleted the cross posting. Was just hoping to get some help ASAP, as I am looking to solve this issue for quite some time now.

    Can you please help me out here?

    Please

    Anand

+ 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. Replies: 4
    Last Post: 12-04-2015, 04:20 PM
  2. Convert Word Documents in a folder to PDF
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-24-2014, 12:23 PM
  3. convert all 97-2003 excel documents to macro enabled documents on server
    By viperisback in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-23-2013, 09:06 AM
  4. [SOLVED] Can I convert linked into embedded documents in Excel 2003?
    By Karly Harly in forum Excel General
    Replies: 0
    Last Post: 05-11-2006, 12:40 AM
  5. [SOLVED] Can I convert documents from Quattro Pro to Excel?
    By Paige Pate in forum Excel General
    Replies: 0
    Last Post: 01-16-2006, 03:55 PM
  6. [SOLVED] excel documents won't open from my documents folder
    By Paul1961 in forum Excel General
    Replies: 2
    Last Post: 01-15-2006, 01:35 PM
  7. [SOLVED] Excel Documents Don't Appear in My Recent Documents
    By Addi in forum Excel General
    Replies: 4
    Last Post: 07-24-2005, 05:05 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