Freelance Project Requests info@CodeDocu.de Software Development in C# WPF Asp.Net Core Vba Excel Word SQL-Server EF Linq, UWP Net
#
Excel Macro Code: Divide text into columns with a maximum of 132 characters Office-365/Excel/Code-vba-Makro
Excel Macro Code: Divide text into columns with a maximum of 132 characters
08.04.2021 38
Excel Macro: Divide text into columns with a maximum of 132 characters, where words must not be separated Option

Excel template: Calculate frequency and capacity from LC swing circuit Office-365/Excel/Templates
Excel template: Calculate frequency and capacity from LC swing circuit
18.03.2021 68
In this Excel template you can calculate the required inductance, capacity or the resulting frequency from an LC swinging circuit

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 269
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

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 296
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

Excel: REwrite RTF to HTML Office-365/Excel/Code-vba-Makro
Excel: REwrite RTF to HTML
23.04.2020 799
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 684
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 grouping from top to bottom Office-365/Excel/Tutorials
Excel grouping from top to bottom
02.03.2020 727
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: Convert numbers, date and time to text Office-365/Excel/Code-vba-Makro
Excel: Convert numbers, date and time to text
14.01.2020 833
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 795
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

Excel : Encoding values with HASH functions SHA256 Office-365/Excel/Templates
Excel : Encoding values with HASH functions SHA256
04.12.2019 12760
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

Mobile

.

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