I don't know why I never thought of that. Good idea, thank you,

Hi Folks. I have a dedicated machine that runs 90% of my macros, but it's headless (no monitor). With that, windows occasionally and without warning decides to dumb down the resolution to a standard minimum of 1024 X 768. This, of course, messes up all my macros that rely on coorinates to point and ...

That's good info, thank you.

Looks like all that was needed in this instance was a quick repair of the office 365 installation.

Hi Folks. I have a macro that points and clicks it's way through a program, running a report and saving it as an xls file. Using XLOpen I was always able to open the xls and extract some values to variables. Suddenly, and without warning, my script now fails on the XLOpen line and throws an 'Invalid...

Hi Folks. I searched around but couldn't find an answer... I'm going to be working with an excel sheet that will have variable rows. My data will always be in columns B, F, and O, starting at row 14, but the last row of data will always be a mystery. I'll be reading this data into my macro and writi...

That seems like a pretty good first thought... but alas I have questions. Assuming we are talking about the runstats.ini file, can I edit that to include additional 'fields' for each section? So instead of this... [C:\Users\Mentor\Documents\Macro Scheduler 15\NYTunnelTransfers.scp] LastElapsedTime=0...

Hi Folks. I have a nice script that runs every hour from 6am to 10pm taking readings from two networked XML files, does some math, writes the values to a SQL table and reports the data in an MS Teams Chat. The data is related to production and accounts for the productivity of two specific pieces of ...

Thanks JR, you're right on the money... '%variable%' is the way to solve that problem! And yeah, I cloed my DBClose off when copying my code, my bad.

Hi Folks. I'm fairly certain I'm having a syntax issue but can't put my finger on it and I'm having a hard time finding examples . I'm simply connecting to a db and trying to insert some data. This is my first attempt at working with a db from MS and while it doesn't seem too difficult, I can't get ...

Hi Folks. I have a var that holds a time value as a string formatted as hh:mm:ss. I need to be able to parse that value into separate vars so I can perform the math to break it all down to total seconds. Once I have my total seconds I'll be able to do the rest of my math and convert any results back...

Yeah, you're right. My problem is I'm usually moving too fast to stop and search for answers. I do try to bring a semi-educated question to the table but it doesn't always work out that way :) Anyway, thank you. I'm always grateful to the people who know more than I do and are willing to help educat...

Hi Folks. My latest script runs hourly 24x7. I'd like to limit that to run between a set of hours, 6am - 10pm. Since that level of scheduling control does not exist in the Run When tab, I'm trying this but I've got something wrong... most likely syntax. Can someone show me the syntax error of my way...

And thank you both for the replies Now I have two solutions to handle my problem!

Hi Folks, I'm working with StringReplace to remove a zero from a string but I only need it removed if it's the first character in the string (left to right). I have this... StringReplace>asof,0,,asof which yields either this 09=9 or this 10=1. I need 09=9 and 10=10. How do I isolate or test on only ...

Oh that's a very good start, thank you very much Dorian! First time I'm working with xml files in any capaticy. This is a great jump start, thank you again!!