Macro Recording and Automating Windows with Macro Scheduler – Tips & News
In More on Reading and Writing CSV Files and various other posts I have demonstrated how CSV data can be read via a SQL SELECT statement using DBQuery. In order to do this we used an ADO connection string in the DBConnect line: Let>ConStr=Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\My Documents;Extended Properties=’text;HDR=NO;FMT=Delimited’ DBConnect>ConStr,dbH “Proper” CSV files use the double quote […]
If you have a database table with an auto-generated numerical index field, you may need to retrieve the value of this field after an INSERT statement. In Microsoft Access such a field uses an “AutoNumber” data type. In MySQL it’s known as an “auto_increment” field. We often see these types of fields where a relationship […]
A quick and easy way to remove HTML tags from a string: Let>Html=Hello WorldTest link Let>pattern= RegEx>pattern,Html,0,matches,numMatches,1,,plainText MessageModal>plainText
This morning, forum user hip asked how a script could sort a CSV file. Seems CSV files, sorting and Excel has become a bit of a hot topic here lately. Since Excel can read and save to CSV and also has a Sort function we might as well make use of it. Here’s a little […]
Earlier this month I wrote about how you can read and write data from/to CSV files as if they were database tables using DBQuery. Andrew asked if I knew of a way that XML files could be treated as database tables in the same way. I did find a couple of references to some ODBC […]
I was recently asked how to get a list of files from a folder, and then randomly shuffle that list. The following code retrieves the list of files to an array using GetFileList and Separate and then loops through the array shuffling it randomly: GetFileList>c:\docs\*.*,file_list Separate>file_list,;,files_array If>files_array_count>0 //randomize the array Let>k=0 Repeat>k Let>k=k+1 Random>{%files_array_count%-1},random_index Let>random_index=random_index+1 […]
More on Reading from CSV Files In Reading from CSV Files I showed you how you could read an entire CSV file into an array of rows and columns. It used a SELECT * SQL statement to retrieve the entire table. If you just want to read in a specific set of data you could […]
If you create lots of Macro Scheduler macros you probably have pieces of code you use frequently. You might have blocks of VBScript or subroutines you often use in your macros. Copying and pasting code like that into your scripts is time consuming and also means if you ever need to change that code you’ll […]
If you are automating web pages or web applications you may at some point need to automate dialog boxes produced by client side script, like the one that pops up when you click the link below: Confirm Popup So you might want to be aware that the title of these popups varies between different versions […]
Twice today, for two different people, I needed to write some code to iterate through files in a tree of subfolders. The subfolder structure could not be known up front and there may be any number of subfolders and any number of folders deep. One could use GetDirList iteratively, or use VBScript’s FileSystem Object. But […]