michaelslamet Posted April 20, 2011 Share Posted April 20, 2011 I'm going to try a excel UDF to create myself a small application. This is the code: #include <excel.au3> global $file = @ScriptDir & "\excel.xls" $oExcel = _ExcelBookNew() _ExcelWriteCell($oExcel, "I Wrote to This Cell", 1, 1) ;Write to the Cell MsgBox (0, "Exiting", "Press OK to Save File and Exit") _ExcelBookSaveAs($oExcel, $file, "xls", 0, 1) ; Now we save it into the scriptdir directory; overwrite existing file if necessary _ExcelBookClose($oExcel) ; And finally we close out Instead of excel.xls, this code result nothing. Do I need a ms-excel installed? I only have Microsoft Office Excel VIEWER 2003 and Open Office 3.1 installed. Thanks a lot Link to comment Share on other sites More sharing options...
GEOSoft Posted April 20, 2011 Share Posted April 20, 2011 Ther viewer can't write to files. You need to have the Excel application installed. George Question about decompiling code? Read the decompiling FAQ and don't bother posting the question in the forums.Be sure to read and follow the forum rules. -AKA the AutoIt Reading and Comprehension Skills test.*** The PCRE (Regular Expression) ToolKit for AutoIT - (Updated Oct 20, 2011 ver:3.0.1.13) - Please update your current version before filing any bug reports. The installer now includes both 32 and 64 bit versions. No change in version number. Visit my Blog .. currently not active but it will soon be resplendent with news and views. Also please remove any links you may have to my website. it is soon to be closed and replaced with something else. "Old age and treachery will always overcome youth and skill!" Link to comment Share on other sites More sharing options...
michaelslamet Posted April 20, 2011 Author Share Posted April 20, 2011 Dear GEOSoft, Thanks for your reply. Is there other way except installing ms-excel ? Just copying/downloading files needed maybe? Thanks! Link to comment Share on other sites More sharing options...
GEOSoft Posted April 20, 2011 Share Posted April 20, 2011 Not that I'm aware of. George Question about decompiling code? Read the decompiling FAQ and don't bother posting the question in the forums.Be sure to read and follow the forum rules. -AKA the AutoIt Reading and Comprehension Skills test.*** The PCRE (Regular Expression) ToolKit for AutoIT - (Updated Oct 20, 2011 ver:3.0.1.13) - Please update your current version before filing any bug reports. The installer now includes both 32 and 64 bit versions. No change in version number. Visit my Blog .. currently not active but it will soon be resplendent with news and views. Also please remove any links you may have to my website. it is soon to be closed and replaced with something else. "Old age and treachery will always overcome youth and skill!" Link to comment Share on other sites More sharing options...
michaelslamet Posted April 21, 2011 Author Share Posted April 21, 2011 ok, thanks George! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now