Free Code Snippets in C#, Net Framework, Office 365, ASP.Net,WPF, Visual Studio, SQL Server, Antivirus free
#
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 44
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

Addin: vba code Office-365/Excel/Add--in
Addin: vba code
07.09.2018 75
Excel vba code for the add-in Function of the code

Exel file with system addin as Template Office-365/Excel/Add--in
Exel file with system addin as Template
07.09.2018 67
This article discusses an Excel help tool that allows you to create simple Excel input forms The Excel file has green input fields, which should serve as input navigation as with the tax office All other areas are automatically locked by the Excel add-in

Excel Addin: Creating a Ribbonbar Buttons for a vba Excel Addin Office-365/Excel/VSTO-Addin
Excel Addin: Creating a Ribbonbar Buttons for a vba Excel Addin
06.09.2018 77
Excel Addin: Creating a Ribbonbar Buttons for a vba Excel Addin How to create a button in Excel's Ribbonbar from the vba code in an Excel Addin Task: For an existing Excel Addin, a button should be created, which is generally used in the toolbar or Ribbonbar of Exce

Remove custom toolbars Office-365/Excel/VSTO-Addin
Remove custom toolbars
06.09.2018 61
Remove custom toolbars How to remove the custom toolbars in VSTO Addins? Problem: If I create an addin for Excel in Visual Studio under Vsto Office, then in 2016 the new Ribbon will show the area "Custom Toolbars" in front of the actual Ribbonbar areas an old problem

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 119
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 74
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

Excel: Move cursor with arrow key Office-365/Excel/Tutorials
Excel: Move cursor with arrow key
23.01.2018 397
In Microsoft Excel, when you press the arrow keys, the sheet moves and the input cursor does not jump from cell to cell, then this is due to the key: scrolls on the keyboard On: When the roll is on, the Excel sheet shifts Off: When scroll

Excel: Copy cells without empty lines Office-365/Excel/Tutorials
Excel: Copy cells without empty lines
08.01.2018 328
How to copy a block in Microsoft MS Excel and pass only the cells with values without empty lines and cells? For this you mark the area which you want to copy without empty cells Then take Ribbonbar-> Start-> Filter

Excel: Text Like function Office-365/Excel/Formulas
Excel: Text Like function
08.01.2018 347
Task: A formula that allows you to check a text for the occurrence of a search text or term In vba this is the formula LIKE Solution: Formula = ISNUMBER (FIND ("balance"; B3)) In the display in E

Excel: Determine a substring from text with Formulas Office-365/Excel/Formulas
Excel: Determine a substring from text with Formulas
08.01.2018 295
Excel: Determine substring from text If you want to determine a certain text from a cell from long Excel lists, then you use several formulas The best way to create the result of several steps If you want to calculate the number a

Excel PowerQuery: Rename Columns Office-365/Excel/Powerquery
Excel PowerQuery: Rename Columns
18.12.2017 398
How to rename columns in the MS Excel Powerquery The Powerquery in Excel contains connections and data copies of linked databases If you want to customize columns and fields of a linked table in Excel, then you can do this in Excel in the PowerQuery

Dynamically evaluate Access with Excel Office-365/Excel
Dynamically evaluate Access with Excel
17.11.2017 476
This article shows how to evaluate MS Access data dynamically in local MS Excel files Data evaluations in MS Access can no longer be evaluated using an integrated Pivot, PivotTable, PivotChart The evaluation via ActiveX charts is also no longer maintained

Excel: Switching the data connection to another database Office-365/Excel
Excel: Switching the data connection to another database
16.11.2017 634
This example shows how to change the data connection to another database at runtime in an Excel file In Microsoft Excel, data from Access databases can be attached using the Data Connection Manager If you set up a data connection to an MS Access database her

Excel, vba: insert image into a cell of cache Office-365/Excel/Code-vba-Makro
Excel, vba: insert image into a cell of cache
31.10.2017 516
Excel, vba: insert image into a cell of cache This command adds a bitmap image to a special cell in Microsoft Excel in Excel Excel Sheet Paste Destination '

Excel Message: Parts of your document may contain personal information Office-365/Excel
Excel Message: Parts of your document may contain personal information
30.10.2017 453
If I want to save my Excel file, then always comes between this message: Caution: Parts of your document may contain personal information that can not be removed from the document review What does it mean and how do I get it away again

Excel: Barcode by Excel Insert macro code into cells Office-365/Excel/Formulas
Excel: Barcode by Excel Insert macro code into cells
20.10.2017 657
This example contains an Excel file with a macro code, which can be used to supplement any existing Excel document with an additional barcode of type 39 The barcode is generated purely by a vba code in the background, whereby always a small barcode is drawn into

Excel Macro Formulas for calculation Office-365/Excel/Formulas
Excel Macro Formulas for calculation
20.10.2017 385
Example how to calculate complex formulas in Microsoft Excel Tutorial

Excel: Enter values ​​from your own function formula Office-365/Excel/Formulas
Excel: Enter values ​​from your own function formula
20.10.2017 458
In MS Excel, you can write your own functions and computations in the vba macro code, and output them in the Excel sheet by means of a formula

Simple list of all Ribbonbar icons with OfficeIconID Office-365/Excel/VSTO-Addin
Simple list of all Ribbonbar icons with OfficeIconID
14.03.2017 1142
From Office 2016 FluentID wordcontrols xlsx (search via CTRL + F) _3DBevelOptionsDialog _3DBevelPictureTopGallery _3DDirectionGalleryClassic _3DEffectColorPickerClassic _3DEffectColorPickerMoreClassic _3D

Office Icons: List of icons for the Ribbonbar Office-365/Excel/VSTO-Addin
Office Icons: List of icons for the Ribbonbar
14.03.2017 851
List of all icons for the Ribbonbar Office 2016 Fluent UI Office 2016 Help Files: Office Fluent User Interface Control Identifiers Office2016FluentUserInterfaceControlIdentifiers Under Download directory When you d

Excel: Converting XML to simple text pairs Office-365/Excel/Templates
Excel: Converting XML to simple text pairs
13.03.2017 674
Excel: Converting XML to simple text pairs Task: Convert structured XML lines to simple text with value pairs In XML, you often find a collection of values ​​on the smallest node level However, nesting with XML is difficult to read

Excel Pivot: Marking areas and Activate Selection Office-365/Excel/Pivot
Excel Pivot: Marking areas and Activate Selection
03.03.2017 402
Excel Pivot: Marking areas and no more To mark entire columns or fields in an Excel pivot, move the pointer over an Excel pivot element This displays a small arrow If you click on this, the complete Pivote element will be displayed If this ma

Excel: Merge multiple cells multiline Office-365/Excel/Formulas
Excel: Merge multiple cells multiline
06.02.2017 394
Excel: Merge multiple cells multiline How can you summarize multiple cells in Microsoft Excel as a multi-line text in a formula cell? I need a summarized in Excel, which summarizes the address data of people and separates the texts with a line break Solution:

Excel Addin: create a Ribbonbar via VSTO Addin Office-365/Excel/VSTO-Addin
Excel Addin: create a Ribbonbar via VSTO Addin
25.01.2017 1655
Excel Addin: create a Ribbonbar via VSTO Addin How to create a custom Ribbonbar in the menu under Microsoft MS Excel, which performs functions and tasks of Excel Task: Create a Ribbonbar for Excel Create project A custom menu bar or

Note: Installing the English Office Developer Tools for Visual Studio VSTO Office-365/Excel/VSTO-Addin
Note: Installing the English Office Developer Tools for Visual Studio VSTO
25.01.2017 1555
Note, Log Delay: Installing the English Office Developer Tools for Visual Studio VSTO Problem: When you use the German Office Excel and Word 2010, 2013, 2016 applications and accesses through a Visual Studio Addin, Created by the various CultureInfo states The Inte

Note: What is Interop and PIA in Microsoft Office Office-365/Excel/VSTO-Addin
Note: What is Interop and PIA in Microsoft Office
25.01.2017 1898
Note: What is Interop and PIA in Microsoft Office Log Record Note: Which files contain the interface code from VSTO Apps to Office applications The problem: VSTO applications show the error: HRESULT 0x80028018 InteropServices COMException Reason

Excel VSTO Addin: Error HRESULT 0x80028018 InteropServices.COMException: Old format or invalid type library Office-365/Excel/VSTO-Addin
Excel VSTO Addin: Error HRESULT 0x80028018 InteropServices.COMException: Old format or invalid type library
25.01.2017 1268
Excel VSTO Addin: Error HRESULT 0x80028018 InteropServices COMException: Old format or invalid type library Problem: When reading values ​​in MS Excel from a VSTO application, an error occurs: System Reflection TargetInvocationException with the detail message that an old form

Excel: 2nd axis, secondary axis Office-365/Excel/Chart
Excel: 2nd axis, secondary axis
21.11.2016 1231
Excel: 2nd axis, secondary axis If you want to display multiple lines at the same time on a diagram, with a line in a completely different number range, It is recommended to activate the secondary axis on the right side of the table This second Y-axis is only

Excel pivot: join multible tables Office-365/Excel/Pivot
Excel pivot: join multible tables
14.06.2016 1508
Excel pivot: join tables How to create a PivotTable that is composed of several related individual data tables As a video tutorial: In this case two pivot tables is displayed

Mobile

.

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