strfname

Hi if some one could please help me add a signature or image to this code i would be very grateful. Sub twosaves() Sheets("Quote").Select ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _ filename:="C:\Users\James\Documents\Excel Test Folder\Quotes PDFs Test\" & _...

Hi everyone, i have created an email quote template, however i would like to add my business signature, or a picture of the signature to the end of the body of text. If anyone has any suggestions please assist. Thank you . Sub Send_RangeI() Dim strPath As String, strFName As String...

Hi, I have this VBA that works great. It convert a specific range in active worksheet and attaches as PDF to email. Now I'm trying to also add the same range to the body of the email. Any advise? Sub SendPDF() ' Create PDF and send as attachment. Dim strPath As String, strFName As...

Hi, I am using the code below to print documents, I want to be able to force it to print to a specific printer. Several people use this and we are all set up to different default printers so I want it to print out at a specific printer without having the change our printers. Can this be done and...

Hi, I am running a VBA in excel, I have a list of documents that the VBA finds and prints without me having to open and print each document individually. All of the documents are in .XLS format. When I run the macro, the sheet prints but it is too small, more like A5 size rather than A4. If I...

Hi, I am using the script below to print files in a specific location from excel, but the sheets are not printing in A4, they're about half the size they should be, can anyone please spot why? if I print the documents manually they are fine, but priting from the VBA is causing an issue. Thank...

Hi! I have here macro vb code that boss gave me to operate but every time I click File export button on my excel file I have error that says "Compile error: Missing end bracket". please help me with this..Thank you in advance Error was found in first line -->Public Sub NIGˆË—Šƒf�[ƒ^�ì�¬()...

Hi team, Previously I used Dim signature As String / ObjMail.HTMLBody = strHTMLBody & ObjMail.Body which used to get the default signature when the macro was executed, however since implementing a PDF attachment, it no longer works. I also tried to create a path to the signature folders but...

Hi all, I have a macro that generates a PDF of the active worksheet and attaches it to a new email however it currently displays as the workbook name as per the code but I get an error if I try to change it to a range. Could someone kindly assist? Sub Adcorp_PDF() ' ' Adcorp_PDF Macro ' '...