close

The following calls, taken from the abstract on LoadText in OWCVBA11.chm,
fails to load and show the resulting speadsheet.I surprised I am seeing an unpopulated spreadsheet.

What is the most plausible reason this would fail?
How could I add a OnError clause that would help debugging?lt;htmlgt;
lt;object id=ChartSpace1 classid=CLSID:0002E55D-0000-0000-C000-000000000046
style=quot;width:49%;height:350quot;gt;lt;/objectgt;
lt;object id=Spreadsheet1 classid=CLSID:0002E559-0000-0000-C000-000000000046
style=quot;width:49%;height:350quot;gt;lt;/objectgt;

lt;bgt;Source: lt;/bgt;Industry Data
lt;pgt;

lt;script language=vbscriptgt;
Sub Window_OnLoad()

Dim chConstants

Spreadsheet1.ActiveSheet.Range(quot;B1quot;).LoadText quot;tabbugs.txtquot;, Chr$(9)
ChartSpace1.DataSource = Spreadsheet1

lt;/scriptgt;lt;/htmlgt;

tabbugs.txt definitely contains tabdelimited data like so:

date new open fixed verifiedfixed closed
2006-01-01 1 4 5 8 7
2006-01-02 1 4 5 8 7Thanks a million,
QA4Ever

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()