Hello
I do have a rather simple application to open an xls file, change some cell
values and to save this using a new name: All works well, except if there is
already another xls file openened, it will 'grab' that file and change those
cells.
How could I force to open the NEW xls file and not to use an already openened
worksheet.
I use to openen my 'template' file:
XLApp.Workbooks.Open(TemplateFile,
EmptyParam, EmptyParam, EmptyParam,
EmptyParam, EmptyParam, EmptyParam,
EmptyParam, EmptyParam, EmptyParam,
EmptyParam, EmptyParam, EmptyParam, 0);
but this only works oke when no other xls sheet is already opened.
I did find http://www.winsoft.sk/officfaq.htm but that does not provide any
information on this topic.
Any ideas as all google suggestions use the same command without mentioning
already opened sheets.?
regards
Andries
________________________________
Slide scanning / dia's scannen
vanaf / from
E0,08c
www.scancare.nl
________________________________
[Non-text portions of this message have been removed]