Word to pdf vba

These macro codes are well commented and are completely functional when copied into a module. The business world has increasingly become more reliant on mobile computing with devices such as tablets and smartphones becoming mainstream. This, in turn, has provided an elevated demand for analysts to turn spreadsheets into PDF documents so management can view your reports on the go. If you need to make modifications, hopefully, you will be able to follow along with my code comments and customize the code to your specific needs.

Click [No] to Rename. Path, InStrRev. Path - InStrRev. Below is a function that you will need to paste in along with the above macro. SaveAs2 ActiveDocument. I am very grateful that you have shared your solution here.

Thank you very much for your great codes. There were some errors always till I see your codes. It works well immediately without problems. Dear Mr Pineault, I want to tag along respondents to your code, because that is exactly what happened to me: neither the forum I frequently visit nor searches through innumerable pieces of code produced what I needed.

Your code above did at once, no issues, immediately… to my immense relief! Thank you times a million. Thanks for your codes. It works very well. I have one question: oDoc. If you look at the official documentation for the Document. Your email address will not be published. Quick access. Search related threads. Remove From My Forums. Asked by:.

Archived Forums. Sign in to vote. The error message I get is "Invalid procedure call or argument" The Folder variable that stores the file in a given folder and works fine for the word document so don't believe that has anything to do with the issue.