|
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
|
|
Office-365/Excel/Add--in
Addin: vba code
|
07.09.2018 75
|
|
Excel vba
code for the add-in
Function of the code
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
'
|
|
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
|
|
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
|
|
Office-365/Excel/Formulas
Excel Macro Formulas for calculation
|
20.10.2017 385
|
|
Example how to calculate complex formulas in Microsoft
Excel
Tutorial
|
|
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
|
|
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-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
|
|
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
|
|
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
|
|
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:
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|
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
|
|