hai

i written vbs script to export the values from wincc to XL file but its not not executing in windows 10. but the same script is working in wimdows7. please help any one to execute the script in windows 10

objExcelApp.ActiveWorkbook.SaveAs "D:\Reports\PLANT PERFORMANCE REPORTS\Monthly\book1 .xlsx"

Hi shiyam,

Check the Access rights from operation system.

How do you run your project. Is the project running as service ?

Do you use any virus scan ?

Best regards

schufri

hi schufri

        i given the access rights and my project running as service only

and am using kaspersky antivirus

Hi shiyam

1. Deactivate the kaspersky antivirus and check it your script works

2. Start your project as normal (not as service) and check if it works.

Best regards

schufri

Hi schufri

1. Deactivate the kaspersky antivirus and check it your script works

2. Start your project as normal (not as service) and check if it works

these also tried but its not working. other than these anything is there???

Hello shiyam,

maybe you try with kind of an error handler. Add the following line after a open and save command lines (for the latter change text to "save"):

if err.number<>0 then
  msgbox "error open: " & err.number & ", " & err.description
else
  msgbox "open ok"
end if

Regards,

Frink

hello Prof.Frink

   Am getting error code -  424 object required.

 Hello shiyam,

shiyam

hello Prof.Frink

   Am getting error code -  424 object required.

is Excel installed on your Windows 10?

Regards,

Frink

hello prof

  XL is already installed on my windows 10. if am running the script through microsoft windows based script, its working. when am trying with wincc am getting this error code.....