Category Archives: VBA/ASP

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

Genetic Algorithm with real number

This is a tutorial from http://paraschopra.com/tutorials/ga/ . I am looking for simple explanation of GA with real number. This one seem giving me the closest answer. The content is copied below. (download vb code from here – ga) About this tutorial This … Continue reading

Share
Posted in VBA/ASP | Leave a comment

FW: Using Database Library Files in Your Access Application

Andrew Wrigley based in Argentina and the UK wrote an really good article to describe how to use Database Library Files in Access application. I found it is very useful and solved a lot of my problem. Below is the … Continue reading

Share
Posted in Access, VBA/ASP | Leave a comment

Dealing with Strings in VBA

Format string to a fixed length in VBA I was working on a project to write out a text file. All variables should be written out in a fixed length. Spaces will be used to fill empty before strings or … Continue reading

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