<div>
Thank you for this code.<br />
<br />
Could you please let me know where should I report the server name and the database name?<br />
<br />
Thank you again for your help.
</div>


Thank you for this code.

Could you please let me know where should I report the server name and the database name?

Thank you again for your help.

<div>
Perfect it works, I will retest for other queries tomorrow.
</div>


Perfect it works, I will retest for other queries tomorrow.

<div>
Sorry for the delay. Tested and it works!
</div>


Sorry for the delay. Tested and it works!

<div>
<div class="content wysiwyg-content">
Hello experts,<br />
<br />
Please find bellow and attached a xlsm file that Use to update data in one of the database.<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2015/08_w35/931536/2015-08-25-16-22-21-Microsoft-Excel-.png" target="_blank" title="2015-08-25-16-22-21-Microsoft-Excel-.png (16 KB)"><img alt="2015-08-25-16-22-21-Microsoft-Excel-.png" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2015/08_w35/800_931536/2015-08-25-16-22-21-Microsoft-Excel-.png" /></a><br />
I was wondering if there is a way to create a Sub in VBA in which I define the user information (username, password) server and database and directly run the various queries defined in Column B and if possible display the sql logs in msgbox or in an external file.<br />
<br />
Thank you again for your help.
</div>
</div>


2015-08-25-16-22-21-Microsoft-Excel-.png

Hello experts,

Please find bellow and attached a xlsm file that Use to update data in one of the database.



I was wondering if there is a way to create a Sub in VBA in which I define the user information (username, password) server and database and directly run the various queries defined in Column B and if possible display the sql logs in msgbox or in an external file.

Thank you again for your help.

VBA: execute sql queries

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.