Automatically fill in functions when you open Word
28.07.2021 190
How to
automatically perform work when Word is opened
guide:
To do this, open
Word,
then Alt-F11 -> switch to Macro Editor
1
Change
in the project area
to : Normal ->Microsoft Word Objects
->This
Sign PDF digitally with a signature
23.07.2021 204
How to simply
sign a PDF document with a signature on the computer without printing
guide:
For this you need
the program Adobe Acrobat Reader and a signature as a photo
Step 1: Install Acrobat Reader
Under Windows 10
you go to the page
File chooser dialog can only be shown with a user activation
16.07.2021 1534
Javascript:
The error message
File chooser dialog can only be shown
with a user activation
Displayed when
you try to open a file dialog in Javascript by clicking
Open file dialog
via javascript click()
Format Excel Data as Data Bars
13.07.2021 172
Setting Excel Data Bars
If you want to
display values as data bars in Excel, you can create this function with menu
> Conditional
Formatting
The easiest way
is to select directly in the drop-down selection: Data bar >Colored fill and
then Red data bar as the default selection
Access error message: The search key was not found in any record
24.06.2021 157
The operation is
aborted
If the message
comes in the Microsoft Access database that no search key has been found, then
it is often internal problems with complex queries
Internally, there
are complex queries that use multiple table connections
solution:
troubleshooting access error message: 3043 unrecognized file format or network error
22.06.2021 242
troubleshooting
access error message: 3043 unrecognized file format or network error
Run-time error ' 3043 ' Your network access was interrupted To continue, close th
Excel Macro Code: Divide text into columns with a maximum of 132 characters
08.04.2021 386
Excel Macro:
Divide text into columns with a maximum of 132 characters,
where words must
not be separated
Option
Word showing and hiding areas ranges with .collapse
07.04.2021 345
Word template for
showing and hiding areas
The following
Word template does the following
When you click on
the checkbox ❎Does not hit the following table area, the rows are hidden
When you click on
the checkbox field ❎ Hits to, the hidden
table area appears again
In the background
runs a vba macro (code is attached below) that hides an area with
Selection Collapse
Shown: Word
Collapse
Excel template: Calculate frequency and capacity from LC swing circuit
18.03.2021 281
In this Excel
template you can calculate the required inductance, capacity or the resulting
frequency from an LC swinging circuit
|