CodeDocu.com

#

Access vba Code Examples sevGrid Queries Basics Naming Forms Tables vba Code Recordset Fehler Errors Controls web Browser Listcontrol Option Box Combo Box Basic Controls Image Control Access-Excel Emails Ribbonbar Excel Code vba Makro Formulas Templates Emails Mail Merge Calculations Pivot Chart VSTO Addin Errors Code Examples Powerquery Tutorials Add-in Office Office develop COM Controls OneDrive Cloud Programming setup cloud Other Software Outlook Visio Word vba Errors Tutorials Series Letter Macro Import Photos into Word Templates Ribbonbar Addin Errors Code Examples Add-In

Office-365/Excel/Formulas Excel: Find text in a value 07.11.2019 29 Excel: Find text in a value the formula finds the text position in which a text or character occurs The difference is =SEARCH and =FIND in whether case is case sensitive =SEARCH("a"; B4) Office-365/Excel/Formulas Excel: Count how often a value occurs 07.11.2019 14 With the formula = COUNTIF (B:B;" =" & B6) Net-Framework/UWP-Universal-Windows-Plattform/Errors Error CS0103: The name ApplicationData does not exist in the current context 01.11.2019 39 Error CS0103: The name ApplicationData does not exist in the current context Error message Name Value Net-Framework/UWP-Universal-Windows-Plattform/Errors Registration of the app failed. 0x80073CF3 01.11.2019 45 Registration of the app failed [0x80073CF3] Error message when creating the application: DEP0700: Registration ft he app failed [0x80073CF3] The Microsoft Programmer d WebCamonTop_2 2 22 0_x86__ Office-365/Word/Ribbonbar-Addin/Code-Examples Resize the photo and copy it to the clipboard 27.10.2019 45 The following Code loads a photo, resizes it, and then copies it to the cache Background: in the code, you want to load a photo in Word using the Word addin Before it is pasted into the Word document, the photo is resized at run time, and then saved to the Word clipboard for Office-365/Excel/Tutorials Change Excel Adress Z1S1 R1C1 row column to A1 25.10.2019 42 Excel -> Toggle column header from 1 2 3 4 5 to A B C In cell at the top left is: Z1S1 But I need the cell address: A1 File Options Reference type switching to File->Options->Formulas-> Z1S1 Reference Type : Office-365/Other-Software Disable Button with Javascript on Sharepoint Buttons 24.10.2019 32 Create disable button on document You can adjust the button as follows Button disable in javascript let btn = Office-365/Other-Software Expand Windows with a mobile phone or tab as a monitor 14.05.2019 338 How to use an Android phone smartphone or Android tablet as a monitor extension First, you have to install the app spacedesk (remote display) on the Android phone tab Then you have to install the free Spacedesk applicat Office-365/Word Words Control in Microsoft Word Dictation: Point New Line 07.05.2019 336 Characters and control words for Word dictation The following words can be used in Word diktat Point Come Question mark exclamation point Brace on, brace too Office-365/Excel/Templates/Emails Series email with optional file attachment 27.01.2019 1545 corrected file version: 20190515 with optional attachements Series email with optional file attachment Office-365/Excel/Templates/Emails E-mails automatically with Excel vSend based on a data list 26.01.2019 1745 E-mails automatically with Excel vSend based on a data list The following email file sends emails to a data list, which they simply have to insert into the prepared data sheet as values The email text is a template in the sheet: _ Text and here columns can be personal Office-365/Excel/Add--in Excel Icons 12.01.2019 1413 Excel Icons A list of internal names for Microsoft Excel icons: Office-365/Word/Ribbonbar-Addin/Code-Examples Code: Word Addin with photos resize and paste in Word 14.11.2018 575 Code: Word Addin with photos resize and paste in Word The following code example creates a Word Addin that inserts photos into a Word file at a specific location or table with a target The photos are scaled down in Windows and inserted into a new table behind the positio Office-365/Word/Ribbonbar-Addin/Code-Examples How to Get the Word Template or a New Word Document in VSTO Addin 13.11.2018 646 Word Template in VSTO Addin How to determine the template of a Word document when launching a C # code in debug in Visual Studio Solution: You can only use the associated template with get_AttachedTemplate (); determine Office-365/Word/vba Insert a line break at the end of a line and then insert text or a table 12.11.2018 584 Word: Insert a line break at the end of a line and then insert text or a table Task: At the end of a certain line o Office-365/Word/Macro/Import-Photos-into-Word Word Addin: Insert photos after a picture mark into a table 10.11.2018 785 Word Addin: Insert photos after a picture mark into a table This Word addin inserts after the Bookmark Imaging: a multi-column table or inserts photos into a predefined target table Office-365/Word/vba Word: insert characters at the end of a line 10.11.2018 472 Word: insert characters at the end of a line This little code script inserts a break at the end of a sentence and then inserts an empty table In C #, according to vba Office-365/Excel/VSTO-Addin/Errors Solved: 0x800A03EC at Excel Pastespecial 03.11.2018 633 Solved: 0x800A03EC at Excel Pastespecial Error Description When running an Excel Copy and PasteSpecial application in an Excel Addin (VSTO Interop) an error message 0x800A03EC is generated &nb Office-365/Word/vba Text input fields in Word with vba c # 02.11.2018 484 Text input fields in Word with vba c # This code example shows how to insert FormTextInput form fields in word Th Office-365/Word/vba Create input fields in Word. C# ContentControls 02.11.2018 778 Create input fields in Word C# How do you add an input field from the developer tools in Word at runtime? The real form fields in Word from the Developer Tools area are of type ContentControl These differ from the pure TextInputFields in that you can format the Office-365/Word/vba Protect Word programmatically 02.11.2018 443 Word protection program in vba protect Protect Word documents at runtime Here in vba C # interop, macro Protect document For protection, you can reduce the input to input fields with WdProtectionType wdAllowOnlyFormFields Office-365/Word/Tutorials Protected entry form in Word 02.11.2018 435 Protected entry form in Word How can you protect an input document as a form in Word? Office-365/Word/Templates Input form in Word with Input Fields 02.11.2018 646 Input form in Word This entry shows how to create an input form in MS Word containing several input fields Office-365/Office/Office-develop Word Addin: Load Excel file into WPF DataGrid 31.10.2018 1584 Word Addin: Load Excel file into WPF DataGrid The following code guide shows how to quickly load data from an Excel file into a WPF DataGrid as an overview in a Word add-in Office-365/Office/Office-develop WPF in Office Vstso applications 31.10.2018 755 WPF in Office Vstso applications This code example shows how to include WPF controls and forms in a Word Office Ribbonbar Menu application A VSTO Addin for Word is created and then a WPF User Control is inserted into the project By changing the entry: UserControl to W Office-365/Excel/VSTO-Addin/Code-Examples Solved: Reading Excel is very slow 30.10.2018 1326 Solved: Reading Excel is very slow Problem: Slow Excel When reading Excel files from Word or other applications via the COM Interop access, the read-out is very slow It seems that every single evaluation of value or text from a cell takes so long Office-365/Word/Ribbonbar-Addin/Code-Examples Word Addin: Adds customer data from Excel file to Word file 26.10.2018 576 Word Addin: Adds customer data from Excel file to Word file Function: The article describes how a Word Excel Data Addin works and contains the download of the word addin as a zip file At runtime, the add-in exchanges data fields in a Word file with data in an Excel fil Office-365/Word/Ribbonbar-Addin/Code-Examples Saving Settings in Office Addin VSTO 26.10.2018 637 Saving Settings in Office Addin VSTO How to save data in an Office Addin? Task: I want to store user-specific data from an input field in a Word add Office-365/Word/Ribbonbar-Addin/Code-Examples Word: Loop through all the words in a Word document 26.10.2018 420 Word: Loop through all the words in a Word document How to examine a Word document for individual words This code snippet searches each word individually in a Word Office-365/Excel/VSTO-Addin/Errors C # Error: The runtime binding can not be executed for a NULL reference. 25.10.2018 448 C # Error: The runtime binding can not be executed for a NULL reference Error message: The runtime binding can not be performed on a NULL reference C # Erroneous code