Search found 9 matches

by pantsmonkey
Tue Apr 19, 2005 8:33 am
Forum: Technical / Scripting
Topic: Im serious this is part of my script.
Replies: 10
Views: 12135

We've never had any problems whatsoever with automating Excel 2003 with Macro Scheduler. My guess is your keyboard focus is wrong - either you're not focusing Excel or the wrong part of Excel has the focus. However, if you're reading/writing data from/to Excel I would recommend using DDE or VBScrip...
by pantsmonkey
Tue Apr 19, 2005 6:03 am
Forum: Beginners
Topic: Simple Script Code.
Replies: 2
Views: 5899

Cheers again bob.

I was positive that was the case it just seems to be an issue on each of the machines ive tried it on. with excel
by pantsmonkey
Tue Apr 19, 2005 5:48 am
Forum: Technical / Scripting
Topic: Im serious this is part of my script.
Replies: 10
Views: 12135

Is there anyway I can set the entire clipboard contents as a variable name and then use. Send Character/Text>%variablename% Im not sure how to go about this ? It still doesnt help my issue with the inability to press CTRL + F withing excel 2003. I dont understand why such a simple command wont work ...
by pantsmonkey
Tue Apr 19, 2005 5:22 am
Forum: Technical / Scripting
Topic: Im serious this is part of my script.
Replies: 10
Views: 12135

Excel 2003 It would seem Macro Schedular and Excel 2003 dont play nice (making it painfully annoying) I know the combination of using MS 6.0 and MS 7.3 EVAL is confusing me partially MS 6.0 is incapable of copying information I read in a help file somewhere about seting keylegacy to 1. I have no ide...
by pantsmonkey
Tue Apr 19, 2005 1:51 am
Forum: Beginners
Topic: Simple Script Code.
Replies: 2
Views: 5899

Simple Script Code.

Hello guys.

I am after the lines of code required for the following.

Copy Selected area to clipboard.

Paste Selection from clipboard.

I have searched but must be using incorrect wording.

It appears that

Press ctrl + V doesnt work Wish it did :) thanks
by pantsmonkey
Tue Apr 19, 2005 1:48 am
Forum: Technical / Scripting
Topic: Im serious this is part of my script.
Replies: 10
Views: 12135

I could be wrong, but I don't think that the example you are showing uses any of the newer features. You should be able to use those commands to select text with version 6. 1. Have you removed all trailing spaces? 2. Are the mouse coordinates correct? Should you be using MouseMoveRel instead? Can y...
by pantsmonkey
Tue Apr 19, 2005 12:53 am
Forum: Technical / Scripting
Topic: Im serious this is part of my script.
Replies: 10
Views: 12135

You need to add Release CTRL and Release Shift: press shift Wait>0.01 press ctrl Wait>0.01 press end Release ctrl Release shift CapsOff setfocus>Home* Wait>0.01 press home Wait>0.01 press enter Wait>1.00 MouseMove>6,564 lclick Wait>0.10 press shift Wait>0.01 press ctrl Wait>0.01 press end Release c...
by pantsmonkey
Mon Apr 18, 2005 6:59 am
Forum: Technical / Scripting
Topic: Im serious this is part of my script.
Replies: 10
Views: 12135

Im serious this is part of my script.

Im going to edit out all of my previous rant. It was a long 30 odd hours.... Sorry if I offended anyone with a sleep deprived onset of "PASTE DOESNT WORK" I digress :) CapsOff Let>NumTimesToLoop=64 Let>Counter=0 Let>X=0 Label>StartOfLoop setfocus>PPHome* WaitWindowOpen>PPHome* wait>.1 press down * 1...
by pantsmonkey
Mon Apr 18, 2005 4:04 am
Forum: Technical / Scripting
Topic: Many individual notepad docs to excel.
Replies: 0
Views: 4264

Many individual notepad docs to excel.

Hello everyone im new to this Macro Schedular thing the company I work for has just retired, Windows NT for XP which leaves or "inhouse" automation system (16 bit) in the realm of the dodo. (its not being updated) So I have decided to join the Macro Scheduler club. Forgive the length of this post I ...
Sign up to our newsletter for free automation tips, tricks & discounts