Does XML have equivalent code for ADO?

[Guest]

Hello,

I understand that Excel 12/Office 2007 will be XML based...my terminology
may be technically incorrect here, but I think you know what I mean...so in
anticipation of this:

1) Does anyone know if Excel 12 will support ADO?

2) And more importantly, does XML use a different technology that will
replace ADO, and if so, what is it called; where can I find on-line example
code specifically geared toward ADO functionality?

3) If XML does not currently have an ADO replacement, will all my programs
containing ADO need to be changed to function through XML? If so, are there
examples of that?

4) I also have a lot of code using custom toolbars and shortcut menus. I
know the toolbars are being replaced by the "ribbon", but what about shortcut
menus?

I think you see my concerns, I have a lot of programs out there using ADO
and I want to embrace the change rather than try to resist it (which is
futile anyway). The best way I feel is to start planning and learning
now...can anyone help me out?

Thanks much in advance for your help - from a very concerned user.

 

[Guest]

Have a look at http://blogs.msdn.com/excel/default.aspx

and enter the Office 2007 beta program. Anyone who's actually used office
2007 is under NDA so cannot post information to public news groups.

When you say if excel 12 will support ADO, do you mean can you reference ADO
in exel vba? Yes you can.

Will you be able to use ADO to connect to an Excel spreadsheet - not sure.
If you save in an older format then yes.

Get with the beta program and then you can see for yourself.