Thank you!

Hi, I just saw this: Sleep Method See Also Running Your Scripts | WScript Object Suspends script execution for a specified length of time, then continues execution. object.Sleep(intTime) Arguments object WScript object. intTime Integer value indicating the interval (in milliseconds) you want the scr...

Now it's interesting, who of us is a Junior Coder. :))

By the way, interesting - question to Marcus - what happens when you call a label by a name of a command (readfile)? - nothing? Proceed as always?

And in the Notepad,

Press CTRL
Send>a
Release CTRL
WaitClipboard
GetClipboard>FileText

etc.

But why do you have to go line-line?? I would do it like: ReadFile>YourFilePath,FileText RPL>FileText,CRLF,%CRLF%%YourString%,FileText DeleteFile>YourFilePath WriteLn>YourFilePath,wresult,%YourString%%FileText% Probably it's good to check in the beginning that there are no empty strings at the end, ...

Thank you! I will investigate it.

Marcus,

Where do you find all this information about the automation objects? How do you know, which functions are available for Excel, Word objects? And for the database objects, too - is there anywhere a good reference to it?

Thank you very much,
Olga.

I meant calling functions/procedures and passing parameters between Macro Scheduler and VBS, not inside VBS.

Hi all, From a long experience: :) when you need to get something from VBS, if it needs some input parameters, don't use functions in VBS but procedures. Why: because when you pass as a parameter a string that contains quotes or comma or some other special characters, then it all will be interpreted...

Hi All, Just several functions you may find useful working in VB with regular expressions: Function RegExpReplace(patrn, strng, strtoReplace) Dim regEx Set regEx = New RegExp ' Create regular expression. regEx.Global = True ' Set global applicability. regEx.Pattern = patrn ' Set pattern. regEx.Ignor...

Thank you!!! Seems to be exactly what I needed! I thought how I can calculate the date together with time, so I wrote it like this: Function ReturnDate(intYears, intMonth, intDays, intHours, intMinutes) Dim MyTime MyTime = DateSerial(intYears, intMonth, intDays) MyTime = DateAdd("h", intHours, MyTim...

Thank you!! Will do.

Thank you, Marcus!! I get as an input from the user day, month, year, hour, minutes and from this I should form a date that I can give then to functions like Add in Macro Scheduler or DateAdd in VBS. I just remembered there was in JScript a function forming a date from separate numbers representing ...

Hi all, Probably a stupid question, but I'm not finding any way to do it now... I see that VBScript can take a date string and read from there, but the manual says, it's under condition, that this string presents the system date/time format settings, and I don't know which format settings will be on...

Thank you :) Here are more specific questions: 1. Which exactly commands of Macro Scheduler should I use to send a select query to a database? Could you please bring an example? 2. How the select query is returned? 3. Which exactly commands of Macro Scheduler should I use to insert/update values in ...