pdf creation

So the first part of my code creates a PDF from my sheets, then I am trying to figure out a second part where it grabs two PDF's from one folder and saves them as one PDF in a spearate folder. Sub PrintPages() ThisWorkbook.Sheets(Array("Front Page", "Last Page")).Select...

I am using Mac, Excel 2011. I have recorded a macro to select a certain area, create the page setups but I am unable to figure out how to set it up to print to pdf directly (instead of printing through the printer). Anybody, any idea how to handle this? Sub printpdf() ' ' printpdf Macro ' '...

Windows 7 - Excel 10 currently but initial started it with Excel 2003- I know enough to be dangerous. I have a good size Excel application running. I'm using modified Dom Hill, June 2008 code to Create_PDFs. The code takes all of the sheets you want to print and combines them into one PDF...

Hi, I was wondering if the following were possible: Can I put inside an array various instances of the same sheet? I mean, for example, Sheet1 with A1 = 10 (this is an instance). I change A1 value to 43 (second instance). So after various changes I would like all the instances to be remembered...

HI all, I found this bit of coding on here, so if the person that wrote it see this then I am very impressed. However I wanted some advice on how to customise it. I have attached the coding below. I was wanting to be able to specify the sheets it creates as a PDF, the result being that there...

I am part way through creating a Purchase Order system. I have so far: - One workbook - First worksheet 'Suppliers' is a list of suppliers with all supplier data - Second worksheet 'Template' is the PO template which uses Data Validate to choose supplier details from a drop down list. I want...