Freelance Project Requests info@CodeDocu.de Software Development in C# WPF Asp.Net Core Vba Excel Word SQL-Server EF Linq, UWP Net
#
Excel: REwrite RTF to HTML Office-365/Excel/Code-vba-Makro
Excel: REwrite RTF to HTML
23.04.2020 546
The following format enumerations are used to convert characters to HTML in RTF: In case of double underlines XlUnderlineStyle: xlUnderlineStyleDouble -4119 Double fat underline xlUnderlineStyleDoubleAcco

Excel Instructions: Remove Duplicate Rows, Remove Duplicates Office-365/Excel/Tutorials
Excel Instructions: Remove Duplicate Rows, Remove Duplicates
22.04.2020 454
Remove duplicate rows , remove duplicates To remove duplicate rows or unnecessary lines: You select a range or table in Excel Then Excel->Menu-> Data -> Remove duplicates Then you can select the columns after which you want

Excel template for sending emails from a table, version 51 Office-365/Excel/Templates/Emails
Excel template for sending emails from a table, version 51
17.03.2020 2831
Excel template for sending emails from a table Version 51a: Sender email isposted e This Excel template creates emails in Outlook using an Excel spreadsheet The email addresses are taken from the table row and iterate through the row The Te

solved Microsoft Teams: Sign in Unfortunately, we couldnt sign you in. Office-365/Other-Software/Teams
solved Microsoft Teams: Sign in Unfortunately, we couldnt sign you in.
17.03.2020 427
Microsoft Teams: Sign in Unfortunately, we couldn't sign you in AADSTS9000411: The request is not properlyformatted The parameter login_hint is duplicated Registration with teams remains at the openoffice with: Loading MicrosoftTeams Solution:

Excel grouping from top to bottom Office-365/Excel/Tutorials
Excel grouping from top to bottom
02.03.2020 468
Excel grouping from top to bottom How to flip the grouping sign from bottom to top in Excel when opening in standard mode excel displays the grouping character below the grouping In theclosed state, the grouping character is below the hidden area

Excel template:  Send emails in a list of send field, placeholders, and attachments Office-365/Excel/Templates/Emails
Excel template: Send emails in a list of send field, placeholders, and attachments
26.02.2020 1109
New Version is at: Send emails to a list As an example, send an info to a class list Only the emails that an X has in the Send column are sent In addition, you can exchange the text in the email with placeholders as [@Name] is replaced by Po

Automatically adjust Access forms to the maximum monitor size Office-365/Access/Basics/vba-Code
Automatically adjust Access forms to the maximum monitor size
03.02.2020 1193
the following vba code example shows how to automatically customize Microsoft Access Database forms to the maximum width of the current monitor All controls such as text box or label elements are moved to the corresponding positions at run time and adjusted i

Excel: Convert numbers, date and time to text Office-365/Excel/Code-vba-Makro
Excel: Convert numbers, date and time to text
14.01.2020 589
How to convert entire columns or ranges in Excel from numbers, date or time format to real text

Excel : Convert numbers to text Office-365/Excel/Formulas
Excel : Convert numbers to text
10.01.2020 530
The following example shows how to convert numbers to text in Microsoft Excel The problem is that SAP used to output numbers such as personnel numbers or accounts in Excel as text You could see it by the fact that the numbers were displayed left-aligned in Excel Since

ok Timestamp  Access Write conflict:  This record has been modified by another user since editing began Office-365/Access/Errors
ok Timestamp Access Write conflict: This record has been modified by another user since editing began
07.01.2020 679
ok Timestamp Access Error Message: Write conflict: This record has been modified by another user since editing began Error message

Excel: Calculate total statistical frequency number of texts Office-365/Excel/Templates/Calculations
Excel: Calculate total statistical frequency number of texts
07.01.2020 485
How can I determine the total number as the frequency of a value in Excel? How often does a value occur? Exceltrick: with the Shift+Ctrl+Enter key, a matrix function is entered in the formula entry as curly braces

Excel Formula: Calculation Performance of a Resistance at a Voltage Office-365/Excel/Templates/Calculations
Excel Formula: Calculation Performance of a Resistance at a Voltage
06.01.2020 489
Electric formulas Excel file as a download as a file Green fields are input fields

Access Error: Data Type Conflict in Criteria Expression Office-365/Access/Errors
Access Error: Data Type Conflict in Criteria Expression
11.12.2019 536
Error message Data type conflict in criteria expression Errors in formula:

Access Error: #Number or Overflow Office-365/Access/Errors
Access Error: #Number or Overflow
11.12.2019 498
Access Error: #Zahl Error message: Simple Microsoft Access queries may cause the error to occur with the number or overflow Cause: The cause of the message is an incorrect formula If in a formula 0 is divided by a divider, this results in a mathemat

Excel: Timesheet Calendar as Download Template Office-365/Excel/Templates/TimeSheet
Excel: Timesheet Calendar as Download Template
11.12.2019 472
Excel: Timesheet Calendar Write Calendar write-off template in projects As an Excel template If you have any questions or suggestions about vba: raimund popp@comline-se de The file is a simple template on how to perform the month

Access Solution: Query is corrupted, Runtime Error 3340 Office-365/Access/Errors
Access Solution: Query is corrupted, Runtime Error 3340
10.12.2019 721
This error will appear in late 2019 for some Microsoft Access databases The error occurs when a table is to be updated Display of the error in vba Vba Error: The error occurs when a table is updated directly

Access: Import and Read Excel file automatically Office-365/Access/vba/Code-Examples
Access: Import and Read Excel file automatically
09.12.2019 553
Access: Read Excel file automatically The following vba code example shows how to automatically import complete Excel files under Microsoft Access

Access vba  code: Print a form directly with printer selection Office-365/Access/vba/Code-Examples
Access vba code: Print a form directly with printer selection
09.12.2019 471
With this vba code you can print an Access form directly, where by the time the printer selection appears, but no preview view is displayed

Access error message: Could not delete from specified tables Office-365/Access/Fehler
Access error message: Could not delete from specified tables
07.12.2019 473
Error message when running a data delete query Could not delete from specified tables The error comes with Microsoft Access queries when trying to delete data from connect

Excel : Encoding values with HASH functions SHA256 Office-365/Excel/Templates
Excel : Encoding values with HASH functions SHA256
04.12.2019 5954
Applies to Microsoft Excel, Access Word Outlook PowerPoint, Secure Encryption The following file encodes text with the SHA256 hash into encrypted values To do this, the appended code is inserted into vba macro You can use the Excel function to =get

Resolved: Excel vba Run-time error -2146232576 (80131700) Automation error Office-365/Access/Errors
Resolved: Excel vba Run-time error -2146232576 (80131700) Automation error
04.12.2019 1491
When using hash functions in Microsoft applications, vba Macro Code displays the error shown as soon as you get to the line: Set Encoder = CreateObject("System Text UTF8Encoding")

Excel : Anonymizing and pseudonymizing numbers Office-365/Excel/Templates
Excel : Anonymizing and pseudonymizing numbers
04.12.2019 483
With a simple vba function Download with Excel File as an example The following Excel file anonymizes data based on a unique random number Anonymization: Anonymization changes sensitive critical data to another non-easily derived new replacemen

Anonymizing and pseudonymizing data with Acess or Excel Office-365/Access/vba/Code-Examples
Anonymizing and pseudonymizing data with Acess or Excel
04.12.2019 525
In Microsoft Access, Random, Anonymous, Pseudonym, Easy conversion to functions ID number without hash in vba In the following demo database, important data is anonymized and pseudonymized This means that for important numbers, non-traceable other numbers are ins

Issue: Microsoft Office programs are not recognized in File Explorer Office-365/Access/Fehler
Issue: Microsoft Office programs are not recognized in File Explorer
04.12.2019 480
On my new computer, the Microsoft Access programs or files are not recognized This means that all files ending in accdb will not be recognized Although the program Microsoft Access itself exists in Windows Start and in the Taskbar and starts without any p

How To Hide the new Column in Microsoft Access Table Office-365/Access/Basics/Tables
How To Hide the new Column in Microsoft Access Table
04.12.2019 485
How to hide the [Add New Column] in Microsoft Access in the Table Design To do this in Menu->Options->Current Database The setting: Enable design changes for tables in datasheet view ->Turn off Then close and

Excel: Replace text in a selected area Office-365/Excel/Tutorials
Excel: Replace text in a selected area
26.11.2019 467
Guide: I want to change text in the cells of a defined Excel range How do you do that? You mark the area in Excel Then Ctrl+H for the Search and Replace dialog In Find What: Enter the search text In Replace with: enter the n

Excel: Convert letters to Ascii numbers around Office-365/Excel/Code-vba-Makro
Excel: Convert letters to Ascii numbers around
26.11.2019 490
Excel: Convert letters to Ascii numbers around Here you will find a code with which you can convert letters into numbers in Excel In the example, A becomes 1 , B->2, C->3 The vba code is for copying and an example file in the appendix

Excel function: find the position in a column or row Office-365/Excel/Formulas
Excel function: find the position in a column or row
26.11.2019 458
Actually, the function comparison (search text; search area,1) But the formula always leads to a problem in vba Excel That's why I simply rewrote the function here with =get_First_Match(SearchText; search area) The function, the code is below for copy

Excel: Find text in a value Office-365/Excel/Formulas
Excel: Find text in a value
07.11.2019 489
Excel: Find text in a value the formula finds the text position in which a text or character occurs The difference is =SEARCH and =FIND in whether case is case sensitive =SEARCH("a"; B4)

Excel: Count how often a value occurs Office-365/Excel/Formulas
Excel: Count how often a value occurs
07.11.2019 482
With the formula = COUNTIF (B:B;" =" & B6)

Mobile

.

Contact for Jobs, Project Requests: raimund.popp@microsoft-programmierer.de