Search found 69 matches

by Tourless
Thu Feb 22, 2024 6:32 pm
Forum: Technical / Scripting
Topic: Setting Screen Resolution
Replies: 4
Views: 447

Re: Setting Screen Resolution

I don't know why I never thought of that. Good idea, thank you,
by Tourless
Thu Feb 22, 2024 3:37 pm
Forum: Technical / Scripting
Topic: Setting Screen Resolution
Replies: 4
Views: 447

Setting Screen Resolution

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 ...
by Tourless
Tue Oct 24, 2023 2:07 pm
Forum: Technical / Scripting
Topic: Invalid Variant Operation
Replies: 3
Views: 7042

Re: Invalid Variant Operation

That's good info, thank you.

Looks like all that was needed in this instance was a quick repair of the office 365 installation.
by Tourless
Tue Oct 24, 2023 12:05 pm
Forum: Technical / Scripting
Topic: Invalid Variant Operation
Replies: 3
Views: 7042

Invalid Variant Operation

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...
by Tourless
Wed May 10, 2023 7:41 pm
Forum: Technical / Scripting
Topic: Excel with Variable Rows
Replies: 1
Views: 5063

Excel with Variable Rows

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...
by Tourless
Mon May 08, 2023 12:42 pm
Forum: Technical / Scripting
Topic: Script Control Granularity
Replies: 4
Views: 5271

Re: Script Control Granularity

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...
by Tourless
Sat May 06, 2023 11:13 pm
Forum: Technical / Scripting
Topic: Script Control Granularity
Replies: 4
Views: 5271

Script Control Granularity

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 ...
by Tourless
Thu Apr 20, 2023 7:10 pm
Forum: Technical / Scripting
Topic: Parameter object is improperly defined?
Replies: 2
Views: 3288

Re: Parameter object is improperly defined?

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.
by Tourless
Thu Apr 20, 2023 6:08 pm
Forum: Technical / Scripting
Topic: Parameter object is improperly defined?
Replies: 2
Views: 3288

Parameter object is improperly defined?

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 ...
by Tourless
Fri Apr 14, 2023 5:04 pm
Forum: Technical / Scripting
Topic: Converting hh:mm:ss to seconds.
Replies: 1
Views: 2971

Converting hh:mm:ss to seconds.

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...
by Tourless
Thu Apr 13, 2023 2:32 pm
Forum: Technical / Scripting
Topic: Testing for Time (Script Control)
Replies: 3
Views: 3015

Re: Testing for Time (Script Control)

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...
by Tourless
Tue Apr 11, 2023 8:12 pm
Forum: Technical / Scripting
Topic: Testing for Time (Script Control)
Replies: 3
Views: 3015

Testing for Time (Script Control)

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...
by Tourless
Tue Apr 11, 2023 6:56 pm
Forum: Technical / Scripting
Topic: Replace IF first character
Replies: 3
Views: 3088

Re: Replace IF first character

And thank you both for the replies :) Now I have two solutions to handle my problem!
by Tourless
Mon Apr 10, 2023 2:28 pm
Forum: Technical / Scripting
Topic: Replace IF first character
Replies: 3
Views: 3088

Replace IF first character

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 ...
by Tourless
Thu Apr 06, 2023 4:57 pm
Forum: Technical / Scripting
Topic: Working with XML
Replies: 3
Views: 1583

Re: Working with XML

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!!
Sign up to our newsletter for free automation tips, tricks & discounts