Vba code to convert xls to pdf

PasteSpecial xlPasteValues. Rows 3. Select Selection. Rows 4. Rows 5. Rows 6. Rows 7. Rows 9. Rows InchesToPoints 0. InchesToPoints 1. Name Debug. Print Sheets i. Name Next i Sheets shtAry. Select Debug. Print ThisWorkbook.

Close End Sub. Cells dataStartRow, 1 , thisWs. Add With newws. Is there a way, when exporting as PDF. I have an Invoice program, which I had made with LibreOffice. In this program, there are two workbooks. First one is a stock file, where I keep the records of each item in the inventory such as description, cost, selling price, Tariff Code, etc. Second workbook has a link to the first one so if I make any changes, it automatically updates with the new values.

In the second workbook, I simply enter order code and quantities and it fills the invoice template. For each page, there are 25 entries. So if the invoice has more than 25 items, it automatically goes to second page. Range: It can be a fixed range, a dynamic range or a selection. You need to define it. Let's say you have to print and send receipts in Excel on a regular basis. In that case, you would like to have it automated. You wouldn't want to do the export excel to pdf over and over again.

If you can just use a button to do this it would be helpful, isn't it? Here, I have designed this receipt format. This receipt covers the range "A2:L21". I have already set the print area. We will adjust the code as per our requirement.

Adjust the range and the file path if you want to in the code that you want to print. You can download the working file below. The code is simple. First, we have created two variables. In the above two lines, we first name the file with a timestamp and then add to the path of the main file. As a result, pdfile contains the fully qualified name of the resultant pdf file. We define type as xlTypePDF. We set the Filename as pdfile, which contains the string of the fully qualified name of the pdf file.

You can write a hardcoded text here or customize it as per your need. Next, we set the quality of the pdfile as xlQualityStandard. We have another choice as xlQualityMinimum. It prompts you to select a folder for the saved PDF file, and you can change the default name, if you prefer something different. In the macro below, the default name is based on the values in cells A1, A2 and A3 on the active sheet. The PDF file is automatically saved in the current folder -- you are not prompted to choose a folder, and cannot change the default name.

The PDF file is automatically saved in the current folder, with no prompts. However, if a file with that name already exists in the current folder , a message asks if you want to overwrite the file. Click Yes or No in the message box. In one of the Excel forums on the Microsoft website, someone posted the following solution to the problem.

By deleting the following Registry values, the problem goes away:. For the record, these values are all okay. There is nothing wrong with them.

The blame is entirely on Microsoft Office, i. This short video shows the steps for copying macro code to a regular code module.