Change a spreadsheet without opening it?

[Philosophaie]

Is it possible to change a cell a speadsheet without opening it and not just visible="False"? If so how do you do that?

 

[Fazza]

Yes

 

[Philosophaie]

How do you go about changing a cell in an unopened spreadsheet?

 

[Fazza]

I should have addressed that earlier, sorry. It is possible using ADO and similar approaches. In fact, IIRC, the files must be closed. For example, set up an ADO object and run SQL to UPDATE (amend) data or add new data with SELECT/INSERT INTO or APPEND. I'll post a link in a minute.

 

[Fazza]

A link, http://www.xtremevbtalk.com/showthread.php?t=217783

Google will find many more, including in MS Knowledge Base.

Cheers

 

[Philosophaie]

Is there another simplier way rather than to envolk ADO.net?

 

[Fazza]

The method uses ADO.

I don't know about ADO.net.

DAO I think would be about equally simple (to ADO). I am unfamiliar with simpler methods.