make changes to excel workbook
 

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

make changes to excel workbook
 

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

make changes to excel workbook
 

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