Jump to content
Sign in to follow this  

Help with changing cell in Excel

Recommended Posts

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

_ExcelWriteCell($oExcel, "YES", 24, 1)

Share this post

Link to post
Share on other sites

you might want to try excel.au3? - i am sure there are others, you can take a look.

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 2

AutoItSetOption | Macros | AutoIt Snippets | Wrapper | Autoit  Docs

SCITE | SciteJump | BB | MyTopics | Programming | UDFs | AutoIt 123 | UDFs Form | UDF

Learning to script | Tutorials | Documentation | IE.AU3 | Games? | FreeSoftware | Path_Online | Core Language

Programming Tips

Excel Changes




GDI Basics


GDI Rotate

GDI Graph

GDI  CheckExistingItems

GDI Trajectory

Replace $ghGDIPDll with $__g_hGDIPDll

DLL 101?

Array via Object

GDI Swimlane

GDI Plus French 101 Site

GDI Examples UEZ

GDI Basic Clock

GDI Detection

Ternary operator

Share this post

Link to post
Share on other sites

$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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Create New...