Search found 18 matches

by Franklin
Tue Aug 13, 2024 9:29 pm
Forum: Enhancement Suggestions
Topic: Plans for future updates?
Replies: 4
Views: 7000

Re: Plans for future updates?

Any updates yet?
by Franklin
Wed Jul 17, 2024 7:19 pm
Forum: Enhancement Suggestions
Topic: Plans for future updates?
Replies: 4
Views: 7000

Re: Plans for future updates?

Same here. Any updates on the horizon?
by Franklin
Thu Jun 10, 2021 10:39 am
Forum: Beginners
Topic: Chrome Capturing HTML / Javascript Page source Values
Replies: 1
Views: 13566

Re: Chrome Capturing HTML / Javascript Page source Values

Sharing the discovery of one workable solution using pyexe features This was tricky because the normal elements on the page did not visually display the hidden data. It was found in the HTML source code by parsing each javascript/text section. Using pyexe features of Macro Scheduler, this overwhelmi...
by Franklin
Mon Jun 07, 2021 9:41 pm
Forum: Beginners
Topic: Chrome Capturing HTML / Javascript Page source Values
Replies: 1
Views: 13566

Chrome Capturing HTML / Javascript Page source Values

Hello. Looking for best approach to to capture the follow datapoints out of an online HTML file. I tried setting up a Chrome session and looked for the datapoints via ChromeFindElements but they all come back empty. or zero. Any suggestions on an approach to capture data points which appear in the s...
by Franklin
Sat Feb 20, 2021 1:05 pm
Forum: Technical / Scripting
Topic: File Drag and Drop?
Replies: 9
Views: 8600

Re: File Drag and Drop?

Another possible take on this is to use Selenium WebDriver

Destination can be a local source

References for code found Here:
https://www.guru99.com/drag-drop-selenium.html
https://www.browserstack.com/guide/drag ... -selenium
by Franklin
Wed Oct 28, 2020 11:01 am
Forum: Beginners
Topic: Why Does Loop Exit without meeting requirements?
Replies: 3
Views: 4446

Re: Why Does Loop Exit without meeting requirements?

Dorian!

Great example of using individually defined variables as parameters within a command.
i.e. NumFound1 & NumFound2...

Thank you for a much cleaner example of code!
by Franklin
Tue Oct 27, 2020 1:33 pm
Forum: Beginners
Topic: Why Does Loop Exit without meeting requirements?
Replies: 3
Views: 4446

Why Does Loop Exit without meeting requirements?

Hello Everyone. I have a small head scratching puzzle. It's beyond my noob skills at the moment. The goal of this script is to search the screen for image1.bmp and click on image1.bmp every time its found on the screen until it finds image2.bmp then the script should exit the mainloop and find image...
by Franklin
Sat Sep 05, 2020 12:46 pm
Forum: Beginners
Topic: Passing the ChromeOptions object into the ChromeDriver constructor
Replies: 1
Views: 4358

Passing the ChromeOptions object into the ChromeDriver constructor

Passing the ChromeOptions object into the ChromeDriver constructor

Can anyone provide an example of how to do this natively in Macro Scheduler?
by Franklin
Mon Aug 17, 2020 5:19 pm
Forum: Scripts and Tips
Topic: SOLVED ChromeDriver.exe prevents recompile of script exe
Replies: 0
Views: 44886

SOLVED ChromeDriver.exe prevents recompile of script exe

Hello This is a tribal knowledge share, hopefully saves you hairloss and some time. DESCRIPTION: When using ChromeDriver.exe in a script sometime this will prevent a script .exe from recompile. ERROR MESSAGE: The error will mention something like EF Create Error... access violation, in use, etc. FIX...
by Franklin
Sun Jul 26, 2020 8:57 pm
Forum: Beginners
Topic: Opening a URL containing a % symbol
Replies: 3
Views: 5734

Re: Opening a URL containing a % symbol

Another option is to use VBA functions (like below) to code/decode the URL and pass it on to execute file command Code Couresty of http://www.freevbcode.com/ShowCode.asp?ID=1512 Public Function URLEncode(StringToEncode As String, Optional _ UsePlusRatherThanHexForSpace As Boolean = False) As String ...
by Franklin
Thu Jul 23, 2020 10:13 pm
Forum: Enhancement Suggestions
Topic: Function for Fiscal Week Numbering
Replies: 3
Views: 15182

Re: Function for Fiscal Week Numbering

Thought I'd share this: If its posted in the wrong place, I can repost in the tech scripts Special Thanks to Dorian for the direction and code //Get Today's Date getDate>Today //Get Current Year Year>FYear //Add One Year for current FY --- DateAdd>Today,Y,1,FY2 //Grab Just the Year Part DatePart>%FY...
by Franklin
Tue Jul 21, 2020 11:20 pm
Forum: Enhancement Suggestions
Topic: Function for Fiscal Week Numbering
Replies: 3
Views: 15182

Function for Fiscal Week Numbering

Function 1: Function which determines Fiscal Week number of a given year Function 2: Get the correct Week number of a given Date (use after Function 1 is available) Function 1: Suggest a function which returns the fiscal year week number. Fiscal year starts differently for everyone which is a reason...
by Franklin
Tue Jul 21, 2020 8:00 pm
Forum: Technical / Scripting
Topic: Excel - XLBookhandle Using ExecuteFile> Command
Replies: 3
Views: 5088

Re: Excel - XLBookhandle Using ExecuteFile> Command

I am definitely going to reread the MacroScheduler Manual.

Again thank you for your support!
by Franklin
Tue Jul 21, 2020 7:09 pm
Forum: Technical / Scripting
Topic: Excel - XLBookhandle Using ExecuteFile> Command
Replies: 3
Views: 5088

Excel - XLBookhandle Using ExecuteFile> Command

Using XLCreate/XLOpen is actioned via COM so macros within personal & Xlam files not available unless included with existing workbook. Excel Macros and AddIns can be accessed if the file is opened with ExecuteFile>workbook.xlsx XLBookHandle is a handle returned when using XLCreate/XLOpen but isn't a...
cron
Sign up to our newsletter for free automation tips, tricks & discounts