How to link Excel/VBA to MySQL?

[Kelvin Stott]

Hello,

I have created the following "GetResult" VBA macro within Excel to apply a custom formula to the value of a given source cell within a hidden sheet, and display the result in a target cell on a visible target sheet:

Sub GetResult(SourceCell as String)

Sheets("TargetSheet").Range("TargetCell").Value = MyFormula(Sheets("HiddenSheet").Range(SourceCell).Value)

End Sub

How can I open the Excel file and call this macro from MySQL, and export the result to a MySQL database?

Thanks for any help.

Kelvin

 

[Kelvin Stott]

PS. Does Excel even need to be open, or does it nees to be kept open as long as MySQL needs it?