Need help with retrieving Excel WorkSheet List

[Tim_C.]

Ok, that works like a champ now, thanks...

So how come in the activeX example I pieced/copied together does no actually open excel?  Or is it and it is just not showing on the screen?

Thanks

Tim C.

[smercurio_fc]

You're confusing opening a reference with actually opening the window. Opening a reference creates the object in memory. The example that you copied it from probably called the property to make the application window visible, and set this value to False. Mike has already pointed this out.

[Tim_C.]

Can you clarify what the source control is suppose to provide is Mike's read file example?

Thanks

Tim C.

[smercurio_fc]

The "source" is the TSQL command. In this case "SELECT * FROM demo" means return all rows from the table (sheet) called "demo". Unfortunately, Mike called the workbook file and the sheet name the same, so that's a little confusing.


Message Edited by smercurio_fc on 07-08-2008 03:08 PM

[Tim_C.]

Added an example that uses ActiveX or ADO so folks can have access to them .....