Jump to content
Sign in to follow this  
Jadog

Help with changing cell in Excel

Recommended Posts

Jadog

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

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."

 

WindowsError.gif

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

ControlHover.UDF

GDI_Plus

Draw_On_Screen

GDI Basics

GDI_More_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
Juvigy

$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  

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.