![]() |
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