DDE to Excel Commands

[hankm3]

Hello,

Does anyone know of a Book(s) that Shows how to Write VB Code for Accessing Excel Spreadsheets ??

Thank

 

[bjd4jc]

I don't know of any books but I have learned a little from using the Object Browser (F2). I don't think you need to use DDE because Microsoft provides the object libraries to access them directly. In your references, just add Microsoft Excel x.x to your project. You will then see the Excel object in the list and you'll be able to see all of the classes, etc. that come with it.

If you need help with something more specific, I can try!

Brian

 

[vaxman9]

WROX has a great book I picked up in a bundle, One for Outlook, one for Word and one for Excel. It is titled "Excel 2000 VBA", author John Green. I use them for accessing via Visual Foxpro as well as VB. I find them very helpful. Check them out at

http://www.wrox.com

HTH
msc