Jadog 0 Posted August 18, 2011 I'm new at using AutoIT, and I'm trying to open an existing excel workbook and then change cell A24 to 'YES'. I have succeeded in having autoit open the workbook and run a macro, and next I want it to alter A24 to 'YES'. I'm sure I'm missing something simple, but I get an error code when I try the following: Dim $objXLDoc $objXLDoc = ObjCreate("Excel.Application") With $objXLDoc.Application .AutomationSecurity = 1 ; Explicitly set the macro security level to allow macros .Visible = 1 ; Set the application visible (without it, this instance of Excel is running in the background, invisible) .Workbooks.Open ("\\SERVER\CPSQL\TopLevel\A Harvest of Health\Activity\Import\Scan Genius Update Vendor Items & Add New Products(NEW).xls") ;Open the Workbook $x = .Run("AllOthers") ; Run "AllOthers" Macro EndWith _ExcelWriteCell($oExcel, "YES", 24, 1) Share this post Link to post Share on other sites
nitekram 68 Posted August 18, 2011 you might want to try excel.au3? - i am sure there are others, you can take a look. 2¢All by me:"Sometimes you have to go back to where you started, to get to where you want to go." "Everybody catches up with everyone, eventually" "As you teach others, you are really teaching yourself." From my dad "Do not worry about yesterday, as the only thing that you can control is tomorrow." WIKI | Tabs; | Arrays; | Strings | Wiki Arrays | How to ask a Question | Forum Search | FAQ | Tutorials | Original FAQ | ONLINE HELP | UDF's Wiki | AutoIt PDF AutoIt Snippets | Multple Guis | Interrupting a running function | Another Send StringRegExp | StringRegExp Help | RegEXTester | REG TUTOR | Reg TUTOT 2AutoItSetOption | Macros | AutoIt Snippets | Wrapper | Autoit Docs SCITE | SciteJump | BB | MyTopics | Programming | UDFs | AutoIt 123 | UDFs Form | UDFLearning to script | Tutorials | Documentation | IE.AU3 | Games? | FreeSoftware | Path_Online | Core Language Programming TipsExcel ChangesControlHover.UDFGDI_PlusDraw_On_ScreenGDI BasicsGDI_More_BasicsGDI RotateGDI GraphGDI CheckExistingItemsGDI TrajectoryReplace $ghGDIPDll with $__g_hGDIPDllDLL 101?Array via ObjectGDI SwimlaneGDI Plus French 101 SiteGDI Examples UEZGDI Basic ClockGDI DetectionTernary operator Share this post Link to post Share on other sites
Juvigy 49 Posted August 19, 2011 $objXLDoc = ObjCreate("Excel.Application") _ExcelWriteCell($oExcel, "YES", 24, 1) See those 2 lines? here is yur error. Last line should be: _ExcelWriteCell($objXLDoc, "YES", 24, 1) Share this post Link to post Share on other sites