Word 2010 vba save as pdf filename

Have questions or feedback about office vba or this documentation. Vba codesaveas pdfwith todays datein a certain file location. I have excel 2010 and i go filesave as and change the save as type to pdf. I would like a macro button to print the active sheet which i am working on to the desktop as a pdf document with a concatenated file name of the salesman and the date. The following macro code will export the active sheet or sheets in pdf format.

Some of the arguments for this method correspond to the options in the save as dialog box file menu expression. If you bookmark the field you want to use for the filename with the name name, you could use a macro like the following. I need the data captured in that userform and stored on an excel sheet to a populate a word document or a pdf and attach itself to an outlook email. But your code would not work with latebinding, since you must already have a word reference set for things like wdformathtml to work. I have attached a demo sheet like the excel sheet i will be working on. Then well access that file within microsoft word and use the builtin saveas pdf option in word 2010 or word 20 to produce a pdf file in the same folder as the original word document. How can i save a word document as a pdf file with a merged. Vba code to save word document solutions experts exchange. I have found the code below to save a word document as a pdf that opens the save dialog box, automatically gives the filename and set to save as pdf is it possible to add a code to automatically specifiy the save folder location using the dialog box method. Furthermore, according to the word vba help, saveas doesnt take a fileformat argument.

It is working perfectly except the output needs to be a. Vba codesaveas pdfwith todays datein a certain file. I had a similar question recently where i needed a macro to open the save as dialog box in excel and save my selected print area as a pdf. If you are using office 2010, you can save files in an earlier version of office by selecting the version in the save as type list in the save as dialog box. Vba to pop up save as box in excel to save as word doc. This is the current active workbook from with in the vba code. The code is written to save your pdf in the same folder as the word document file currently resides.

Use the saveas method to save a document with a new name. This method requires that you specify the new file name, but other arguments are optional. You can copy any content you want from it, including images and diagrams. Saves the specified document with a new name or format. The document consists of 15 reports for different department heads.

I now need this same scenario, but i need to save as a word document. The code is written to save your document in the same folder as the excel file currently resides. You can help protect yourself from scammers by verifying that the contact is a microsoft agent or microsoft employee and that the phone number is an official microsoft global customer service number. Save as pdf macrovba with predetermined file name hello i am adding a control button to a form template in word 20 and i need to write a macrovba that will save the form as a pdf with a predetermined name, along with the name from the formfield, and date. Macro to save as pdf in word 2010 microsoft community. The file path is self explanatory just make sure you have the \ at the end. The output file is saved to the same folder as the mailmerge main document. Copy the code to a regular code module, then select the sheets you want to export, and run the macro see the section further down, for details on how the macro works note. Currently, we do it the long way, saving it one pdf at a time using save as. Please see office vba support and feedback for guidance about the ways you can receive support and provide feedback related articles. Microsoft word vba to save document as a pdf in same. If you want the same default file name to be used for all documents of a specific type.

Since excel 2010, it has been possible to save excel files as pdf documents. Save, back up, and recover a file in microsoft office. I have created the following code to create a folder save a word file with the correct name in that location. How to change the default file name used when saving word. A while back, i had a request to automate the way users can create a pdf file from ms word, and attach it to an email essentially create a word to pdf macro, with automatic email creation. To specify an external file format, apply the openformat property to a fileconverter object to determine the value to use with this argument. If you need to make modifications, hopefully, you will be able to follow along with my code comments and customize the code.

I have built a userform that asks 29 questions, including freeform text and radio buttons. Find answers to vba code to save word document from the expert community at experts exchange. If you need to make modifications, hopefully, you will be able to follow along with my code comments and customize the code to. Hello, please can someone help me out with a macro. Vba save file dialog, filedialog msofiledialogsaveas excel vba save file dialog, getsaveasfilename excel vba open file dialog. The file converter to be used to open the document. Vba saveprint a word document as a pdf developers hut. Vba code to save document as pdf using document property text and rename folder. The document encoding code page or character set to be used by. You can use this method of the document host item in a documentlevel word project, or of a native document object in any word project. Word vba split document by headings save file name as heading name.

You can copy any content you want from a pdf by opening it in word. In other words, if you use this filename structure, the new pdf file is saved in the. Make sure that the cell is wide enough to display the full. Tech support scams are an industrywide issue where scammers trick you into paying for unnecessary technical support services. Save word file as pdf in specific location posted in ask for help. I also have acrobat on my computer so i have the acrobat tab that has create pdf as an option.

I tried to create one myself but got stuck at the point where you have to enter a file name. Merely declaring oword as object doesnt magically turn it into latebinding code. This information also applies to microsoft word starter 2010. Word vba, get current file path and name vba and vb. The consequence of including the statement activeworkbook. Some of the arguments for this method correspond to the options in the save as dialog box file tab syntax. They can be used on their own or as part of larger processes. Save word file as pdf in specific location ask for help. I am going to have a workbook that is going to have at least 80 tabs to it and dont want to do that for all of them. Below is a simple vba macro that will allow you to quickly turn your microsoft word document into a pdf file in a snap. Close end if kill filename deletes the pdf or word that was just created end if 3 condition met next custrow wordapp. What i am doing is separating the file path and the actual file name for the sake of organization. The code examples below provide the vba options to automate the creation of pdfs from excel. Save or convert to pdf or xps in project desktop office.

I suspect that you are using some form of date in k17 and then some cell formatting magic to get what you want as a filename. Macro for excel 2010 to save as pdf and then email. Word 20072010 mail merge to save to individual pdf files. Hi all firstly i am a complete beginner when it comes to vba. Macro to save as pdf with ability to choose save as folder. Pdf was then and continues to be, a common file format for distributing documents. Value, the date will be represented as a short date with forward slashes which cannot be used in a filename. The task has fallen to me to write a macro for word 2010 that outputs to pdf, using words save as pdf i have the macro saving out to pdf, which iterates down from a selected directory, and exporting all. If you need assistance with your code, or you are looking for a vba programmer to hire feel free to contact me. Saveas filename, fileformat, lockcomments, password, addtorecentfiles, writepassword, readonlyrecommended, embedtruetypefonts, savenativepictureformat. Vba save a new unsave document without prompting user for a file name. The macro we are going to write will literally save the file as pdf in the same directory and with the same filename as the opened document. For more information about how to save files in pdf. Im using word 20072010 mail merge and i want to create individual pdf files.