Search found 14778 matches

by jvierra
Fri Apr 30, 2021 1:08 pm
Forum: PowerShell GUIs
Topic: Need some help with script for stopwatch
Replies: 5
Views: 651

Re: Need some help with script for stopwatch

Why are you creating all of those variables? The timer always holds the value. All you have to do is reset it when you start and then get the value after it stops.

I recommend reading the timer documentation to understand how timers work.
by jvierra
Thu Apr 29, 2021 10:56 pm
Forum: PowerShell GUIs
Topic: Connect-ExchangeOnline doesn't bring up MFA Capable browser based logonbox when executed from PowerShell Studio GUI
Replies: 9
Views: 1271

Re: Connect-ExchangeOnline doesn't bring up MFA Capable browser based logonbox when executed from PowerShell Studio GUI

Any code outside of any event will execute before the form is created. Normally I put code like that at the top of the edit pane before the form load event but it can be placed anywhere outside of and event code. The code entered will be executed in a top-down way in the order it is declared in the ...
by jvierra
Thu Apr 29, 2021 7:43 am
Forum: PowerShell GUIs
Topic: Timer
Replies: 2
Views: 298

Re: Timer

Here is a simple example of a countdown timer.
by jvierra
Thu Apr 29, 2021 7:39 am
Forum: PowerShell GUIs
Topic: Timer
Replies: 2
Views: 298

Re: Timer

If you search there are a number of good examples of stopwatch and countdown timers.
by jvierra
Thu Apr 22, 2021 3:31 pm
Forum: VBScript
Topic: Printing all worksheets in multiple excel files without opening each file
Replies: 2
Views: 468

Re: Printing all worksheets in multiple excel files without opening each file

Here is how to do this in Excel VBA with a good discussion of how the code works:

https://www.exceltip.com/printing-in-vb ... excel.html

The VBA script is mostly usable as VBScript.
by jvierra
Thu Apr 22, 2021 3:26 pm
Forum: VBScript
Topic: Printing all worksheets in multiple excel files without opening each file
Replies: 2
Views: 468

Re: Printing all worksheets in multiple excel files without opening each file

Since you are not a skilled scripter and since VBScript is obsolete I recommend using PowerShell as it will make the whole project much easier for anyone who is just starting to try and write a script. Also consider that the whole project can be done entirely in Excel using the same VB methods. You ...
by jvierra
Thu Apr 22, 2021 3:19 pm
Forum: PowerShell GUIs
Topic: clickable entries in RichTextBox
Replies: 2
Views: 364

Re: clickable entries in RichTextBox

I recommend using a ListView control as it has better support for links when displayed as a hierarchy.
by jvierra
Thu Apr 22, 2021 3:17 pm
Forum: PowerShell GUIs
Topic: Web Browser
Replies: 2
Views: 375

Re: Web Browser

When you start IE it will not stop the script from executing since it is a GUI app. "portqry" will block so it must be run as a job.

See: https://info.sapien.com/index.php/guis/ ... sive-forms
by jvierra
Thu Apr 22, 2021 3:13 pm
Forum: PowerShell GUIs
Topic: Adding German Language to project
Replies: 2
Views: 313

Re: Adding German Language to project

Place all of the strings in a file and change the file. Issue - string length and font affects. Since PowerShell is not MUI capable then there is no method I know to use MUI to dynamically alter the strings according to language. In console apps it is easy to just alter the strings at runtime by loa...
by jvierra
Mon Apr 19, 2021 4:16 pm
Forum: PowerShell
Topic: API Key security
Replies: 3
Views: 419

Re: API Key security

So what is not working? You cant use an encrypted string without decrypting it. In an EXE this would happen automatically if the strings are stored inside the code as a global.