Freelance Project Requests info@CodeDocu.de Software Development in C# WPF Asp.Net Core Vba Excel Word SQL-Server EF Linq, UWP Net
#
Excel code to turn the filter on and off after a cell Office-365/Excel/Code-vba-Makro
Excel code to turn the filter on and off after a cell
09.10.2021 925
Small Excel macro, with which you can automatically filter for the active cell via keyboard To do this, simply copy the code into the staff Step 1: Alt+F11 ->vba Code Step 2: Left pane Project >VBAProject (PERSONAL XLSB) Step 3: Co

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 1006
Excel Macro: Divide text into columns with a maximum of 132 characters, where words must not be separated Option

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 1405
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 1065
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 1567
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: Convert numbers, date and time to text Office-365/Excel/Code-vba-Makro
Excel: Convert numbers, date and time to text
14.01.2020 1973
How to convert entire columns or ranges in Excel from numbers, date or time format to real text

Excel: Convert letters to Ascii numbers around Office-365/Excel/Code-vba-Makro
Excel: Convert letters to Ascii numbers around
26.11.2019 1428
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 File Dialog for Selecting File-Paths to Worksheet Office-365/Excel/Code-vba-Makro
Excel File Dialog for Selecting File-Paths to Worksheet
09.10.2018 2074
Excel File Dialog: The following Excel macro code in vba creates a file dialog for an Excel file Several files can be selected and adopted as text Download: The code template is available for download under Codedocu de as Excel sample file or: Th

Excel Template: Automatically send an e-mail for a specific entry in Excel Office-365/Excel/Code-vba-Makro
Excel Template: Automatically send an e-mail for a specific entry in Excel
05.09.2018 2780
Excel Template: Automatically send an e-mail for a specific entry in Excel The following Excel document automatically sends an email when a specific value is entered in an input area If a value such as Test is entered in the input column B: B, then a standard email is

Excel vba: recognize an input in cells Office-365/Excel/Code-vba-Makro
Excel vba: recognize an input in cells
05.09.2018 2700
Excel vba: recognize an input in cells How to monitor the input in an excel sheet when changing a cell in a specific area solution You can examine the Worksheet Change on Target Range in Excel

Mobile

.

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