Shell function some issues ??

koba Tirth

Some issuse run shell function

shell function thoughtput is more

so how can fix it?

Thanks.

string sqlStr ="\\d:koba -ifile=\\d:koba\test.xml -header=0 -ofile=\\d:koba Query1="select * from tabelname where fieldname= 'value' and field between 'value1' and 'value2' ""

int ProcId = Shell(sqlStr, AppWinStyle.MaximizedFocus, True)

Dim word As New Microsoft.Office.Interop.Word.ApplicationClass()

word.Visible = True

word.Documents.Open(@"\\d:koba\test." & ".xml").Activate()

word.Run("Catalogue_Replace_Hp")

word.Documents.Save()

word.Quit()

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

koba Tirth9y ago
stoped below line can't go ahead
int ProcId = Shell(sqlStr, AppWinStyle.MaximizedFocus, True)

i can remove "." int ProcId = Shell(sqlStr, AppWinStyle.MaximizedFocus, True)

but same issuse ..!!
Nilesh Shah9y ago
I see a mistake in this line, there are going to be 2 dots, one after test, one before xml,
so it will become like test..xml
word.Documents.Open(@"\\d:koba\test." & ".xml").Activate()
Remove one dot then try again, may be it works then
word.Documents.Open(@"\\d:koba\test" & ".xml").Activate()
koba Tirth9y ago
shell function give error timeout and stoped the application...
Nilesh Shah9y ago
Please describe clearly - what is the problem/error faced by you and what do you want us to answer?