make changes to excel workbook

[NickHK]

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]

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

 

[Bob Phillips]

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)