Based upon your definition of the Excel data file from your previous post, here is a little sample of code which should return the corresponding date when given the ID. I created an XLS data file according to your sample, and tested the following code. When I entered "cgn02" as the ID it correctly r...

WaitReady is not able to work sucessfully with *EVERY* situation, however I noticed you didn't try it using the parameter of "1". Using WaitReady>1 also makes it wait for screen paint events to complete. So, instead of WaitReady>0 in your situation try WaitReady>1 If that doesn't work, there are man...

Maybe the problem lies in how you are getting the text into the clipboard in the first place? How is text going to the clipboard? *Another thought* - Do you have to use the clipboard? Why not use other data storage techniques? Like read from file, read from memory components, read from database.... ...

Yes, It is possible :D This does require *some* programming skill/experience as this is not just a simple "move mouse/send keystroke" type of macro. This forum is a wealth of code samples and ideas. Try dividing your problem up into smaller parts, and then trying to make the small parts work first -...

Here is another technique that I started using many years ago. It uses VBScript to format the results into HTML, and then display in the browser. The final display can be as pretty as you want, and include logo images, colors, etc...... just up to your HTML coding skills. This example just shows the...

If as you say, the file name is always the same number of characters,
then here is possibly a simpler approach.


[code]
VBStart
VBEnd

Let>var=-rw-r----- 1 57223 6560 148 Apr 12 15:13 XXX20100414.csv

VBEval>right("%var%",15),result
MessageModal>result
[/code]

At this point it doesn't seem like a Macro Scheduler issue, since the clipboard seems like it's the problem. I work exclusively in an English only environment, so mixed languages on the clipboard aren't something I have ever had to deal with. Let's attack the problem in a different way. Maybe the cl...

Here is something to try instead of sending the key strokes to do paste.

[code]
GetClipBoard>result
Send>result
[/code]

This should get you started.... [code] Input>Target_date,Enter Date (mm/dd/yyyy) to execute, Input>Target_time,Enter Time (hh:mm 24 hour time) to execute, Year>Cur_Year Month>Cur_Month Day>Cur_Day Hour>Cur_Hour Min>Cur_Min Sec>Cur_Sec Separate>Target_date,/,arrItems Let>Target_Month=arrItems_1 Let>T...

There is another possibility.... That is DingDong expects the count to return 4 and it returns the number 1. So.... the possibility exists that the column clientid contains null in 3 of the 4 rows. To have the count function give you the row count and ignore any nulls it encounters do the following:...

Is the version of wavelab you are running a 64 bit or 32 bit app?

Since I know nothing about your application Wavelab.... maybe some additional info might help here...


What is the OS?
What is the Macro Scheduler version?

Is this a desktop app or a SaaS application (run in a browser?) I'm pretty sure the answer is desktop app (but you never know?)

This is not just a Macro Scheduler problem, this occurs when passing parameters to almost any EXE on the command line. The solution is to put double quotes around the parameter which has spaces in it. I compiled the following simple macro and tested that it works fine MessageModal>PATH MessageModal>...

//
//Perform SELECT query
//
DBQuery>dbRep,SQL,CLIENTS,NumRecs,NumFields
Message>records %NumRecs%
Message>records %NumFields%

First thing I notice is that there is no SQL query defined to run.
Like the following:

I have used this resource in the past with good results



Enjoy|!