in reply to Win32::OLE::Variant Array
PERL codeDim vtSec As Variant <br> Dim vtFields As Variant<br> Dim vtData As Variant<br> strSecId = Cells(currRow, colSecurityID).Value <br> vtSec = Array(Cells(currRow, colBBCode).Value & " " & Cells(cur +rRow, colSecType).Value)<br> vtData = bbObject.BlpGetHistoricalData(vtSec, vtFields, CDate(st +rBdate), CDate(strEDate)) <br>
use Win32::OLE;<br> use Win32::OLE::Variant;<br> $blpData = Win32::OLE->new('Bloomberg.Data.1') or die "can NOT load t +he blpData" ;<br> #print $blpData->Timeout . "\n";<br> $aSec = Variant(VT_BSTR, "IBM Equity");<br> #@tmpArray = ("PX_Last"); <br> $aFields = Variant(VT_ARRAY|VT_BSTR, 1 );<br> $aFields->Put(0, "PX_Last");<br> $sDate = Variant(VT_DATE, "2007/07/01");<br> $eDate = Variant(VT_DATE, "2007/07/10");<br> $bbData = Variant(VT_EMPTY, 1);<br> $bbData = $blpData->BLPGetHistoricalData($aSec, $aFields, $sDate, $e +Date);<br> print "Error: " . Win32::OLE->LastError . "\n";<br> #print "Array Size: " , $bbData->Dim . "\n";<br> print "Returned: " . $bbData->Get(0) . "\n";<br> #@aDim = @bbData->Dim ;<br> #foreach $tmp (@aDim) {<br> # print $tmp<br> # <br> #}<br> print "end" ;<br>
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re^2: Win32::OLE::Variant Array
by almut (Canon) on Aug 18, 2007 at 19:48 UTC | |
by kevind0718 (Scribe) on Sep 07, 2007 at 16:36 UTC | |
by almut (Canon) on Sep 07, 2007 at 18:12 UTC | |
by kevind0718 (Scribe) on Sep 07, 2007 at 19:30 UTC | |
by Anonymous Monk on Mar 30, 2011 at 12:07 UTC | |
by Anonymous Monk on Aug 20, 2007 at 20:32 UTC | |
by almut (Canon) on Aug 20, 2007 at 22:26 UTC | |
by Anonymous Monk on Aug 21, 2007 at 15:21 UTC | |
by almut (Canon) on Aug 21, 2007 at 19:25 UTC | |
|
Re^2: Win32::OLE::Variant Array
by Anonymous Monk on Aug 17, 2007 at 21:02 UTC |