View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal[_3_] Robert Crandal[_3_] is offline
external usenet poster
 
Posts: 161
Default Using ADO to write into a spreadsheet

Does anyone have a simple example of VBA ADO code that can WRITE
data into cell A1 of a file named "data.xlsm"?

I have code that can READ the contents of A1 using the "select"
command. Now I'm need to figure out how to WRITE data into A1.
Do I need to use the "insert into" command? How?

Thanks.