Open excel and workbook with VB

[mts176]

Attempting to Open Excel and an Excel workbook (one right after the other) using Visual Basic through the IFIX HMI package.

 

[Ruairi]

I'm haven't used IFIX, however this is how you would do it in VB. Any platform that supports VBA should be the same.

Dim ObjXL As Excel.Application

'create an instance of excel 
Set ObjXL = CreateObject("excel.application") 

'open a workbook 
ObjXL.Workbooks.Open FileName:="C:\SomeWorkBook.xls" 

ObjXL.Workbooks.Close 'Close the file
                          
ObjXL.Quit 'Close the instance of excel in memory

Ruairi

Could your manufacturing facility benefit from real time process monitoring? Would you like your employees to be able to see up to the minute goal and actual production?
For innovative, low cost solutions check out my website.

http://www.plccontroltechnologies.com