Page 1 of 1

Crash on trying to read a macro text

Posted: Thu Feb 01, 2007 7:21 pm
by Guest
Hello,
Somewhat frustrated: The following code worked with the demo version of XLSReadWrite 3.0, but not with the registered version:

procedure TForm1.Button1Click(Sender: TObject);
var sString: string;
begin
XLSf.VBA.EditVBA := True;
XLSf.Filename:='c:\AHA Timesheet 2007.xls';
XLSf.Read;
with XLSf.VBA.ModuleByName('Module4') do begin
sString:=Source.Text;
ShowMessage(sString);
end;
end;

It crashes with an access violation on sString:=source.text;
Module4 exists. Delphi 2006

Jon

Posted: Thu Feb 01, 2007 10:02 pm
by larsa
Hello

Can you please send me the excel file?


Lars Arvidsson