Thanks for the reply. I'll try putting a loop in at this point. I already use a loop at other points in this script, but I hadn't yet tried it for this GTA.

I have used MacroScheduler for about 18 months now, and have documented labor savings of about $50,000 for my purchasing dept using the script below to create purchase orders from Excel spreadsheet data. However, there is one nagging problem I have not been able to fix. Sometimes, on the very first ...

I searched my code for occurrences of "complete", and found that indeed I had inadvertently used it as a numeric variable. After changing that, the script is processing as expected. The variable %complete% was later in my code than the Position test, but within the same Repeat loop, so I would alway...

Thanks for the suggestions; I will go over my code looking for a use of "complete" as a variable. I'm thinking that Marcus is probably on the right track, and I slipped up and used a result test as a variable name in my latest round of edits to account for conditions which my users "forgot" to tell ...

Thanks for the tip; I may make that a habit. For the current situation, the case is correct. The variable case is just as I typed it in my post, and you can see that the command is searching for the word with the same case. The thing that is puzzling to me is the fact that it works some, but not all...

I am having a problem with the Position> command. I ran my code to a breakpoint just below where this command is used, and could plainly see the text variable containing the substring, but the result variable was 0. This command has worked previously. NOTE: I have also had problems today with Screen...

Does this same problem present itself when executing compiled scripts solely from desktop shortcuts? My plan is to compile executables, place them on a shared drive, and have my users execute them via desktop shortcuts. They will execute multiple times per day, multiple scripts. Is this implementati...

Thanks for the info. I did not have a second copy of MSched running, but after a re-boot, the screen capture is working again, and so far has not yet recurred. Still wondering what may have caused the loss of functionality. I'm concerned about putting compiled scripts out there for 15-20 users who e...

5 days left on my evaluation period, and the sample macro Text Capture suddenly stopped working; it displays the dialog box, but does not return any text from any spot on screen, and will not capture text for any open window -- it just moves focus to the selected window, but returns no text. And my ...

Thanks, Marcus. I had just gone back to fundamentals , and used the command reference to insert the If statement and realized what was missing.

There must be something I'm missing about comparing strings. Why doesn't this code work right? ****** Poster's edit: NEVER MIND: Too many VBA habits, too hard to see simple prompts (lack thereof) IF> Let>v1=13591P003 Let>v2=26113P001 If v1=v2 messagemodal>same Else messagemodal>different Endif

Thanks for the suggestion. I will try this; if I read the code correctly, you are moving the array matrix values into a single variable, copying that variable to the clipboard, then pasting it into Excel -- and that is probably faster than writing each individual cell in Excel... still not as fast a...

OK, thanks. With that information, I went back and reviewed my DSN settings, and discovered that the query was probably timing out. I removed the timeout option in my ODBC manager; not my preferred solution, but at least it allows the query to run, and it returns the correct number of rows and field...

I am still in evaluation mode, but lots of experience scripting with other tools (mostly VBA). Currently trying to move working SQL code into MS for querying Oracle tables. I had success with a relatively short test SQL, but the code I am trying to automate is over 1,500 characters -- multiple table...