Free Code Snippets in C#, Net Framework, Office 365, ASP.Net,WPF, Visual Studio, SQL Server, Antivirus free
#
Send email from Excel and Access Office-365/Access/Controls
Send email from Excel and Access
22.11.2017 2
The example shows how to send an email directly in Microsoft Access, Excel or other MS Office programs Here you use the axEmail_Send component, which can send emails directly from the program The component is written in vb net Framework 4 6 and c

Dynamically evaluate Access with Excel Office-365/Excel
Dynamically evaluate Access with Excel
17.11.2017 18
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

Word Photo Template for Photo Documentation Office-365/Word/Macro/Import-Photos-into-Word
Word Photo Template for Photo Documentation
17.11.2017 14
into table with input fields in the main area This Word template is used to automatically insert photos from a large photo collection into a spreadsheet in Word, cutting the photos to a maximum length and saving the photos as memory-optimized thumbnails

Excel: Switching the data connection to another database Office-365/Excel
Excel: Switching the data connection to another database
16.11.2017 19
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 32
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 '

ActiveX Barcode 39 Control for Excel Access Word Office-365/Office/COM-Controls
ActiveX Barcode 39 Control for Excel Access Word
30.10.2017 37
Access, Excel Barcode Control Barcode39 Control In Ms Access In Microsoft Ms Access, ActiveX Control is inserted directly into a form Subsequently, the barcode control can convert a text into a barcode39 via vba code

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

Project template for an ActiveX control Office-365/Office/COM-Controls
Project template for an ActiveX control
30.10.2017 34
Project template for an ActiveX control The following is a complete COM Interop project consisting of a Visual Studio 2017 project and a Microsoft Access database and MS Excel file, which show the integration of the usercontrol as an ActiveX control

Email Send Control for Office applications Office-365/Office/COM-Controls
Email Send Control for Office applications
28.10.2017 30
ActiveX COM Control in Net Framework 4 for Office applications With the Email_Send4 component you can send emails directly from Microsoft Access, Word or Excel without having to press a confirmation from Outlook Here is an example in MS Acess 2016

COM: Run-time error 2147024894 80070002 automation error The system can not find the specified file Office-365/Office/COM-Controls
COM: Run-time error 2147024894 80070002 automation error The system can not find the specified file
26.10.2017 53
Occurs when an ActiveX COM file has been registered incorrectly Registration was done with Regasm Run-time error '-2147024894 (80070002)': automation error The system can not find the specified file

COM Error: DllRegisterServer entry point Error message when registering an ActiveX COM DLL Office-365/Office/COM-Controls
COM Error: DllRegisterServer entry point Error message when registering an ActiveX COM DLL
26.10.2017 40
COM Error: DllRegisterServer entry point Error message when registering an ActiveX COM DLL Error message: DllRegisterServer entry point Error message: when registering an ActivX component: T

Code: Create your own ActiveX Component in Visual Studio 2017 and Office 2016 365 Office-365/Office/COM-Controls
Code: Create your own ActiveX Component in Visual Studio 2017 and Office 2016 365
22.10.2017 57
Template: ActiveX in Visual Studio 2017 and Office 2016 365 This example provides the code and files as a template for creating your own ActiveX component for Office applications The project is available for download as files Below is the code for the Use

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 46
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 58
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 42
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

MS Office Access: Sending emails directly from the Office application without Outlook Office-365/Office/COM-Controls
MS Office Access: Sending emails directly from the Office application without Outlook
18.10.2017 37
If you want to send emails directly from a Microsoft Office application, then you must go back to an email sending client As a rule, Outlook is used as a remote object This example uses a NET client that directly sends the emails without using

Access: Sending emails directly from the database Office-365/Access/Emails
Access: Sending emails directly from the database
10.10.2017 51
Included as Outlook Code example in vba Programming You can send emails directly into Microsoft Access databases All you need is an e-mail address, an e-mail subject and an e-mail For this, it is recommended to use

Word macro: Insert all photos from input folder with macro Office-365/Word/Macro/Import-Photos-into-Word
Word macro: Insert all photos from input folder with macro
26.07.2017 151
Word file docm with macro in background Video Tutorial When you open the document, you only have to enter the directory path to the image folder in the Word input field And then go to the Developer Tools-> Macros t

Word Template: Read the complete photo folder to base path and folder name Office-365/Word/Macro/Import-Photos-into-Word
Word Template: Read the complete photo folder to base path and folder name
25.07.2017 117
In the included Word template with macro it is that subdirectories from a base path are automatically imported as photos The base path and the directory name are entered in the Word file and then the Start button is pressed The button itself is deleted and the p

Manually converting WPF, Winforms to UWP Net-Framework/Windows-Store/Bridge
Manually converting WPF, Winforms to UWP
20.07.2017 176
Manually converting WPF, Winforms to UWP Instructions Tutorial # Bridge, Win32, Convert, DAC, WPF, WinForms Steps: Step 1: Expand the solution project New project Mark the Windows 32 Solution in the

Microsoft Word Error: The memory process failed because there is not enough memory Office-365/Word/Errors
Microsoft Word Error: The memory process failed because there is not enough memory
16.06.2017 133
error message The memory operation failed because there is not enough memory or memory space Reproduction: if you save the document in Word as a htm file, formatting that is not visible after individual lines can prevent the memory process

Word vba: find current sentence Office-365/Word/vba
Word vba: find current sentence
24.05.2017 177
The following example shows how to find the current position in Word in MS Word vba This allows you to find the current block, paragraph, table, block, and mark, copy or delete it The current element is always searched via Selection Range InR

Word vba: Change document property title dynamically with Textbox Control Office-365/Word/vba
Word vba: Change document property title dynamically with Textbox Control
24.05.2017 188
Sample code to change the Title value as a variable in Word with a Textbox Control In Word you can import and modify internal and user-defined variables directly in the document Internal variables can be externally best with Title If yo

Word Code: Edit photos and controls in vba Office-365/Word/vba
Word Code: Edit photos and controls in vba
24.05.2017 147
Vba Code to import complete photo directories into a photo documentation Contains Wordcode for: - Insert photos into a Word file - Customize the sizes of photos and images in Word - File dialog under Word - Button and textb

Word Template: Import photo documentation as a photo directory Office-365/Word/Macro/Import-Photos-into-Word
Word Template: Import photo documentation as a photo directory
24.05.2017 181
In this Word template, a complete photo folder is imported as adapted photos into a new Word document and automatically adapted All photos, which are in the selected folder are selected by selection The Word file is then saved as Word Photo documentation

Word Template: Photo Documentation Office-365/Word/Macro/Import-Photos-into-Word
Word Template: Photo Documentation
12.05.2017 166
1 Column, Design you own header, Photos insert, With the Word template shown here, you can create an automatic photo documentation in Word You only have to adjust the original according to your wishes Save the file and double-click it or double-click it at

Export Access Table direct to Excel Office-365/Access/Access--Excel
Export Access Table direct to Excel
05.05.2017 155
This demo gives a table directly in Access to Excel Output large amounts of Access data to Excel using CopyFromRecordset? Task: • I want to output a large amount of data, about 3000 records directly to Excel In Access you can do this via TransferSpeadsheet, but I would lik

Word Template: Import a photo directory into a Word document Office-365/Word/Macro/Import-Photos-into-Word
Word Template: Import a photo directory into a Word document
04.04.2017 144
This Word template does the following: clicking on the button Import Photos from Folder opens a file dialog, which can preview photos In the dialog select a folder and then the complete directory is inserted into Word as space-saving photo images The photo

Word Addin: Insert the clipboard as an image with a specific width Office-365/Word/Add--In
Word Addin: Insert the clipboard as an image with a specific width
28.03.2017 194
What does this code example do? Insert the clipboard as an image with a certain width Video instructions:

Insert the temporary storage as an image with a width of 19 centimeters Office-365/Word/Macro
Insert the temporary storage as an image with a width of 19 centimeters
28.03.2017 155
Content: With this vba macro code you can insert the current clipboard clipboard as an image in Microsoft Word At the same time the size is adapted to the width of 19 centimeters and a frame drawn  

Mobile

.

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