ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using ADO to write into a spreadsheet (https://www.excelbanter.com/excel-programming/450363-using-ado-write-into-spreadsheet.html)

Robert Crandal[_3_]

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.





All times are GMT +1. The time now is 02:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com