Excel VBA Introduction Part 41 - Saving as a PDF
Вставка
- Опубліковано 25 лис 2015
- If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
You can buy our Introduction to Excel VBA book here www.lulu.com/shop/andrew-goul...
By Andrew Gould
www.wiseowl.co.uk - This video explains how to use the ExportAsFixedFormat method to save various elements of an Excel file as a PDF document. You can apply this technique to the entire workbook, single worksheets and charts and even to a specific range of cells.
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio and more
As always a brilliant explanation, Andrew. It's impressive how the quality of your videos never get down, despite if it's an old or a new one. Thanks again.
Good morning Andrew. Thank you so much for another brilliant video. Explanations and speed of your presentation were perfect. Thank you so much for sharing. The code is very helpful. Have a lovely day! :)
Andrew, you are a super star!!!!! I already bought your book and as I live in the UK I wish to attend a training with you. You are the best!!!
Impressive as usual
This is good. But I wish you can share us more advanced level such as setting PDF passwords, reading contents, manipulating pages etc. As always, it is quite easy to learn with you.
Thank you so much!!!
Dear Andrew, I would like to Know if your videos on VBA will stay forever on UA-cam. I just got to video 8 so it will take a long time to get to the end of the course. Can your videos download on my home pc for my training only? I'm afraid to open the internet one day and not find these fantastic videos that have really started a new professional life but even more have enriched my personal culture. God bless you, you would deserve Nobel prize for teaching. Thank you very much from the depths of my heart.
Your all video's are very helpful, however could you please add one more video how to copy data from pdf file and paste it in excel using VBA. Thanks in advance.
Hi Andrew, Thanks for uploading this video. Can you pls suggest if we can also set password to the saved pdf file from reference cell?
Hi,
Hi, great video, can i password protect the PDF file?
Andrew, your video is super helpful. Thank you! Using 2016 Excel for Mac. When applied your code (ExportAsFixFormat xlTypePDF) I got it to work perfectly only a few days and suddenly I got 2 problems. When run the macro to save the sheet as pdf to the destination folder, my printer start print out the sheet instead of saving as PDF. It drives me crazy and I don't know how to fix it.
very good tutorial, but i have a question, when i save a sheet as pdf (not visible in workbook), an error appear, is there any solution for this problem, thanks
Thank you for sharing. Is it possible to print the same way with a textbox on a userform? What i mean is if the text to be printed is on a certain textbox on a particular userform just while the userform is open. Thank you in advance WiseOwl
Hi sir is it possible to export pdf or png file from outlook using loop method if we have multiple refrence in excel related to pdf and png file...?
Hello what if I want to save all my sheets in single pdf? Can u suggest me?
hi I want to change the path on certain parameter , i managed the same by using formula . however i dont no how to give referance to that cell as path refernence please help me out for this
Nice video
How can I save multiple parts (ranges and objects) in one PDF document?
Andrew it's always a great learning experience watching your VBA tutorials!