[?]: vbs under WinCC 6.0 and Excel

ProTool, WinCC flexible, WinCC, PP/OP/TP/TD/MP
PLC_ITA
Posts: 265
Joined: Sat May 27, 2006 6:46 am
Location: Europe

[?]: vbs under WinCC 6.0 and Excel

Post by PLC_ITA »

Hello , i need a help about a vbscript and excel.
Few years ago i wrote a script to save data in XLS format, and all ok. Into the system there are WIN XP SP2 - WinCC 6.0 SP4 and EXCEL 97.

Now i have only update excel to 2003 and my script does not work and i don't understand why.
If i delete excel 2003 and restore 97 , all ok

The script is locked when create object :

Code: Select all

Dim FILE_EXCEL
Set FILE_EXCEL = CreateObject("Excel.Application")      <---- the script is locked during this instruction
FILE_EXCEL.Workbooks.Open file_name
..
..
..
Thi is the same script like into the help of WCC !!!

i'm not a big vbs programmer and i need a help from you !!! (sos)

thank you in advance