And you will need to open it, or use ADO which is much less flexible and
much more limited with regards to changing a workbook.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"NickHK" wrote in message
...
So where is this workbook saved ?
On the network somewhere ?

You need to look at some of the Google examples of "Excel Automation" for
the basic code anyway.

NickHK

"yosilb" wrote in message
...
hi
I have a program on my computer that is using an Excel workbook.
I'm using VB6 and need to modify this excel workbook.
How can I make changes to this excel workbook without saving it first to
the
hard drive and afterward reopen it.

thanks