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
- Oct 05 Fri 2007 20:40
Help Spreadsheet1.ActiveSheet.Range(quot;B1quot;).LoadText debugging
close
全站熱搜
留言列表
發表留言