
Closing an excel object without closing all open excel files
Hi Sasa,
I think all excel files are closed when you close the
excel application.
Can you post your code on how you are closing the workbook?
Use wrkbook.Close command to close the workbook, where
wrkbook is an instance variable to the workbook you are
working on.
HTH
-Srini
Quote:
>-----Original Message-----
>Currently I am running VB script in excel. I open an
excel file, save it's
Quote:
>sheets as .csv then close the file.
>The problem is that if an excel file is already open when
this script is
>run, then when the script finishes, all excel files are
closed.
>I want to (if other excel files are open) create an excel
object, then
>successfully close it and only it, not all the other
excel files that were
Quote:
>open before the script was run.
>Thanks in advance
> Sasa Radakovic
>.