LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Shell function sometimes works, sometimes doesn't

After some research, I've found that using the CreateProcess() API seems to
solve the problem. Unlike ShellExecute(), it doesn't care whether the
application is 32- or 16-bit. The documentation of it notes that Windows 95
and NT have to be treated differently; for my XP application, the latter was
the proper choice.

Thanks to you folks for your interest in my problem.

"tbone" wrote:

Would kicking off a batch file instead do the trick for you?

tbone

On Fri, 1 Jun 2007 16:18:01 -0700, HC Hamaker
wrote:

Upon further research, I believe the underlying cause is that the application
I'm trying to start is 16-bit program, and the Shell function will choke on
that (even though it usually doesn't). The documentation says the workaround
is to use a 32-bit application to call 16-bit application, and use the Shell
function to start the 32-bit application. Does anyone have a suggestion on
how to do that? For example, does anyone know how to call the StartRun... on
the task bar from VBA?


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Shell function Phil1982 Excel Programming 2 March 16th 06 12:39 AM
Shell function John Keturi Excel Programming 1 May 23rd 04 02:09 AM
Shell function II [email protected] Excel Programming 1 September 19th 03 05:55 PM
Shell function II Don Guillett[_4_] Excel Programming 1 September 19th 03 03:31 PM
Shell function David Excel Programming 0 September 19th 03 11:30 AM


All times are GMT +1. The time now is 04:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"