Articles
Every article Ever Garden has grown, newest first. Narrow them down by topic, tag or a search.
Excel VBA Template File (Improved mk2)
I created an Excel VBA template file. Built mainly around class modules, it implements CRUD operations against a database (Oracle) linked to an Excel table.
#excel-vba#oracleVBA | Retrieving Data from Another Excel File
An Excel macro that retrieves data recorded in another Excel file
#excel-vbaVBA | DB Operations – Part 4: Running MERGE from Excel
Excel macro Part 4: [Running MERGE from Excel]
#excel-vba#oracle#sqlVBA | DB Operations - Part 3: Running INSERT, UPDATE, DELETE from Excel
Excel macro Part 3: [Running INSERT, UPDATE, DELETE from Excel]
#excel-vba#oracle#sqlVBA | DB Operations - Part 2: Storing SELECT Results in Excel
Excel macro Part 2: [Storing SELECT results in Excel]
#excel-vba#oracle#sqlVBA | DB Operations - Part 1: Handling the Config Sheet's Settings in VBA
Excel macro Part 1: [Handling the Config sheet's settings in VBA]
#excel-vba#oracleVBA | Splitting Each Sheet of an Excel File into Separate Files
How to output each sheet of an Excel workbook as its own file, using Excel VBA
#excel-vba