Tag Archives: Excel

Removing the password of an Excel VBA project

‘ to remove the password of a excel with .xlam extension ‘ 1. use the Savexlam2xls subroutine to save a copy of xlam file to xls file ‘ 2. run the moveprotect subroutine to remove the password of the xls … Continue reading

Share
Posted in Excel, VBA/ASP | Tagged , , , | Leave a comment

Add a worksheet function to extract hyperlinks

There is no worksheet function to extract hyperlink in a given cell. We can use VBA to create a function to do this. The simple function is listed here. Function getlink(rng) getlink = rng.Hyperlinks(1).Address End Function In your worksheet, you … Continue reading

Share
Posted in Excel, Tips, VBA/ASP | Tagged , , | Leave a comment

System API and file system access in VBA

Brief Introduction Microsoft Visual Basic for Application (VBA) is a powerful tool for Microsoft Office Suite. General users usually only use a small portion of functions Microsoft Office provides and never have a chance to touch VBA. However, Microsoft Excel … Continue reading

Share
Posted in Excel, VBA/ASP | Tagged , , , , , , , , , , , | Leave a comment

A C# class to control Excel – A core class used in TWE 2.0

This class was developed from the basic framework Vahe Karamian created in 2005. It is a complete solution to control Microsoft Excel from C#.Net. It allows you to create an Excel object and control a lot of the Excel functionalities such as getting worksheet information, extracting data from the worksheet given a range, and manipulating data in many ways. You can use this class freely in your C# project. If you find and fix bugs please write comments to this post. Read Karamian’s original article to find out how to use the code. You can download all source code in a zip file through the link at the end of the post. Continue reading

Share
Posted in C/C++/C# | Tagged , , , | 1 Comment

Using Office Web Components to draw graphs on Excel userforms

The Office Web Components (OWC) are a series of components that you can add into a web page or any Office application. A typical use of the OWC in Office application is to add a graph in a user defined … Continue reading

Share
Posted in VBA/ASP | Tagged , , , , , , | 1 Comment