Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i write on the background of a spreadsheet John McCrudden Excel Discussion (Misc queries) 3 June 3rd 10 01:21 PM
Write record from Form to new row in spreadsheet Tony Excel Discussion (Misc queries) 0 March 18th 10 07:35 PM
Write record from Form to new row in spreadsheet Tony Excel Discussion (Misc queries) 1 March 18th 10 02:43 PM
How do I write Sample across a spreadsheet? Newbie Excel Discussion (Misc queries) 6 April 14th 09 11:08 PM
Write to a New Spreadsheet Daniell Excel Discussion (Misc queries) 3 October 5th 05 10:21 PM


All times are GMT +1. The time now is 08:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"