Q
qa4ever
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>
<b>Source: </b>Industry 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
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>
<b>Source: </b>Industry 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