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?
<html
<object id=ChartSpace1 classid=CLSID:0002E55D-0000-0000-C000-000000000046
style="width:49%;height:350"</object
<object id=Spreadsheet1 classid=CLSID:0002E559-0000-0000-C000-000000000046
style="width:49%;height:350"</object
<bSource: </bIndustry Data
<p
<script language=vbscript
Sub Window_OnLoad()
Dim chConstants
Spreadsheet1.ActiveSheet.Range("B1").LoadText "tabbugs.txt", Chr$(9)
ChartSpace1.DataSource = Spreadsheet1
</script</html
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 7
Thanks a million,
QA4Ever