You could try the Sendkeys command in VB to pre answer the message box
SendKeys {ENTER}, False ' Answer for box before it appears
'if the Wait parameter was true the Answer would go into the sheet cell
'but with it false the Dialog box appears before the Answer is sent
> -----Original Message-----
> From: Jan R Andersson [SMTP:[EMAIL PROTECTED]]
> Sent: 21 February 2001 15:22
> To: [EMAIL PROTECTED]
> Subject: Connecting via MyODBC always brings up the "TDX mysql Driver
> Connect" dialog
>
> Hello,
>
> I've recently successfully downloaded and installed both MySQL and MyODBC
> on
> my Win2000 "box". Everything thing works great, except that for every
> connection via MyODBC I make, the ODBC-setup dialog "TDX mysql Driver
> Connect" pops up and I have to hit its OK button to close it. There is a
> checkbox named "Don't prompt on connect" which I thought was ment to have
> it
> stop poping up that dialog, but it has no effect. Any idea what to do?
>
> Thanks
>
> /Jan R Andersson
> /Kalix
> /Sweden
>
>
> WEB:
> www.jra.nu
> www.mobilesweden.org
>
> WAP:
> jra.nu/main.wml
> wap.mobilesweden.org
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
