Macro Scheduler Forums

pgriffin

Or, if you are looking constantly at the same spot, you might try

WaitPixelColor>ColorCode,X,Y,Timeout...

So

WaitPixelColor>16777215,100,333,60

would wait 60 seconds for the pixel at 100,333 to turn white.

then based on the value of WPC_RESULT, you could perform what ever action needed.

pgriffin

Dick,

What is your ERP? I have encountered a few ERP's which seem to ignore data sent directly via the Windows API. Curious...after your SetControlText> commands, are you using PushButton> to try to enter the data or are you Lclicking or hotkeys?

pgriffin

Code: Select all

[code]
If>variable1=1
    copyfile>c:\text1,d:\text1
Else
    if>variable1=5
         copyfile>c:\text5,d:\text5
    Else
         If>variable1=20
             copyfile>c:\text20,d:\text20
         endif
     endif
EndIf

[/code]

pgriffin

I agree that this was tough one to spot, Good job!

This is another good reason to ALWAYS use longer variable names.

Use something like GetActiveWindow>ActiveWindow,X_Pos,Y_Pos

Single letter variables are trouble...

pgriffin

try this:

let>PathAndFile=file_names_%k%
seperate>%PathAndFile%,\,segment
let>TheFile=Segment_%segment_count%

pgriffin

Thank you, Me_again! that is what I thought (and have experienced)...

I have also embedded passwords in an Access database which is password protected, then retreive the password with some vbscript which is run from a compiled macro.

A little more work, but that way the password is protected.

pgriffin

My mistake. I will test a few options and see what can be done.

pgriffin

Encrypted macros require the password to open the program, well before the MACRO_RESULT is populated. Would it be possible for you to encrypt the calling macro (the 'F9' macro) and place the password macro within a Subroutine (srt>) which is only called when needed? For sensitive data it may be a be...

pgriffin

Any chance I can get a look at this app? If not, how about an on-line session so you can show me what you are dealing with?

pgriffin

Try using the GetControlText> command. GetControlText>WindowTitle,ClassName,Instance,Result where ClassName would be replaced by OTable GCT>WindowTitleGoesHere,OTable,1,HereIsYourAnswer where 1 means it is the first occurrence of such an object on the desktop. With this window open, View System Wind...

pgriffin

Aaron's method may work for you, but it assumes the file name is in WindowName. What sort of file are you moving? Text? If it is text, why not ReadFile>OldFile,TheFileText Writeln>NewFile,result,TheFileText then, possibly try to delete OldFile? Many possibilities, but it depends on the type of file ...

pgriffin

ReadFile>C:\BarcodeCreator\output.txt,testfile VBSTART Function StripNonAscii (rvntVal As Variant) Dim i Dim sTmp 'stubbed out to enable DBCS chars StripNonAscii = rvntVal Exit Function For i = 1 To Len(rvntVal) If Asc(Mid(rvntVal, i, 1)) 126 Then sTmp = sTmp & " " Else sTmp = sTmp & Mid(rvntVal, i,...

pgriffin

I believe you should be able to do a readfile to create a variable which contains each line seperated by a CR/LF

then if you assign the variable to Dialog.ComboBox

like let>Dialog.SomeComboBox=Line1%crlf%line2%crlf%...etc....

Then ResetDialog, and go back to your GetDialogAction>

pgriffin

time to think about learning a bit of VBScript. DateDiff(interval, date1, date2 [,firstdayofweek[, firstweekofyear]]) http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/fe4e5302-9602-4e0f-8496-559c7f58c8fa.asp I would "trust" vbscript to handle this type function. There w...

pgriffin

My guess would be to try using VBScript. You could call you VBScript from MacroScheduler, if you like.

This not an endorsement, but I have found useful VBScript here in the past.

http://www.visualbasicscript.com

Search found 431 matches