Sign in to follow this  
Followers 0
pezo89

ExelWrite to a nonspesific Cell

4 posts in this topic

Hi, how can i write some information to a nonspesific cell or row?

ie. im writing something,

presses enter

and then save,

when the doc is loaded up it will have selected the row beneeth the text, and i want it to write in there

jump two rows forward write something there this is done 3 places while the exelwindow is hidden.

iv tried controlsend, but i find that abit to slow, and abit to dodgy,

is there a way?

Share this post


Link to post
Share on other sites



Can you not read?

This is "Example Scripts" not "General Help & Support".


AutoIt.4.Life Clubrooms - Life is like a Donut (secret key)

Make sure brain is in gear before opening mouth!
Remember, what is not said, can be just as important as what is said.

Spoiler

What is the Secret Key? Life is like a Donut

If I put effort into communication, I expect you to read properly & fully, or just not comment.
Ignoring those who try to divert conversation with irrelevancies.
If I'm intent on insulting you or being rude, I will be obvious, not ambiguous about it.
I'm only big and bad, to those who have an over-active imagination.

I may have the Artistic Liesense ;) to disagree with you. TheSaint's Toolbox (be advised many downloads are not working due to ISP screwup with my storage)

userbar.png

Share this post


Link to post
Share on other sites

#3 ·  Posted (edited)

Can you not read?

This is "Example Scripts" not "General Help & Support".

My bad, was reading about and did't think about checkig the forum section prior to posting.

Can somone move it please?

Ps. well i can write good enough for you to understand me, and since a person can not write if you can not read

that question is kinda self answered.

And since i am not an idiot i would not have posted in this forum IF i where aware that i was in this section.

so instead of "mocking" me about my skills to read english, and highlight i where in the wrong section i personaly think you Should have taken a

a diffrent, understandable approach..

but that's my opinion

Edited by pezo89

Share this post


Link to post
Share on other sites

If i understand correctly you need something like:

oExcel = ObjCreate("Excel.Application")

$oExcel.Visible = 0

$oExcel.WorkBooks.Open ($filename1)

$oExcel.Application.ActiveCell.Value = "text"

$oExcel.Application.ActiveCell.Offset(2,0).Select

$oExcel.Application.ActiveCell.Value = "text2"

$oExcel.Visible = 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  
Followers 0