04-01-2015 05:03 AM
In my business we have recently upgraded from Windows XP to Windows 7 and it has caused me a problem with my scheduled jobs. I used to run a number of scheduled tasks which would DDE output to excel, however I can no longer get the session to write to excel.
If I manually run the process it will run and write fine, however when I run it as a scheduled task on windows scheduler it will run the program, open excel and then not write anything to excel or close the excel session.
Has anybody had any similar experiences or any advice? I've googled this quite a bit but haven't found any solutions so far, any help would be greatly appreciated. Code is attached, if you need any more info then please let me know