| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Startup Error debugging help | Excel Discussion (Misc queries) | |||
Threaded Mode
