EXCEL MYSQL ADD-IN, VB MACRO

Say,

I'm trying to write VB code to control this add- in ... any ideas?

http://www.mysql.com/why-mysql/windows/excel/edit/

Can I execute a macro to make the MySQL for Excel icon visible.
shaunwinginAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
RobConnect With a Mentor Owner (Aidellio)Commented:
I got it to show like this by just sending the keystrokes:

Sub Macro1()
'
' send Alt A Y 2
'
Application.SendKeys "%ay2"

'
End Sub

Open in new window

0
 
Simon BallCommented:
have you tried recording a macro of you clikcing to make it visible?  if the macro turns up emtpy, its probably going to take an API call or something heavy duty to do this with VB....

if the macro truns up some code.. then you can use that codein your VBA
0
 
shaunwinginAuthor Commented:
I've tried - something was recorded but I couldn't get it to actually display the icon. Pls can you install the add-on and see what can do...
0
 
shaunwinginAuthor Commented:
Tx. Are you by any change able to interact with the add-in in any way - eg expand the selection or run a query?
0
 
RobOwner (Aidellio)Commented:
Unfortunately not... I think that's the best you're going to get at this stage.
0
All Courses

From novice to tech pro — start learning today.