Advertisement
Guest User

Untitled

a guest
Aug 23rd, 2017
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. Dim ExcelApp As Object
  2. Set ExcelApp = getExcelApp()
  3.  
  4.  
  5.  
  6. Function getExcelApp() As Object
  7. Dim ExcelApp As Object
  8. Set ExcelApp = CreateObject("Excel.Application")
  9. ExcelApp.Visible = False
  10. ExcelApp.ScreenUpdating = False
  11. ExcelApp.DisplayAlerts = False
  12. ExcelApp.EnableEvents = False
  13.  
  14. getExcelApp = ExcelApp
  15. End Function
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement