Hi,

I have a vbscript that would format a text file to excel. This script would run fine when am running outside however it only running till the point where the log file is created but the excel conversion won't happen and the script abruptly stops or doesn't respond.

Can you help me with this issue.

Thank you.

Am attaching script for reference. Please change the locations in the config files.

If it hangs I guess it is trying to display some error. Are you using the Execute script Task?

---

Yes, I was working on it yesterday and there was a message it was trying to display. See attached.

Later, I realized the job is running in the background mode and I've changed that to foreground.

and you know what, the job ran successfully!

Now here comes the sad part. our client is using v 2.5.11 and I was not able to see a foreground way of running the job.

Could you help me out here.

Thanks a lot.

Yes, I was working on it yesterday and there was a message it was trying to display. See attached.

Later, I realized the job is running in the background mode and I've changed that to foreground.

and you know what, the job ran successfully!

Now here comes the sad part. our client is using v 2.5.11 and I was not able to see a foreground way of running the job.

Could you help me out here.

Thanks a lot.

2.5.11? Really? No, you have to change the script so it does not popup a message or whatever it is showing.

---

😕

Am looking into such alternatives now. The current script opens an excel workbook and format data. I wonder if I open the excel workbook silently however the research is on!

Do you have any suggestions for me?

There really aren't many alternatives. You need to make you script silent as no new operative system likes running message boxes and visible applications in the background desktop as it is a security risk - hence the popup from the system.

---