Friday, 17 February 2017





Image result for visual studio logo





To open an excel file  in Visual studio use the following

Dim xlApp As New Excel.Application
        Dim xlBook As Excel.Workbook



        xlBook = xlApp.Workbooks.Open(path to the file)
        xlApp.Visible = True


Job done nice and simple  excel opens the file and closes the process when you close excel.

If you do GC.collect at the end it will do a garbage collection.

No comments:

Post a Comment

Multi Point USB Charger

  USB Plug Charger, 4-Port USB Fast Charger Plug with 33W Intelligent Quick Charge 3.0 Wall Charger, Multi USBPower Adapter UK Fast Charging...