Accessing Excel With ADO

[PointOfLight]

Okay, I know it's been a while, and this isn't even a great example, but here's something quick to show how to read from and (almost) write to an Excel spreadsheet using ADO.* The odd thing is that if the spreadsheet is open when I call the write routine, I see the cells being changed, but the changes are never saved.* Maybe someone else can figure out that final step.* Anyway, hope this is useful to someone.

[br]1203548558_49_FT0_excelado.zip

[jdixon]

Eric I have tried your program and will not run. 1) I searched my computer for the ADO file it is lookiing for, not there. 2) I guest the next step for me is to find the and install the ado files and try again. I thought they would be with PPL when it installed

[PointOfLight]

Actually, the ADO files come from Microsoft. It's possible that they might get installed with their respective programs (Access, Excel, etc.), but I don't know that for a certainty. To get the ADO install, go to http://msdn.microsoft.com and search for MDAC Install. Here's a direct link: <a href=&quot;http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&amp;DisplayLang=en&quot;>MDAC Install</a>, but of course the way they reorganize it could be gone by tomorrow.