save as pdf

Hi Guys. I am trying to make a button that saves the current sheet as a PDF within a directory that is created by clicking a button previously. So, on my sheet, I have 2 buttons, the 1st creates a filepath with a name according to a reference on the sheet, and saves the excel document. I now...

Hello - I'm not very experienced when it comes to Macro's. I'm hoping someone can help me out. I have a workbook with around 20 worksheets in it. I'd like to place 3 separate macro buttons on each worksheet as follows... 1. That re-names the tab to the value of a particular cell in the...

Ok everyone, this is what I'm trying to accomplish, I am trying to create a macro that will be operated by a button that will format a range, then a selected range is saved as a PDF to any users desktop and THEN attached to an email followed by more formatting inside the excel sheet. I feel...

I have an excel workbook with hyperlinked cells that point to .pdf files located in various folders on my company network. I would like to be able to create a macro that will allow me to select a range of cells (containing hyperlinks) and save copies of the associated .pdf files to the current...

Hi, I got an workbook I want to save as pdf. I want the pdf to contain multiple sheets, and that can be done by selecting each sheet and then save it as pdf. The problem is that I don't know which sheet to included. That is because I want to see if it is contents in cell A7, and if so: include...

Hi I'm a little stuck and would greatly appreciate any assistance. I have looked over similar threads regarding this topic but couldn't seem to find what I was looking for. I currently have the following code that works great for saving as PDF with a file name referenced from certain cells...

Hello everyone. I'm developing a spreadsheet with some VBA codes. And one important part of it is the "SaveAsPDF" routine. However, in one of my sheets, there are 22 tables of varying height. Then, I'd like to know how can I insert page breaks after each table in the generated PDF, using the VBA...

The project I am working on requires me to create different PDF reports for 40 different inputs—which are currently in a data validation list box (and also listed in a column on the spreadsheet). The workbook is set on manual calculation. For now, I am manually selecting the input in the data...

Hello, I am trying to create a macro that will save my workbook as a PDF, but I am having trouble getting it to work properly. All I want to do is take the print range from each sheet and save it as one PDF, in the same location as the excel file, and same name (just .PDF instead of .XLSM) Any...

I am looking for a macro that i can assign to a master excel sheet that will recognise the **hyperlinked files * already in the file and print a certain sheet with the print area to a printer of my choice. How would i go about doing this? i have tried a number of macros i have seen online but...

Hi, I have the code below that saves the worksheet as a pdf with a certain name in a certain folder. I have this code several times throughout my macro and so my question is, can I make this into a function (and how I would do that) that I can call to make my code much neater? Also, if I wanted...

Hi guys, Yes, I know this question have been posted before, but I couldn't make use of the suggestions I found. This is my current code: Sub SaveAllAsPDF() Dim wsh As Worksheet, vWshs, vWshName RptDatum = Range("C10") vWshs = Array("SheetX", "SheetY", "SheetZ") With ActiveWorkbook For Each...

I started with VBA using "VBA for dummies" pdf as guide 3 days ago and have succesfully written some macros that r working fine.. i am currently working on a macro that: 1. selects a folder with illustrator files (that i tell it to) 2. opens all the files one by one in illustrator 3. saves the...

I have an excel workbook containing about 4 worksheets. The second worksheet has all the inputs I give and the outputs that I require. The fourth worksheet has graphs. All the calculations happen on other worksheets I need to create a command button, which when clicked saves a certain pages of...

Hi Everyone, I am creating a VBA macro. The purpose of this macro is to open a webpage and click on hyperlink and save the newly opened webpage in a separate window (it opens in PDF format) to a particular folder. My code is able to open a webpage and click on the hyperlink. But am stuck up...

Some excel files give me a problem saving as a PDF file, especially longer named files, it just does not convert them to PDF no errors/warnings. I can have a file that I want to save to PDF as xxx; xxxx; 2009(10).pdf and it will not save, but it might save as simply 1234.pdf. As far as I can...

Hey. I'm a complete novice when it come to macros and am struggling. I need a macro that will save my selected worksheet by prompting me with the 'SAVE AS' dialog box. All links I have previously read only seem to include a specific file or file name. Can anyone please help?

I have a large number of forms that are all organized in MS Excel. These forms are updated fairly often and I need to download the new updates when this happens. Each row has it's own hyperlink associated to the pdf document online. Currently I have to click each link which opens the file in IE...

Thank you for reading my problem: I have a spreadsheet with a couple of pivot tables and a master list. The master list is 3 columns : company name, contact name, contact email address. My code iteratively runs down the list of email addresses and updates the page of the pivot table to show...

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...