CODEWITHSUNDEEP
mysqlexcelvbadatabase-connection
Prem_Kumar_S
Prem_Kumar_S

Reputation: 87

updating excel file data using vba from mysql

Is it possible to have an excel sheet that gets updated from a mysql server using a specific query when ever it gets opened using VBA?

I am new to VBA and is it possible to monitor the data changes on the excel sheet while updating the sheet??

Thanks

Upvotes: 0

Views: 809

Answers (1)

John Bustos
John Bustos

Reputation: 19544

If you use the Data > Get External Data toolbar to set up the MySQL data pull, you can then set the workbook to refresh upon opening - Here's a link that shows the very basics.

As for tracking / moitoring changes, you'd have to be more detailed about how you'd like that to happen... As a general rule, it's not very easy to do.

Hope this helps!!

Upvotes: 2

Related Questions