<t>Okay,I have work to do, but I really want to see if I can connect using ADO. I used a QueryTable with SQL parameters with ODBC. What do I use with ADO. Don't think there is a query table. Not sure how to get it to return the SQL select statement. This is what I had with ODBC:With ActiveSheet.Quer...

Thanks DCFC,Let me try to see if I can connect to my database using ADO. I have not tried this. It may take me some time to get this working as I have my regular work to do. I'll get back to you and let you know.

I am using ODBC to connect to the SQL. The ODBC connection uses MSQuery. I can see all the tables in the SQL database and I can pass the SQL coding in MSQuery. How do I bypass the MSQuery? Thanks,-Rob

<t>DCFC,I didn't know if I should start a new thread but ...Have you had any luck in using ODBC (SQL server) with multiple user. If I have a query that I setup, I can't get another user to refresh data. I have since tried to pass the DSN User ID and Password through VBA and had better luck, but want...

<r>No secrets. I susbscribe to a listserver for Excel development.The EXCEL-L list is hosted on a Windows NT(TM) machine running L-Soft>international's LISTSERV(R) software. For subscription/signoff info>and archives, see <URL url="http://peach.ease.lsoft.com/archives/excel-l.html">http://peach.ease...

Turn on you instant messaging and I might be able to direct you to an answer.

<t>There are a couple more Non-Fiction "fiction" booksRogue TraderDen of Thieves When Genius Failed: The Rise and Fall of Long-Term Capital Management Inventing Money : The Story of Long-Term Capital Management and the Legends Behind It But, if you have read so many books in this area, why not consi...

Quotealthough I learned chess from an early age I don't think its much use as a trader, except perhaps in training to 'think 7 moves ahead', but there are better games for doing that. What other games do you suggest?

I've mentioned it before but BBC Radio has some great stuff in Dance (Essential Mix everyweek) and ALT. I listen too Classical in the AM, Jazz afterlunch and sometimes BBC Radio in the afternoon. BBC Dance-Rob

Browse throught the Career forum or do a search. There have been a lot of posts with this info.-R

I would have thought MobPyscho would have been a Frank Zappa fan.

Which version are the users going to be using?Microsoft® Excel 2000 Bibleby John Walkenbach (always a good bet)I haven't read it but ... MBA's Guide to Microsoft Excel 2000 (also a 2002 version)by Stephen L. Nelson-Rob

<t>*****My problem is: why the Christian God, and not Allah, Jeovah, Dionisos, or Vichnou?*****All of the religions except Christianity rely on a person doing certain things such as being good or moral. Most religions try to balance the scales thinking that if you do more good than bad you will make...

<t>I got this from an Excel List I am subscribed to. Untested but should work-RobHere is a source to take a peek at:(You have to create a form to fit the "Application.Statusbar")..... The progress indicator is a normal UserForm with two label controls (one on top of the other) to give it contrasting...

<t>I just received the trial issue of Wilmott this week. Great stuff Paul! (expensive though) Here is my question. Ed was one of the original developers of a blackjack system. I have read about blackjack back in my college days. I know the math is simple. But, does anyone know of where you can get a...