using ShellExecute in Windows 7

**Jack10063** · 10-10-2010, 05:37 AM

Hi,

I have succesfully used ShellExecute to start a program in Windows XP:

Please Login or Register  to view this content.

and a following VBA code:

Please Login or Register  to view this content.

Unfortunately sub doesn't work anymore in 64 bit Windows 7. How should I modify the function declaration/code to get it working..??

Thanks for any help.

Br,
Jack

**snb** · 10-10-2010, 05:59 AM

Wouldn't this be a clue ?

"shell32.dll"

**romperstomper** · 10-10-2010, 04:02 PM

What error are you actually getting? There's nothing inherently wrong with the syntax (unless you are using 64bit Office)

**Jack10063** · 10-11-2010, 03:51 AM

Hi,

Thanks for your answers. I don't have a 64 bit office. It certainly seems that "shell32.dll" is wrong but i dont know how to modify the declaration. Which I don't understand is that my macro starts the program "Scheduler.cmd" but the program itself doesn't work when starting it with my code. If I just go and double-click "scheduler.cmd" it runs normally.

Unfortunately i don't understand why is it working when I double-click the software but fails when using the macro. Any ideas on that..?

Br,
Jack