fork download
  1. Imports System
  2. Sub RDB_Workbook_To_PDF_And_Create_Mail()
  3. Dim FileName As String
  4.  
  5.  
  6. FileName = RDB_Create_PDF(Source:=ActiveWorkbook, _
  7. FixedFilePathName:="", _
  8. OverwriteIfFileExist:=True, _
  9. OpenPDFAfterPublish:=False)
  10.  
  11.  
  12.  
  13. If FileName <> "" Then
  14. RDB_Mail_PDF_Outlook FileNamePDF:=FileName, _
  15. StrTo:="", _
  16. StrCC:="", _
  17. StrBCC:="", _
  18. StrSubject:="This is the Master slip and salary slip ", _
  19. Signature:=True, _
  20. send:=False, _
  21. StrBody:="<H3><B>Dear staff</B></H3><br>" & _
  22. "<body>Attached herewith is your February, 2015 salary slip for your perusal." & _
  23. "<br><br>" & "Regards," & _
  24. "<p></P>" & "Admin&Finance Division" & _
  25. "<p></P>" & "EcoPrasinos Engineering SDN. BHD.</body>"
  26. Else
  27. MsgBox " ERROR! Not possible to create the PDF, possible reasons:" & vbNewLine & _
  28. "Microsoft Add-in is not installed" & vbNewLine & _
  29. "You Canceled the GetSaveAsFilename dialog" & vbNewLine & _
  30. "The path to Save the file in arg 2 is not correct" & vbNewLine & _
  31. "You didn't want to overwrite the existing PDF if it exist"
  32. End If
  33. End Sub
Compilation error #stdin compilation error #stdout 0s 0KB
stdin
Standard input is empty
compilation info
Visual Basic.Net Compiler version 0.0.0.5943 (Mono 3.8 - tarball)
Copyright (C) 2004-2010 Rolf Bjarne Kvinge. All rights reserved.

/home/zuV0YG/prog.vb (2,4) : error VBNC30203: Identifier expected.
/home/zuV0YG/prog.vb (3,8) : error VBNC30203: Identifier expected.
/home/zuV0YG/prog.vb (6,13) : error VBNC30203: Identifier expected.
/home/zuV0YG/prog.vb (13,7) : error VBNC30203: Identifier expected.
/home/zuV0YG/prog.vb (14,29) : error VBNC30203: Identifier expected.
/home/zuV0YG/prog.vb (26,9) : error VBNC30203: Identifier expected.
/home/zuV0YG/prog.vb (27,15) : error VBNC30203: Identifier expected.
/home/zuV0YG/prog.vb (32,11) : error VBNC30203: Identifier expected.
/home/zuV0YG/prog.vb (33,8) : error VBNC30203: Identifier expected.
There were 9 errors and 0 warnings.
Compilation took 00:00:00.6095010
stdout
Standard output is empty