Bah, bah!

After having searched all settings in Windows, Office, Excel, and
Visual Basic (and all of them at least three times each) I finally had
the bright idea to check what the firewall and anti-virus programs are
capable of at the "faulty" computer.

It was the virus scanner that blocked my excel macro.

So, just for the records (in case someone else would search for help on
this problem in the future):

I wanted to start another application from within an excel/vba macro.
The "Shell" command did not work. Using "ShellExecute" from shell32.dll
did not work. Actually it was not possible to call any external finction
in any dll. All this worked perfectly well on an older computer (with
older software) but not on a newer computer (with newer software).

Recent versions of Kaspersky's anti-virus scanner (and most likely
other virus scanners as well?) uses real-time vba macros monitoring. It
can block a command or abort a macro that tries to use shell commands,
windows api calls, delete files and directories, and so on, and so on.


--
pipo
------------------------------------------------------------------------
pipo's Profile: http://www.excelforum.com/member.php...o&userid=23750
View this thread: http://www.excelforum.com/showthread...hreadid=374121