Help for iFix 5.0 reporting

Dear all,
I am using licensed iFix 5.0 but not proficy historian. So to generate simple reports in MS Excel ( Date, Time, Tag name , TAg value). Do anybody has vb code for it. I am not much familier with vb.

PLC : Compact Logix L31
Communication protocol : DF1
HMI communication with PLC is through local OPC server.

Regards
Manasi

Create an excel file with file name 'Shift' in C:\ , & close the file.

After placing the script in a button in you should a refference "microsoft exel 11.0 object library".

then, goto run mode & click the button & chect your excle sheet.
script should run when excel sheet is opened.





Dim n As String
Dim tagname,
tagname = READVALUE("MASS_FLOW.F_CV", 2) ‘mass flow is tagname in a database.

On Error Resume Next

Set xlapp = CreateObject("excel.application")
Set xlwbk = xlapp.Workbooks.Open("C:\Shift.xls", xl, yes)
Set xlsht = xlwbk.Worksheets(1)
'Make excel object visible
xlapp.Parent.Visible = False


'Write the values in cells
xlsht.Cells(3, 1) = Format(Time, "HH:MM")
xlsht.Cells(2, 2) = tagname


'save xl workbook
xlwbk.Save


'close the excel workbook
xlwbk.Close
'close all object
Set xlsht = Nothing
Set xlwbk = Nothing

thanks

I wil try this and let you know...
thanks a lot.
where do you work? are you plc system integrator?

I'm working in Hyd.
note: Make sure that Excel sheet is closed when you run the script.