Showing posts with label Invoice. Show all posts
Showing posts with label Invoice. Show all posts

Thursday, October 5, 2023

Export multiple records to PDF one by one from Excel

 Sub ExportRangeToPDF()

    For a = 3 To 10

        Sheet1.Range("D4").Value = Sheet2.Cells(a, "A")

        Sheet1.ExportAsFixedFormat Type:=xlTypePDF, Filename:="C:\Users\Naeem\OneDrive\Desktop\PrintingPDF\" & Sheet1.Range("D4").Value & ".pdf", Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False

    Next

End Sub

Tuesday, June 1, 2021

Bkash Merchant QR Code on WHMCS invoice

At the line number 104 of invoicepdf.tpl

 # QR Payment Code

$qrFilename = 'QR_INVOICE.png';

if (file_exists(ROOTDIR . '/assets/img/QR_INVOICE.png')) {

    $qrFilename = 'QR_INVOICE.png';

} elseif (file_exists(ROOTDIR . '/assets/img/logo.jpg')) {

    $qrFilename = 'logo.jpg';

}

$pdf->Image(ROOTDIR . '/assets/img/' . $qrFilename, 120, 110, 75);


$pdf->Ln(10);

Headers Security Advanced & HSTS WP setup manually

Open the file for editing and paste the following snippet inside the  .htaccess file: <IfModule mod_headers.c> Header always set S...