Sorry if I'm confusing you! I'm confused which is why I need help. I'm trying
to link my shapes in my drawing to an existing SQL Server db. I want to be
able to click on my shapes and query the db for data which I will have in vba
code behind the scene. Any solutions?
yes it is definitely doable with vba. as far as a working example I haven't
seen one. For my code (which points at Access) I've used ADO calls. One of
the resources you might consider is the Script Center on
technet.microsoft.com because vbscript is very close to vba and they have
some examples on how to connect to sql.
Al
yes it is definitely doable with vba. as far as a working example I haven't
seen one. For my code (which points at Access) I've used ADO calls. One of
the resources you might consider is the Script Center on
technet.microsoft.com because vbscript is very close to vba and they have
some examples on how to connect to sql.
Al
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
