I’m trying to use SQL with VBA to update an Excel worksheet. My macro currently updates 5 worksheets in the same file (Review, Used, Road, Inspec, and Misc). The macro runs SQL to update each worksheet based on some criteria.

I’m trying to use SQL with VBA to update an Excel worksheet. My macro currently updates 5 worksheets in the same file (Review, Used, Road, Inspec, and Misc). The macro runs SQL to update each worksheet based on some criteria.

I have Miscrosoft Visual Basic 2005 Express Edition book, can I use it to learn VBA Excel from scratch or do I need to buy a more updated book?

I have a listbox that pulls data from MySQL Workbech through a selection from the combobox. Each of the rows of the pulled data has an auto increment ID. I have a code that sends the values of a selected row into assigned text box.

I have a listbox that pulls data from MySQL Workbech through a selection from the combobox. Each of the rows of the pulled data has an auto increment ID. I have a code that sends the values of a selected row into assigned text box.