views:

26

answers:

0

Is there any way to insert an existing macro into a existing excel file without using the excel library ? I need this to set the excel to print whole work book .I cannot use excel library because it will be done online in the server where installation of excel is not possible. I can however use the c#.net coding . I am using NPOI to generate the excel.

the macro is given below

Private Sub Workbook_BeforePrint(Cancel As Boolean)
If printed = False Then
Cancel = True
printed = True
ActiveWorkbook.PrintOut
End If
End Sub