Excel 2000 Simple Shell Command Doesn't Work in Excel 2007

  • Thread starter Thread starter f252863
  • Start date Start date
F

f252863

This is a very simple issue.

Attached to a command button is the script: Shell "P:\exe\ktbatch.exe"

This ran fine in Windows 2000 with Office 2000. When I loaded the
spreadsheet into a PC with XP Professional and Office 2007 the command
no longer works. No error message is generated, nothing seems to
happen when I click.

When I look at the shortcut on my desktop it has:

Target: P:\exe\ktbatch.exe
Start In: P:\runtime

Now I understand this may have something to do with where the
executable is running however the shortcut parameters haven't changed,
the shell script worked before, why not now?

Thanks!
 
Bumping this as I have not received any feedback yet. Despite a long
search I could not find any source on the net for VBA shell commands,
all are in response to very specific issues. Why is this so hard?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The Differences in the Shell Command in Excel 2003 and 2007 1
How Do I Run An Executable from Excel? 1
shell command and code execution 1
Clear Clipboard command in Excel 2007 1
Macro command not running in excel 2007 2
2000 -> 2007: gotchas? 14
Shell command writes file to wrong directory 2
Running SPSS-Syntax using Excel VBA (Excel 2013) 0

Back
Top