WindowStyle not working in shell command

K

KLC

Help!!

I am trying to open Word 2000 and maximize it
(vbMaximizedFocus) but it keeps giving me a compiler error
expecting =. I have tried all combinations of constants
or values and no luck. Is there a patch out there or
something? Looks like I am running VB6 for excel 2000.
Any help would be appreciated.

KLC
 
C

Chip Pearson

KLC,

What code are you using? The following code works fine for me. Be sure to
change the folder name to the appropriate folder.


Shell "C:\Program Files\Microsoft Office2000\Office\WinWord.exe",
vbMaximizedFocus



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 

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

Shell command produces a "Run-time error '5': Invalid procedure call or argumen 0
Using START, CALL etc commands in Shell gives me error "Run TimeError 53; File Not Found". 4
Word doc keeps changing to ALL CAPS 0
List all tables, including document structure 0
Compile Error: Expected= 4
Shell command ignores variable 2
Excel 2000 Simple Shell Command Doesn't Work in Excel 2007 1
shell command and code execution 1

Top