Search found 14783 matches

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: 620

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: 391

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: 397

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: 339

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: 464

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.
by jvierra
Mon Apr 19, 2021 1:12 pm
Forum: PowerShell
Topic: API Key security
Replies: 3
Views: 464

Re: API Key security

I thi8nk you want to convert the token and not the ID. A token is usually only good for one session so it cannot be persisted and reused. Check the documentation for teh API to understand how they use tokens and how to use them.
by jvierra
Mon Apr 19, 2021 11:53 am
Forum: PowerShell GUIs
Topic: Adding child nodes to treeview programmatically
Replies: 4
Views: 602

Re: Adding child nodes to treeview programmatically

I know it is not explicit but "tree" means nodes within nodes. It is an old structural reference meaning that things are arranged in a hierarchy that branches. Also the MSDN documentation is always where to go for detailed information about all controls as there are all properties and methods listed...
by jvierra
Thu Apr 15, 2021 5:14 pm
Forum: PowerShell GUIs
Topic: Datagridview Filtering and operators in column name
Replies: 9
Views: 1334

Re: Datagridview Filtering and operators in column name

Here is how to search for a value in a column:
  1. $btnSearch_Click = {
  2.     $rows = $dgvProjects.Rows |
  3.         Where-Object{$_.Cells['OU'].Value = $textBox1.Text}
  4.     $rows | Write-Host
  5. }
by jvierra
Thu Apr 15, 2021 5:02 pm
Forum: PowerShell GUIs
Topic: Datagridview Filtering and operators in column name
Replies: 9
Views: 1334

Re: Datagridview Filtering and operators in column name

Unfortunately that is not what your code says. It says the column name comes from the search box. The column rows are filled with "Not Member".
by jvierra
Thu Apr 15, 2021 3:08 pm
Forum: PowerShell GUIs
Topic: Adding child nodes to treeview programmatically
Replies: 4
Views: 602

Re: Adding child nodes to treeview programmatically

The following tutorial will help you to learn how to use the TreeView control which is one of the most complex controls in the toolbox and is always a challenge for anyone who has limited or no experience with WinForms. Take time and try all of the example code until you understand what the control ...