Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default shell command and code execution

Hi all,

looking at a difficult situation... the set up first, then my
impressions second:

macro usess shell command to run an executable, which makes a barcode
image, and leaves desired output in a predictable place. Or rather is
supposed to.

The macro then makes use of this output.

This macro works on my Win XP Pro system. (Office 2007)

This macro fails on my Windows 2000 Pro system. (Office 2003)

What appears to be happening is that in the latter case, the
executable is being prevented from writing the file. When I abort the
macro, suddenly the file appears.

No amount of waiting solves the problem. It is as if the output is
blocked from the executable while the vba code is running.

Can this be accounted for in the operating system? Or maybe the
different office versions?

I'm not sure where to turn at this point! Going a bit nuts :)

Thanks for your kind help,

SMS
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default shell command and code execution


I'm sorry, one correction... the offending (older) system is running
office 2002 components.

Thank you again for your help!
Reply
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 Command pls123 Excel Programming 1 May 26th 09 03:51 PM
Synchronous execution using shell function Chris Excel Programming 2 September 27th 07 10:49 AM
Shell Command JOHN Excel Programming 1 November 17th 04 10:39 AM
xp shell command using vba Sudhendra Excel Programming 2 February 16th 04 05:56 AM
SHELL command Robin Clay[_3_] Excel Programming 3 October 17th 03 02:50 PM


All times are GMT +1. The time now is 10:30 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"