• Home
 · 
• Miscellaneous
 · 
• Code for making a report using microsoft excel

Code for making a report using microsoft excel

Code for making a report using microsoft excel

API Declarations




dim rpt as new excel.application



Rate Code for making a report using microsoft excel

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

    
    with rpt
        .workboof.open "Filename of the excel fil
        .cells(1,"A") = "asd"
        .cells(1,"B") = "aaaa"
        .cells(1,"C") ="aaa"
        .displayalert = false
        .visible = false
        .worksheet.printouts
        .workbooks.close
     end with
end sub