Daily posts of Excel tips…and other stuff
Archive for the ‘Registry’ Category.
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 [...]
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 [...]
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.
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.
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 [...]
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 [...]
