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