pdffile

Hello, I am having trouble with the below code, wondering if anyone can help me. I found the original solution on an Excel website; I changed it to what I require. I am trying to select a few worksheets, save as a PDF, then email it to myself. Funny thing is that this code has worked before...

Hi all I am using the below code to send a PDF to a group of managers. I want to include in the email body, a summary table from one of the tabs. I want paste as an IMAGE as this keeps all of the formatting and size ratio that makes it easy to read. The source tab is called DATA and the...

Morning All, I have two workbooks, "Material_Orders.xlsm" and "testMCosts.xls". within the "Material_Orders.xlsm" i have a script in place which will initially take a cell from that workbook and open the "testMCosts.xls" pasting the cell. It then hyperlinks the pasted cell and links this to a...

Hello All, I have a piece of VBscript which i was kindly helped to produce by Warship on this site. Everything works perfectly except an issue where the created PDF file which is hyperlinked and saved is being created from the wrong workbook. I have an "order sheet" workbook which contains...

I currently have an excel spreadsheet that I created recently, that would export the active sheet into PDF format and attached to an outlook email. However, ever since the company updated the Adobe Acrobat to Acrobat DC, the code would prompt error. Any assistance is greatly appreciated.

Please can someone assist. When I run the below macro in my Excel 2016 it works perfectly. I've emailed the sheet to another colleague who runs Excel 2007, and when I try run it on her PC it gives me a runtime error 5 Invalud Proceudre Call or Argument. When I debug it highlights this line...

I'm need of converting excel sheet as pdf and sending it as mail. I've got code in this forum, thanks to ZVI. Here's the code i used Sub AttachActiveSheetPDF() Dim IsCreated As Boolean Dim i As Long Dim PdfFile As String, Title As String Dim OutlApp As Object ' Not sure for what the...

Hi, I have found this code written by ZVI in this forum, which does more or less exactly what I need. However it would be great if somebody could help me to make a couple of small changes to the code: Would it be possible to amend it to prompt the user to type in the email address the want to...