pezo89 Posted March 19, 2011 Posted March 19, 2011 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?
TheSaint Posted March 19, 2011 Posted March 19, 2011 Can you not read?This is "Example Scripts" not "General Help & Support". 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)
pezo89 Posted March 19, 2011 Author Posted March 19, 2011 (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 readthat 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 aa diffrent, understandable approach..but that's my opinion Edited March 19, 2011 by pezo89
Juvigy Posted March 21, 2011 Posted March 21, 2011 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
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now