Excel automation not working

[goofy78270]

I have a workbook that was created about two years ago, which creates some sql files, each with a corresponding bat file to execute the sql. Recently, the server which the workbook is located, was upgraded from 2003 to 2008 (Windows). Now, the files are still created, but the bat file is not ran.

I am using the following to execute the bat files:

Call Shell(objFile, vbHide)

If I step through the code for this execution of the bat file, everything works fine, but it fails to work if I simply let the program run automatically.

Any ideas?

NOTE: I thought about the automation running to fast and included a wait timer, but it still failed to run the bat files.

 

[Norie]

Pretty sure it's not an Excel problem.

Do you know if the upgrade could have changed anything so that this sort of thing doesn't work anymore?

Perhaps some sort of security/access/permission thing?

Perhaps something that was set in the old version has been 'reset' in the new version?