i came acros this code on the board:
on error resume next
set app = createobject("excel.application")
set wb = app.workbooks.open (replace(wscript.scriptfullname,wscript.scriptname,"hello.xls"))
if wb is nothing then app.quit
it opens an excelfile while keepig excel completely hidden. pretty cool.
but i have about 8 interactive files and once one of them tries to open the prog quits.
is there a way to modify this script to account for the possibility of other files that might come into play?
TIA!
tx
on error resume next
set app = createobject("excel.application")
set wb = app.workbooks.open (replace(wscript.scriptfullname,wscript.scriptname,"hello.xls"))
if wb is nothing then app.quit
it opens an excelfile while keepig excel completely hidden. pretty cool.
but i have about 8 interactive files and once one of them tries to open the prog quits.
is there a way to modify this script to account for the possibility of other files that might come into play?
TIA!
tx