Search found 3480 matches

by JRL
Tue Nov 12, 2024 9:19 pm
Forum: Technical / Scripting
Topic: Detect Date Format & Change If Required?
Replies: 5
Views: 638

Re: Detect Date Format & Change If Required?

Do you have any control over the web page (parsed html)? If yes, I would address it there. If no, I think you're left guessing. Looks to me like Dorian's over-thinking has given you a better than 50/50 shot at getting the correct month and day. For identifying the year you might try VBScript to put ...
by JRL
Fri Nov 08, 2024 5:23 pm
Forum: Technical / Scripting
Topic: Check if String matches one of multiple options?
Replies: 3
Views: 363

Re: Check if String matches one of multiple options?

I would put the list to a variable then Separate> the list using your string parsed result variable. Also if there is a chance for string case to fluctuate, make sure to assign case to avoid errors. LabelToVar>LanguageCode,vLanguageCodeList UpperCase>vLanguageCodeList,vLanguageCodeList Let>dcLANGMat...
by JRL
Thu Oct 31, 2024 6:02 pm
Forum: Technical / Scripting
Topic: Difference In File Size Calculations
Replies: 3
Views: 612

Re: Difference In File Size Calculations

Your Let>strFiles=%Files1%+%Files2%+%Files3% line is adding a plus sign to the text. try rewriting it to:

Code: Select all

Let>strFiles=%Files1%;%Files2%;%Files3%
by JRL
Fri Oct 25, 2024 2:01 pm
Forum: Technical / Scripting
Topic: Get Total File Size of All Files In Folder
Replies: 1
Views: 6744

Re: Get Total File Size of All Files In Folder

Code: Select all

VBSTART
  Function GetFolderSize(Path)
     Set objFSO = CreateObject("Scripting.FileSystemObject")
     Set objFolder = objFSO.GetFolder(Path)
     GetFolderSize = objFolder.Size
  End Function
VBEND
VBEval>GetFolderSize("c:\temp"),fSize

MDL>fSize
Posted HERE by RNIB back in November 2017
by JRL
Thu Oct 24, 2024 2:28 pm
Forum: The Water Cooler
Topic: MS Help
Replies: 7
Views: 7946

Re: MS Help

I feel like I'm the most annoying customer/user you have come by... Wait!!! I thought I was the most annoying customer / user / forumite / name your poison... @ Pepsihog There used to be and likely still are freeware programs out there for downloading entire websites. I don't plan to do this myself...
by JRL
Mon Oct 21, 2024 3:59 pm
Forum: Technical / Scripting
Topic: Chromedriver disables Trusted Platform Module (TPM)
Replies: 6
Views: 1110

Re: Chromedriver disables Trusted Platform Module (TPM)

I know nothing about this device. May not work but maybe there's something similar out here that will work. Just a thought. https://www.amazon.com/Pankia-Physical-Keyboard-Simulated-Assistance/dp/B0CPPHTBNX/ref=sr_1_1?crid=YJ8G3HELCIMH&dib=eyJ2IjoiMSJ9.SgNK8umnMYr3t15HqQZnCowr19k75Ds_6Wen0rUbqO9Dloh...
by JRL
Wed Oct 16, 2024 3:59 pm
Forum: Technical / Scripting
Topic: Dialog Designer Help
Replies: 8
Views: 1475

Re: Dialog Designer Help

For future reference. Setting ItemIndex to -1 displays a radio group with nothing preselected. Once a selection is made, there is not a way to return to no selection unless you create a way to return to no selection. For example a button could be made to reset ItemIndex to -1.
by JRL
Wed Oct 16, 2024 3:28 pm
Forum: Technical / Scripting
Topic: Dialog Designer Help
Replies: 8
Views: 1475

Re: Dialog Designer Help

just need to sort out preventing multiple selections now. That's what radio boxes are for. Dialog>Dialog1 object Dialog1: TForm Left = 238 Top = 95 HelpContext = 5000 BorderIcons = [biSystemMenu] Caption = 'Select Option' ClientHeight = 213 ClientWidth = 381 Color = clBtnFace Font.Charset = DEFAULT...
by JRL
Mon Sep 30, 2024 3:42 pm
Forum: Enhancement Suggestions
Topic: PDF Display in a Dialog
Replies: 9
Views: 7288

Re: PDF Display in a Dialog

Sorry. Been off sick for the last couple of weeks and now slowly catching up. This isn't going to work for me. The new TMSAcroPDF viewer control requires Adobe Acrobat Viewer to be installed. If I was willing to use PDF viewing software I would have simply used Microsoft's SetParent function with "X...
by JRL
Thu Sep 05, 2024 4:54 pm
Forum: Beginners
Topic: Pause and Resume a Macro?
Replies: 2
Views: 9006

Re: Pause and Resume a Macro?

I'd use an OnEvent>key_down that goes to a subroutine that sets a flag variable. When the script is at a point where it can stop, test for the value of the flag variable. If the flag variable is set to pause, go to a modal message that says close this message to continue. Also reset the flag variabl...
by JRL
Thu Sep 05, 2024 2:26 pm
Forum: Beginners
Topic: Cannot Get WaitWindowOpen to work
Replies: 3
Views: 1633

Re: Cannot Get WaitWindowOpen to work

:D
by JRL
Wed Sep 04, 2024 3:30 pm
Forum: Beginners
Topic: Cannot Get WaitWindowOpen to work
Replies: 3
Views: 1633

Re: Cannot Get WaitWindowOpen to work

Here is a possible replacement for the built in WaitWindowOpen> function. Depends on whether or not your window shows up using GetWindowList>. If you want to wait a long time or forever, enter a big number for the timeout. Modify as needed. //GoSub>srtWaitWindowOpen,Criteria (Case Sensitive),Timeout...
by JRL
Thu Aug 29, 2024 2:15 pm
Forum: Beginners
Topic: Open Application With File
Replies: 4
Views: 2203

Re: Open Application With File

What happens if you rename the file by slapping a .PUB on the end of it then run ExecuteFile> :?:
by JRL
Wed Aug 21, 2024 1:22 pm
Forum: Beginners
Topic: OnEvent
Replies: 8
Views: 5187

Re: OnEvent

Dorian wrote:...and causing Excel to be "busy".
I don't have time to test but if multiple usage is the problem, might SHARING the files alleviate the issue?
by JRL
Thu Aug 15, 2024 1:26 pm
Forum: Enhancement Suggestions
Topic: Run As Administrator
Replies: 0
Views: 2395

Run As Administrator

I find myself writing more and more scripts that require admin privileges to run. After the script is working I will almost always compile it then right click the executable in Windows Explorer and choose the "Run as administrator" menu item. Problem is that while creating the script I have to do th...
cron
Sign up to our newsletter for free automation tips, tricks & discounts