VBA code for "Save as PDF"
I am trying to print an excel file (has 2 sheets) to a Adobe pdf. I am not using DISTILLER.
I recorded the below macro and it works great for converting excel to pdf SO first part of what I am trying to do is OK!
Application.ActivePrinter = "Adobe PDF on Ne02:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"Adobe PDF on Ne02:", Collate:=True
When I run this code, it opens "Save PDF file As" window. I believe this is from the adobe pdf. I just need the file to be saved by the DEFAULT name without further asking or opening anything else.
I followed a few threads on similar file conversion topics but got lost so I opened this new thread which is more about save the file with default file name in pdf.
I had to reformat my laptop, re-installed all the software I had before including Office 2007.
Just tried to save a spreadsheet I created in Excel as a PDF but cannot do it. I could before I reformatted the computer. Went to the Microsoft Download Center page and tried to download : "2007 Microsoft Office Add-in: Microsoft Save as PDF or XPS"
but received a message saying : "Save As PDF & XPS.exe is not a valid Win 32 application." I have seen this message before when trying to download other software, what does it mean ?
And is there another way to enable saving as a PDF ? I have Adobe Reader 9.1 on my computer.
I am trying to save an excel file as PDF using vba, but all I can do is print as PDF, which takes the bookmarks away. I need my PDF to keep the bookmarks, which are the sheet names in excel. I can manually do it if I go to save as>ADobe PDF, but is there a way to do this in vba? or a way to print as PDF and keeping the bookmarks?
How do I save a report to PDF with VBA code?
Name that File with a project number and the Report Name Then send it to a certain File Path?
All with the click of a button.
Im a little stuck
I have a VB set up that "Save As" the SHEET, with name based on the contents of a particular cell. - which works perfectly.
I then have another VB setup to save new file as a PDF.
The issue I'm coming across is that it is saving the PDF as the original excel
workbook's name, not the new "Save As" name
Sample.xls has contents in Cell A1, when Macro activated it saves the active sheet as a new file with the contents of A1 as its name. Lets say Bob.xls
Sample.XLS also has another Macro, which when activated, saves as a PDF.
This macro is carried over to the newly created bob.xls
Issue is, it is saving bob.xls's PDF, as sample.pdf.
Anyway I can get it to save as bob.pdf without having to create a new macro every time?
Related Applications & Scripts
Save your PDF form to disk and open it again without loosing your entries.
Who has not come across the situation: You complete a PDF form in Acrobat Reader and when it comes to saving your data, nothing happens. Or worse: You close the program and all your data is lost. The reason for this is: Acrobat Reader cannot save any form field data! This is not only time consuming but also very unpleasant.
pdf-FormServer eliminates this problem in a very easy way! Once this software solution has been installed, all filled out PDF forms can be saved locally either as FDF, XFDF (for further electronic processing) or directly to PDF. No need to mention that all forms that have been filled once can be read again with the included data and also altered at a later date or send by email.
Converter "SharePDF" allows you to convert PDF file to most popular graphic formats: jpg, gif, png, bmp and tiff. It is easy to use and does not require any special skills. "SharePDF" helps you to save each page of PDF document as a separate graphical file. Using SharePDF you can convert your PDF document in a few mouse clicks.
- Supports PDF that created with English, French, German, Italian, Chinese, Janpanese and other languages.
- You can view contents of page before converting.
- Accepts user defined compression ratio for images in JPG format.
- Create multi-page file in TIFF format.
- Supports password-protected PDF files.
Create PDF files, collaborate and review, fill and save forms, add text to pages, QuickSign documents, and more...
Create PDF files from over 300 different formats. Comment, review, and collaborate. Fill and save PDF forms. Extract text and images. Type text directly onto the page.
Nitro Reader is the only free PDF reader to offer the ability to create PDF from virtually any Windows application.
Stop trying to work with PDF and start making PDF work for you. Digital documents are transforming the way we all work together, but premium collaboration tools have never been available in a free PDF reader.
Nitro Reader lets you import your handwritten signature as a stamp to electronically sign and return documents in seconds.
Now you can finally save a PDF form. With no arbitrary need for the originator to enable functionality, you can start working with forms the way they were designed.
Nitro Reader offers a range of powerful tools to extract text and images, allowing you to work with PDF in a way you probably didn't think possible in a free reader.
PDF to DWG Converter, help you convert PDF to DWG or PDF to DXF file, high quality, ease of use.
Did you get PDF files with CAD drawings inside? Now you can Import these PDF files and save as usable, editable DWG files, with this AutoDWG PDF to DWG Converter program.
Accepts single page or multi-page PDF input;
Convert PDF file to native DWG file;
High quality, ease of use;
Select specific page(s) to be converted;
Retain lines, arcs, true type texts;
Convert raster image to vector entities (Stand-alone version only);
Support batch conversion.(Pro version only, contact us for details)
With this plug-in for wordpress you can create PDFs from HTML code on fly and save them in a specific folder of your blod. For example, you can create an invoice with this script and archive it.