New topic: Couldn't generate an excel file in Mac
<http://forums.realsoftware.com/viewtopic.php?t=45229> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message mbari Post subject: Couldn't generate an excel file in MacPosted: Mon Sep 03, 2012 2:20 am Joined: Wed Aug 22, 2012 6:45 pm Posts: 7 Hi, I have a beginner's query. I tried to run, unsuccessfully, the following code from Language Reference when a pushbutton is pressed Dim excel as ExcelApplication Dim book as ExcelWorkbook Dim sheet as ExcelWorksheet excel = New ExcelApplication excel.visible = true book=excel.workbooks.add excel.activesheet.name="Expenses Report" excel.Range("A4","A4").value="Total" excel.Range("B1","B3").value="5" excel.Range("B1","B3").style="Currency" excel.Range("B4","B4").value="=sum(B1:B3)" Exception err as OLEException MsgBox err.message It says book and sheet both are Nil. Some body please explain why it is so. What should I do if I need 1. to generate an excel file named as the text entered in listbox1, and 2. it to be saved on my desktop once my application runs till the end. Thanks for your anticipation. Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 1 post ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml rbforumnotifier@monkeybreadsoftware.de
