subina

using excel access in autoit

2 posts in this topic

i hope i am in the right place, if not please advise

i have a script that i use excel objects. my goal is to delete rows off a spread sheet.

i have his code

$oexcel= objcreate("excel.application")

$currentworksheet = $oexcel.activeworkbook.worksheets(1)

; to delete row 4 i have coded

$objrange = $currentworksheet.cells(4, 1).entirerow

$objrange.delete

;the row is not delete, please advise

 

Share this post


Link to post
Share on other sites



Answered in the other thread.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (2016-08-18 - Version 1.4.6.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2016-12-04 - Version 1.2.2.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
Tutorials:
ADO - Wiki

 

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