Search

Category filtered by: Enterprise Systems [x] | Office Development [x]

Using an Access, MySQL, PostgreSQL or SQLite database from VBA by Pragmateek

Technical Blog 2 May 2013 license: CPOL

[toc] Introduction Note to pedantic guys: yes Access is not a database engine, only the graphical front-end to Jet/ACE, but we’ll stand with this simplification. The sample application (Excel + VBA) and the SQL source code are available in this … Continue reading →

Enterprise Systems » Office Development » Microsoft Excel

VBSQLWindowsCEOArchitectDBADevCOMCOM+ADO, +

Excel UDF library in C# from scratch by Pragmateek

Technical Blog 27 Apr 2013 license: CPOL

Introduction In this article I’ll show you how to create a UDF library for Excel in C# from scratch. By “from scratch” I mean without using Visual Studio, only low-level tools : a simple text-editor like Notepad and the C# … Continue reading →

Enterprise Systems » Office Development » Microsoft Excel

C#Excel

Rename Attachments in Outlook by Som Shekhar

Tip/Trick 7 Apr 2013 license: CPOL

Rename attachments before sending any email

Enterprise Systems » Office Development » Outlook

C#OfficeBeginnerIntermediate

OLE container surrogate for .NET by Alexei Bouravtsev

Tip/Trick 13 Mar 2013 license: CPOL

COM OLE-container analog for .NET

Enterprise Systems » Office Development » General

C#.NETDevIntermediate.NET.NET4

Excel addins troubleshooting guide by Pragmateek

Technical Blog 2 Mar 2013 license: CPOL

Excel addins troubleshooting guide

Enterprise Systems » Office Development » Microsoft Excel

DevIntermediateSysAdminExcel

OpenXML: How do I? by Dane Balia

Tip/Trick 19 Feb 2013 license: CPOL

Struggling to get going with OpenXML here are some basics to give you that boost.....

Enterprise Systems » Office Development » General

Outlook add-in using VC++ ATL/COM by Gokulnath007

Article 5 Feb 2013 license: CPOL

To get instant control over Outlook and various operations of outlook.

Enterprise Systems » Office Development » Outlook

XMLWindowsWin32Win64SQL-ServerVisual-StudioATLDevCOMOffice, +

MS Access to MS Word by Mike Rosen

Tip/Trick 31 Jan 2013 license: CPOL

Export OLEObject (Word Document) to Word Document.

Enterprise Systems » Office Development » Office Automation

C#Office

Insert a Chart in Excel through Matlab by Kiran Chandrashekhar

Tip/Trick 30 Jan 2013 license: CPOL

This tutorial gives you a complete overview on how to insert a Chart to an Excel file through Matlab

Enterprise Systems » Office Development » Microsoft Excel

ExcelMatlab

Read an Excel File through Matlab by Kiran Chandrashekhar

Tip/Trick 29 Jan 2013 license: CPOL

This tutorial gives you a complete overview on how to read from an Excel file through Matlab

Enterprise Systems » Office Development » Microsoft Excel

ExcelMatlab

Write to Excel Sheet through Matlab by Kiran Chandrashekhar

Tip/Trick 28 Jan 2013 license: CPOL

This tutorial gives you a complete overview on how to write to an Excel file through Matlab.

Enterprise Systems » Office Development » Microsoft Excel

ExcelMatlab

Export to Excel – Multiple GridView into Multiple Worksheet by Sandeep Ramani

Technical Blog 22 Jan 2013 license: CPOL

Multiple GridView into multiple worksheets.

Enterprise Systems » Office Development » Microsoft Excel

C#DevIntermediate

SQL table data to Excel and open Excel on client side by joe_j

Tip/Trick 18 Jan 2013 license: CPOL

Export SQL table data into Excel and open the excel file on the client side.

Enterprise Systems » Office Development » Microsoft Excel

VBASP.NET.NETIntermediateExcel

Microsoft Access Application Development Guidelines by Marco Sorich

Article 15 Jan 2013 license: CPOL

Some guidelines for developing better MS Access solutions.

Enterprise Systems » Office Development » Microsoft Access

ADOOfficeAccessdatabaseprogrammingVBA

Microsoft Office Automation - Poor Man's SharePoint Server by Don Ashworth

Article 3 Jan 2013 license: CPOL

A poor man's SharePoint web solution allowing the upload and convertion of PowerPoint, Excel, Visio, and Word documents to HTML.

Enterprise Systems » Office Development » Office Automation

WindowsDevIntermediateC#C#4.0

Querying Database with Microsoft Excel by Jacques Bach

Article 2 Jan 2013 license: CPOL

An easy way to deliver data with MS Excel

Enterprise Systems » Office Development » Microsoft Excel

VBSQLDBADevOfficeSysAdmin

Export Gridview Data to Excel in ASP.NET by AshishChaudha

Tip/Trick 17 Dec 2012 license: CPOL

This article describes how to export data to an Excel file from a GridView.

Enterprise Systems » Office Development » Microsoft Excel

.NET2.0C#2.0ASP.NETDevBeginnerC#.NET

Microsoft Interop API to convert the .doc, .docx, .dot, .dotx and .xls,.xlsx, .rtf to HTML by Vijay Tanwar

Article 13 Dec 2012 license: CPOL

Convert Word documents, Excel sheets to HTML files using Microsoft Office Interop API and render the result back to a client browser.

Enterprise Systems » Office Development » Office Programming

C#.NETVisual-StudioDevCOMBeginnerIntermediateAdvancedC#.NET, +

How to Insert an OLE Object (Adobe Acrobat Document) in Word with C# by SummiG

Tip/Trick 11 Dec 2012 license: CPOL

Easy method to insert OLE Object (Adobe Acrobat Document) in Word with C#.

Enterprise Systems » Office Development » Microsoft Word

C#Wordobject

Outlook add-in integrating Skype by Cristian Amarie

Article 6 Dec 2012 license: CPOL

Outlook add-in integration for Skype IM: Skype events, Outlook Skype ribbon, and more.

Enterprise Systems » Office Development » Outlook

CWindowsWin32Win64DevCOMAdvancedSDKc/c++OLE

Custom Ribbon Help for Office 2010 VSTO Add-ins by Scott Parkes

Article 6 Dec 2012 license: CPOL

Providing custom context sensitive help for VSTO add-in Ribbon controls.

Enterprise Systems » Office Development » Office Programming

C#.NETWin32Visual-StudioDevOfficeAdvancedVisual-StudioVS2010AddIn, +

Reading text or CSV file and saving it as Excel file (.xls or xlsx) using Microsoft Excel by Mannava Siva Aditya

Tip/Trick 21 Nov 2012 license: CPOL

Reading text or CSV file and saving it as an Excel file.

Enterprise Systems » Office Development » Microsoft Excel

C#.NETDevIntermediate

Microsoft Office Version Detector by aalvarez13

Article 8 Nov 2012 license: CPOL

This is an alternative for "Microsoft Office Version Detector".

Enterprise Systems » Office Development » General

C#VBWindowsVisual-StudioDevOfficeBeginnerVBVB.NET

A Simple Way to Export DataGridViews/Lists to Excel by Pasan Indeewara

Tip/Trick 1 Nov 2012 license: CPOL

This article focuses on a Very simple and Robust way to export Data to EXCEL

Enterprise Systems » Office Development » Microsoft Excel

C#.NETOfficeBeginnerIntermediateAdvancedExcelOffice-AutomationOffice-Interopexport

PowerPoint timer (addin) by hevesir

Article 27 Oct 2012 license: CPOL

Timer clock for PowerPoint 2007 (PPT add-in).

Enterprise Systems » Office Development » General

C#WindowsCOMOfficeIntermediateC#3.5

Automating Excel 2007 and creating charts using C++ MFC application in Visual Studio 2008 by abhinavsly

Article 14 Oct 2012 license: CPOL

This article describes how to automate Excel 2007 and create charts using a C++ MFC application.

Enterprise Systems » Office Development » Microsoft Excel

C++WindowsDevIntermediate

Gathering Bloomberg Data with Synchronous VBA Calls to the API by Chris Spicer

Tip/Trick 4 Oct 2012 license: CPOL

This article illustrates the simplest possible way of retrieving data from Bloomberg via the VBA API.

Enterprise Systems » Office Development » General

VBA

Export Multidimensional Array to Excel with Formatting in C# by Santhosh Kumar Jayaraman

Tip/Trick 4 Oct 2012 license: CPOL

This is an alternative for "Export DataTable to Excel with Formatting in C#".

Enterprise Systems » Office Development » Microsoft Excel

C#ASP.NETDevIntermediateExcelDataTablearray

VBA Extend by NewPast.Net

Article 26 Sep 2012 license: CPOL

Format, add line numbers, error handler and expose some dot Net library to VBA

Enterprise Systems » Office Development » Office Programming

.NET2.0WinXPVistaVB.NETWin32Win64OfficeAdvancedWindows, +

Spell checking in Microsoft Access 2003 applications by Md. Marufuzzaman

Tip/Trick 22 Sep 2012 license: CPOL

An easy way to do spell checking in Microsoft Access 2003 applications.

Enterprise Systems » Office Development » Microsoft Access

VB6DevIntermediate

Excel Add-in Framework for Validating and Exporting Data by Clifford Nelson

Article 17 Aug 2012 license: CPOL

A framework for scanning a worksheet for headers, reading and validating data, providing feedback to the user, and displaying the data in a form with the results.

Enterprise Systems » Office Development » Microsoft Excel

C#.NETDevIntermediateExcel

Databind a GridView and export to Excel or text file by Nilesh Patil Miraj

Tip/Trick 14 Aug 2012 license: CPOL

Binding a database table to a GridView and exporting the GridView data to an Excel text file. An Excel file is used to store information.

Enterprise Systems » Office Development » Microsoft Excel

C#DevIntermediate

Addin With Useful Macros & Easily Accessible From Custom Ribbon Tab by Sachin Chandanshive

Tip/Trick 13 Aug 2012 license: CPOL

Addin Containg Useful Macros & Easily Accessible From Ribbon Menu

Enterprise Systems » Office Development » Microsoft Excel

OfficeExcelmacrosprogrammingVBAAddIn

Reading Online CSV File and Manage it into Microsoft SQL Database by Abdul Quader Mamun

Article 7 Aug 2012 license: CPOL

How to read an online Excel file and manage it in Microsoft SQL database

Enterprise Systems » Office Development » Microsoft Excel

C#SQLDBADevOfficeBeginner

Localization in Excel by Michael Banzon

Technical Blog 1 Aug 2012 license: CPOL

Localization in Excel.

Enterprise Systems » Office Development » Microsoft Excel

Excel

Custom Functions in Excel: Part V, XLL-RTDs by Steve L. Powell

Article 29 Jul 2012 license: CPOL

IntroductionWhy would you want to call an RTD from an XLL? Recall that the way to call an RTD is through the RTD function in Excel, so the user needs to somehow remember how many parameters your function takes and in what order to supply them and even what the function is called. Good luck explaini

Enterprise Systems » Office Development » Microsoft Excel

C++CWindowsDevCOMOfficeIntermediateAdvanced

Merge Presentations by pramodhegde88

Tip/Trick 19 Jul 2012 license: CPOL

Merge slides from multiple presentations to one at a desired position

Enterprise Systems » Office Development » General

C#DevOfficeIntermediateOffice-Automation

Custom Functions in Excel: Part IV, XLLs by Steve L. Powell

Technical Blog 13 Jul 2012 license: CPOL

XLLs are significantly faster, and allow the developer to define the names/parameters of the functions.

Enterprise Systems » Office Development » Microsoft Excel

Windows

Exception logging in Office 365 - SharePoint Online custom solutions by Rajesh.Sitaraman

Technical Blog 9 Jul 2012 license: CPOL

Normally we use various logging options in SharePoint custom development, like writing to event log, ULS log, writing to developer dashboard, some use enterprise library logging block to write log to database as well. We don't have this freedom when developing sandbox solutions. Even in this case we

Enterprise Systems » Office Development » General