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);

Reset Ubuntu with factory reset & and reinstall

  Try configuring unconfigured packages: sudo dpkg --configure -a Update the contents of the repositories sudo apt-get update Try to fix mis...