Re^4: Creating Excel Macros from Perl

[Anonymous Monk]

adding the Sub to Codemodule and calling it from perl worked fine {with below code}. How do I call this Sub again from Excel, when i open vb editor I did not see any module with the Sub created from perl. Please help!

my $code = <<'END_CODE';
Sub dosomething(say As String)
For Each cell In ActiveSheet.Range("A1:A10")
cell.Value = say
Next cell
End Sub

END_CODE

my $codemodule = $mod->Codemodule;
$codemodule->AddFromString($code);

$xlApp->Run(
'dosomething',
'test...'
);

[Corion]

Did you save the Excel sheet?

Maybe the VB editor does not update its view on the defined subroutines and modules and needs to close and reopen the file to see the changes.

[Anonymous Monk]

yes, tried reopening. Did not work