Freelance Project Requests info@CodeDocu.de Software Development in C# WPF Asp.Net Core Vba Excel Word SQL-Server EF Linq, UWP Net
#
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 23
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 49
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 49
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 32
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 39
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 97
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 57
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 58
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 133
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 75
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 62
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 66
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 159
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 125
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 63
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 86
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 75
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 74
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 82
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 83
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 84
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 93
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 82
With the formula = COUNTIF (B:B;" =" & B6)

Error CS0103: The name ApplicationData does not exist in the current context Net-Framework/UWP-Universal-Windows-Plattform/Errors
Error CS0103: The name ApplicationData does not exist in the current context
01.11.2019 102
Error CS0103: The name ApplicationData does not exist in the current context Error message Name Value

Registration of the app failed. 0x80073CF3 Net-Framework/UWP-Universal-Windows-Plattform/Errors
Registration of the app failed. 0x80073CF3
01.11.2019 107
Registration of the app failed [0x80073CF3] Error message when creating the application: DEP0700: Registration ft he app failed [0x80073CF3] The Microsoft Programmer d WebCamonTop_2 2 22 0_x86__

Resize the photo and copy it to the clipboard Office-365/Word/Ribbonbar-Addin/Code-Examples
Resize the photo and copy it to the clipboard
27.10.2019 113
The following Code loads a photo, resizes it, and then copies it to the cache Background: in the code, you want to load a photo in Word using the Word addin Before it is pasted into the Word document, the photo is resized at run time, and then saved to the Word clipboard for

Change Excel Adress Z1S1 R1C1 row column to A1 Office-365/Excel/Tutorials
Change Excel Adress Z1S1 R1C1 row column to A1
25.10.2019 110
Excel -> Toggle column header from 1 2 3 4 5 to A B C In cell at the top left is: Z1S1 But I need the cell address: A1 File Options Reference type switching to File->Options->Formulas-> Z1S1 Reference Type :

Disable Button with Javascript on Sharepoint Buttons Office-365/Other-Software
Disable Button with Javascript on Sharepoint Buttons
24.10.2019 70
Create disable button on document You can adjust the button as follows Button disable in javascript let btn =

Expand Windows with a mobile phone or tab as a monitor Office-365/Other-Software
Expand Windows with a mobile phone or tab as a monitor
14.05.2019 434
How to use an Android phone smartphone or Android tablet as a monitor extension First, you have to install the app spacedesk (remote display) on the Android phone tab Then you have to install the free Spacedesk applicat

Words Control in Microsoft Word Dictation: Point New Line Office-365/Word
Words Control in Microsoft Word Dictation: Point New Line
07.05.2019 428
Characters and control words for Word dictation The following words can be used in Word diktat Point Come Question mark exclamation point Brace on, brace too

Mobile

.

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