Freelance Project Requests info@CodeDocu.de Software Development in C# WPF Asp.Net Core Vba Excel Word SQL-Server EF Linq, UWP Net
#
Word: how to switch the comma to Always Top Office-365/Word/Tutorials
Word: how to switch the comma to Always Top
07.01.2021 37
To do this, you must click File>Options in The Word Menu Then: Word Options->Document Check-> AutoCorrect Options ->AutoCorrect> Autoformat as you type And in During the input replace OFF "Straight" quotation marks

Excel Template: Hours Written Down Office-365/Excel/Templates/TimeSheet
Excel Template: Hours Written Down
07.12.2020 92
With this Excel template you can easily record the hours at work hours, projects, construction sites, orders And list them as hourly amounts The duration of each task is output as a proportion of hours and is not decimally The template is available for

Errorcode 450 Using Email.Session.Accounts Email_From Office-365/Excel/Code-vba-Makro
Errorcode 450 Using Email.Session.Accounts Email_From
16.11.2020 122
Code 450: For the user of the code: objEmail Session Accounts(sEmail_From) Error: 450 Description : "Incorrect number of arguments or invalid assignment to a property" : String : modEmail Send_Email_to_Address Solution: 1) enter eithe

Send Serial Emails from Excel List with Word Template and Attachements Version 54 Office-365/Excel/Templates/Emails
Send Serial Emails from Excel List with Word Template and Attachements Version 54
06.11.2020 426
Download links in right side yellow corner: Send emails with Excel This Excel file provides a list in which you can insert email addresses and then automatically send them to all participants using Microsoft Outlook The text for the email is taken from the enclose

Open and Read a Word File with Excel Office-365/Excel/Code-vba-Makro
Open and Read a Word File with Excel
06.11.2020 140
Vba Code Beispiel: mit Excel ein Word Dokument lesen In Word Makro ist der Code : Dim app_Word As New Word Application Dim doc As Word Document Set doc = app_Word Documents Open (sWord_Filepath, ReadOnly:=True, Visible:=False) doc Content Cop

Word template for inserting von photos Version 55 Office-365/Word/Macro/Import-Photos-into-Word
Word template for inserting von photos Version 55
04.11.2020 340
This Word template does the following: By clicking on the Insert Photos button you can select photos from the local drive and they will be inserted into the templates block The file is inserted into the [Filename] field as a file name plus a sequential image nu

Vba Code: Copy template area Office-365/Word/vba
Vba Code: Copy template area
04.11.2020 104
Vba Code: Copy template area This Word template does the following: It copies the range table below [template] and pastes it to the area before the ID Vba Code 1 &n

Vba Code: Platzhalter finden und ersetzen Office-365/Word/vba
Vba Code: Platzhalter finden und ersetzen
04.11.2020 83
Der vba Code sucht einen Platzhalter Text im Word Document und ersetzt diesen durch einen anderen Text Gezeigt wird: Durchlaufen aller Words in einem Word Dokument Den gefundendenen Text als Paragraph auswählen Range Object aus dem Satz bilden Ersetzten

Excel: REwrite RTF to HTML Office-365/Excel/Code-vba-Makro
Excel: REwrite RTF to HTML
23.04.2020 671
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 567
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 3476
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 537
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 584
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 1591
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 1778
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 695
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 646
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 812
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 576
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 584
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 633
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 596
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 566
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 848
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 673
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 593
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 581
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 8743
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 2303
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 660
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

Mobile

.

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