I see the examples of VBScript reading from an Access table, but I don't need to pass any parameter to look up. I need to read from Access, row by row, and place the values in 4 different MacroScheduler variables each time. every field into a variable and, eventually, every record of the database. t...

I have an Access database which contains two tables. I need to perform a ddepoke to a specific table and field with data I am reading from a text file.
I use DDERequest/DDEPoke only with Excel so far. Is this possible?

HELP!

btw, I did find the VBScript example, just wonder if there is a way in the line

DDERequest>......

Is it possible to read data from Excel via DDERequest and include somewhere in the syntax to read from a specific sheet?

keyboard is what I am currently doing, but I've learned that if a user re-orders the columns, my keystrokes will hit he wrong columns. So I wanted to try SetControlText, which I am glad has happened because I now love that command and will use it extensively where it applies. My next route will be t...

Thank you. Then on a window where users are allowed to change the order of columns, instance would definitely be unreliable. Any chance of having a VB guru solve this? maybe read the system windows, find the first occurence of these edit boxes AFTER the occurrence of the parent window, then return t...

how am I to be sure that a numeric constant like 'instance' will be the same each time? is this something for which I should create a variable to programmatically populate? Is it reliable to use the same instance number for that object each time?

I'll test, but would like your opinion

ok. instance of that column? instance of that WindowTitle? of All such columns?

I'll try them all, but...

I believe gave the information for the column heading instead of the edit box for the heading. it appears the edit boxes for several headings are located in a Centura:ChildTable"" I cannot rely on the column's location, width, etc to be constant. I think SetControlText is my only hope (short of buyi...

I am continuing to attempt to get it right, but if anyone can clarify the proper syntax sooner, please do! here is one of the controls for which I want to set the text as copied from View System Windows. 2229084 - Centura:Ch:Column "Cost Code" obviously,, I want to fit the right bits into: SetContro...

dbish, You are like me. I don't want to "learn" everything under the sun, but I love to work in MacroScheduler. My advice, do the macroschedule part yourself and send the VBScript bits to Rentacoder.com. Thousands of coders from who-knows-where in the world will gladly write some VB for peanuts. Sku...