Excel Workbooks Converted to PDF (VBA)

Posted on 2011-04-19
Last Modified: 2012-05-11
Do you know if there is an easy way to convert 120 excel workbooks (all saved with the same folder) to .pdf files?
The workbook should be converted to .pdf and keep the same name as the existing .xls file but add a couple of additional characters to the name.
Question by:ArisaAnsar
    LVL 33

    Accepted Solution

    There are tools on the market that make batch convertion of Excel files to pdf:

    LVL 33

    Expert Comment

    This one is "only" $39...

    Author Comment

    Is there no other way?  It takes weeks before the vendor management team will be able to make a decision to install the application within the Firm firewalls.

    Author Closing Comment

    I'm closing this question as the solution worked from home instead of my work computer.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    I've recently been in need of an Excel macro that could add a letter before the text on multiple cells in an Excel document. My English is as it is, so I will try explain what it does diffrently. If you have an excel document with 2000 rows an…
    Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now