WFTPConsole and VBA not working together
Posted: Wed Mar 05, 2014 11:24 pm
Hello;
I'm on a Win7 Pro machine and have VBA code under Outlook 2003 to allow certain people in the company to e-mail a particular e-mail address to create new users, etc. When Outlook receives an e-mail with a specific word in the subject line, the VBA code writes data to a text file then fires a shell command to invoke the WFTPConsole.exe with a lua script that creates a new directory on our server, creates a new user, maps the directory and sends an e-mail confirming all is well to the requester.
If I use a cmd window and invoke the WFTPConsole with the lua script, it works perfectly.
If I run the vba code, it appears to work perfectly as it returns the handle of the WFTPConsole instance I just called however, the WFTPConsole doesn't run the lua script.
Both sides seem to be working when initiated on their own but they will not play nice together! I've tested the vba shell call to invoke notepad, calc and a couple other programs and it works perfectly. When I open a cmd window and invoke WFTPConsole with the lua script, it works perfectly. When I put them together, nada.
I'm really at a loss to explain this. Any help would be appreciated.
I'm on a Win7 Pro machine and have VBA code under Outlook 2003 to allow certain people in the company to e-mail a particular e-mail address to create new users, etc. When Outlook receives an e-mail with a specific word in the subject line, the VBA code writes data to a text file then fires a shell command to invoke the WFTPConsole.exe with a lua script that creates a new directory on our server, creates a new user, maps the directory and sends an e-mail confirming all is well to the requester.
If I use a cmd window and invoke the WFTPConsole with the lua script, it works perfectly.
If I run the vba code, it appears to work perfectly as it returns the handle of the WFTPConsole instance I just called however, the WFTPConsole doesn't run the lua script.
Both sides seem to be working when initiated on their own but they will not play nice together! I've tested the vba shell call to invoke notepad, calc and a couple other programs and it works perfectly. When I open a cmd window and invoke WFTPConsole with the lua script, it works perfectly. When I put them together, nada.
I'm really at a loss to explain this. Any help would be appreciated.