J
JuergenM
Hi all,
Having an Excel (2003) file with classes and functions, I would like to control it by Perl (ActivePerl 5.12.4) using Win32::OLE. Running functions works well with $excel->Run("fun..."), so does working on worksheets or other OLE objects, but I don't know how to instantiate (and use) objects of my own classes.
$obj = Variant(VT_DISPATCH, 'clsObject')
returns
x $obj
Win32::OLE::Variant=SCALAR(0x43ba754)
-> 71232916
which is of TYPE 'VT_DISPATCH',but it has nothing to do with class 'clsObject' in the VBAProject of my Excel file and it doesn't know clsObject's methods and attributes.
I didn't find any doc for this task. I would like to migrate my Excel project to a Perl project over time, but I have to do it step wise, because it has >150 classes
So I have to use existing classes / algorithms.
Any tips?
Juergen
Having an Excel (2003) file with classes and functions, I would like to control it by Perl (ActivePerl 5.12.4) using Win32::OLE. Running functions works well with $excel->Run("fun..."), so does working on worksheets or other OLE objects, but I don't know how to instantiate (and use) objects of my own classes.
$obj = Variant(VT_DISPATCH, 'clsObject')
returns
x $obj
Win32::OLE::Variant=SCALAR(0x43ba754)
-> 71232916
which is of TYPE 'VT_DISPATCH',but it has nothing to do with class 'clsObject' in the VBAProject of my Excel file and it doesn't know clsObject's methods and attributes.
I didn't find any doc for this task. I would like to migrate my Excel project to a Perl project over time, but I have to do it step wise, because it has >150 classes
So I have to use existing classes / algorithms. Any tips?
Juergen