I don't understand ADO in EXCEL

truhi

New Member
Joined
Dec 21, 2005
Messages
3
Hello,

Although I have considerable experience on Macro in Excel, I could not have a chance to gain much experience on ADO in Excel.

I often need to work closed Excel Workbooks, so that I am very motivated to learn about ADO thus I wonder if you could supply me resource about the ADO in Excel in order to develop myself further.

Help me please,

Good Luck.
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,047
Office Version
  1. 365
Platform
  1. Windows
Why not try a search on th board for either ADO or working with closed workbooks?
 

Mark O'Brien

MrExcel MVP
Joined
Feb 15, 2002
Messages
3,530
Welcome to the Board!

Norie's correct. There are some really good people and posts on this board that may answer questions on ADO for you.

However, a useful link with multiple examples for ADO would be Ole Erlandson's website:

http://www.erlandsendata.no/english/

I personally am a complete idiot with ADO, but I have seen Ole's website suggested many times with reference to his ADO examples.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,056
Messages
5,569,953
Members
412,299
Latest member
agentless
Top