Axolot Data

Just to be clear, the problem is writing a new spreadsheet in XLSReadWriteII, creating a public VBA function in a VBA module and writing a formula which uses that function. I don't care about being able to call that function and get a result from within XLSReadWriteII, but rather I just want the for...

To see what I mean, place a new XLSReadWriteII4 component on your form and add a button with the following code: procedure TForm1.Button1Click(Sender: TObject); const FILE_NAME: string = 'C:\Test.xls'; var vba: TVBAModuleSource; begin if FileExists(FILE_NAME) then DeleteFile(FILE_NAME); xls.Filename...

I wish to output a spreadsheet (from scratch) that includes VBA code to do something when the user changes a cell in the spreadsheet. I've included a very basic example console app below but I cannot get it working. Please help. program VBATest; {$APPTYPE CONSOLE} uses SysUtils, XLSReadWriteII2, XLS...