ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Help Spreadsheet1.ActiveSheet.Range("B1").LoadText debugging (https://www.excelbanter.com/charts-charting-excel/62764-help-spreadsheet1-activesheet-range-b1-loadtext-debugging.html)

qa4ever

Help Spreadsheet1.ActiveSheet.Range("B1").LoadText debugging
 
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




All times are GMT +1. The time now is 12:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com