Archive for the ‘Registry’ Category.

Getting the Printer Port

Do you know how windows appends that “on Ne01″ to your ActivePrinter. In the old days we had to loop through all the possible digits to find which one didn’t error out. Well no more!
Holger uses the registry to find the printer port. Very clever. However, if you have back slashes [...]

Installing An Excel Add-in Using Setup Factory

Being an MVP has some benefits. One of them is that some software companies offer Not For Resale (NFR) products to them for free.
Of course these companies hope the MVP’s will advocate their products.
Well, for this one I will do so: Setup Factory.
I’ve started using this tool just a week ago and I must say [...]

A Setup Utility to install your add-ins (take two)

Hi everyone,
I’ve revisited this utility yesterday whilst travelling by train.
I was doing a review on a manuscript for book about Excel VBA and whilst testing some (faulty!) example code I discovered mine had a similar potential problem.
I’ve fixed this in the latest version.
Find the utility here.

A setup utility to install your add-ins

If you have created a nice add-in (see this article how to do that), a setup utility is an easy way for your users to install your addin. This free utility just needs you to change 4 cells to roll your own setup file.
Find the utility here.

More Registry Stuff

In addition to GetSetting and SaveSetting, VBA provides the GetAllSettings statement. This statement is used to get all of the settings for a particular section in the registry at one time. It returns a two dimensional array: the first dimension is the key and the second dimension is the key’s value. For [...]

Storing Data in the Registry

You can store information relating to your Excel application in the registry. VBA provides an easy way to set and retrieve that information via the SaveSetting and GetSetting statements.
The arguments for these statements are AppName, Section, Key, and Setting. All of these arguments are data that you create. That is, there’s no [...]