How to save an excel spreadsheet as a pdf

Landscape pdfDocument. SaveToFile "sample. Start "sample. Ross from Brooklin Ross from Brooklin 1 1 gold badge 4 4 silver badges 16 16 bronze badges.

You need to install a PDF library. Thanks SSS. It says the Workbook class does not exist. Is this a class that I need to set up? I thought it might be a system class. More info on how to reference the Excel interop: stackoverflow. Or is it runtime? Something with your references — T. Hi Sean - I followed the instructions outlined in the link you provided but when I looked at the Microsoft.. Excel Show 2 more comments. Active Oldest Votes. You can go simpler by using the. ExportAsFixedFormat function, e.

Dim workbook As New Workbook workbook. Add a comment. Late-bound version of nutsch's answer.. It does not, and cannot, contain formulas. So what you want is impossible. MS Excel is a very good file format when it comes to tabular data and mathematical calculation.

But the problem with MS Excel is that you can not combine text with tabular data in a beautiful way. Please visit the site I mentioned. They have done it. IF it is impossible, how could they do it. It is possible to create a form with calculations in PDF using Java or something like that , but you'd have to create it from scratch.

First of all, when you convert a worksheet to PDF, there is basically no way to keep the Excel formulas, let alone to influence the other values.

You can convert it to PDF, but then you need editing software, with an Adobe Reader you can almost only read and fill in fields. The greatest advantage of a PDF file, besides being usable on any computer and preventing text manipulation by the end user, is that there are no costs for the reader.

Products 72 Special Topics 41 Video Hub Most Active Hubs Microsoft Teams. Security, Compliance and Identity. Microsoft Edge Insider. Azure Databases. Autonomous Systems. Education Sector. Best Word to PDF converters. Best online PDF to Word converters.

How to convert Excel to PDF. Fantastic tutorial has helped in converting a document. I have a slight hiccup with it, its word document that is scanned as a PDF and then I do the conversion - it comes to us a paper version and sender for security will not send excel document.

The problem is when saving as web page, it puts the 1st column as one merged field at the bottom, anyway of fixing this? If I unmerge it, it doesn't fix the issue. Hello FREE.