Shell() Problem

[SimonFinn]

Hi Guys

Im using shell() to open a word file, i currently have

Call Shell("C:\Program Files\Microsoft Office\Office10\WINWORD.EXE""C:\MailMerge\MailMerge2.doc", 1)

And it says file not found (i have checked both paths and they are both correct.
ive also tried:
Call Shell("WINWORD.EXE""C:\MailMerge\MailMerge2.doc", 1)

What am i doing wrong?

Thanks Si

 

[jpraman]

hi

try this coding. if u are going to open a word file u can just use the shell function as follows

call func
sub func()
shell ("C:\program files\microsoft office\word1.doc",1)
end sub

good luck

 

[SimonFinn]

Hi

when i input

Shell ("C:\MailMerge\MailMerge2.doc", 1)

i get the error "Expected ="

if i use call, in front, when i run the program i get:

Runtime error '5', invalid call or arguement

Thanks Si

 

[SimonFinn]

Got it

Call Shell("C:\Program Files\Microsoft Office\Office10\WINWORD.EXE C:\MailMerge\MailMerge2.doc", 1)

thanks jpraman

 

[PaulTEG]

try

rc = shell("winword c:\mailmerge\mailmerge2.doc")