Excel macro - how to prompt for a save as file name in pdf? i have some very basic macros that create a pdf of select ranges in a worksheet when i send this file to someone else, the macro gets tripped up because it is looking for my computer? i tried stopping the recording at the "save as" screen but it doesn't work. Excel macro pdf filename. How to save a worksheet as pdf file and email it as an attachment through outlook? in some cases, you may need to send a worksheet as a pdf file through outlook usually, you have to manually save the worksheet as a pdf file, then create a new email with this pdf file as attachment in your outlook and finally send it.
excel macro pdf filename
Below is a simple vba macro that will allow you to quickly turn your selected worksheet(s) into a pdf file in a snap the code is written to save your document in the same folder as the excel file currently resides if you need to make modifications, hopefully, you will be able to follow along with. Since excel 2010, it has been possible to save excel files as pdf documents. pdf was then and continues to be, a common file format for distributing documents. the code examples below provide the vba options to automate the creation of pdfs from excel. they can be used on their own or as part of larger processes..
get link reference
