I’ve not really had a popper play around with this yet, despite begin in the beat program for quite a while. Now they have released the first full version. The good news is the non-commercial version is completely free! And to be fair the commercial version is only 50 quid!
Why not take a little look? […]
Right that should get a few people here!
XL Dennis has made public the first version of his code librarian - “.NET Co Library”.
I’ve done a bit of testing for this addin and can personally vouch for how useful it is - keep all you VBA code in one place - copy the .mdb and […]
Heres a little example of some VBA functions I put together to get geocodes into excel using the google maps API.
It’s not the best geocoder in the world, but it does ok in the test I’ve done so far, although it does just come up with blanks for some locations. To use it you will […]
I recently started a new job and that’s keeping me plenty busy, so the post count is down here, sorry about that, but here some stuff that might be useful.
If you have ever worked with planning or forecasting problems then you have probably used Excels Solver Tool (Solver.xla). Its a nice way to get started […]
I’ve had this done for a while but was hoping to get a bit of testing done on it - thats not gone so well, but I want to get it out there. This then is “Beta” which in this case means don’t even think about blaming me for anything! Having said that I don’t […]
I don’t really know anything about Analysis Services, but MS have just pushed out some addins for leverageing this part of SQL2005 from Excel 2007 - Thought this might be useful to some folks (I’m thinking of Will!)
I’ve just made this easy to use data encryption tool. The encryption algorithm is taken from Rob Bovey’s site.
You can drop your data on to the worksheet (you can add extra worksheets too if you like) and then encrypt the data with the press of a button. You will be asked to provide a key, […]
Most of us know that .dll’s are the only real option if security is a genuine issue, but I think the following might be a possible (bodge) solutions for those who many not have VB, and need better security for their VBA code. Anyway, I was looking at this site:
Tech Net - Office 2000/Visual Basic […]
I have updated the .Net front loader I wrote a while ago. It now allows you to double click a data file, which will open into your Excel App.
For example, if I build a dictor application, and save my data out to text file with a “.MIE” extension, I can now double click that file […]
Looking at the new colour themes in Excel 12 reminded me of a tool I put together a while ago. It’s a colour pallet type tool which lets you build a set of colours in the same range - it’s useful for designing report and the like. Anyway here it is - the help tells […]
I produced a .php file for VBA. I got most of the “Keywords” from ostrosoft.com, and added a few myself. I also changed the colour system. The VBA file has abou 160 “keywords” vs about 300 for the VB one. This is beacuse the “keywords” are infact “Bluewords”, that is to say the […]
UPDATE:
Check Out Andy Popes code, a much better method of moving a userform with out a caption:
Here is some code to move the form around without the need for API coding.
Create a couple of private variables in the userform to remember the position when the left mouse button is pressed.
Private m_sngX as single
Private m_sngY as [...]
Now updated:
http://www.blog.methodsinexcel.co.uk/2006/05/02/excel-front-loader-v2/
Last night I jumped onto the .Net train. So I’m a little late?
I’m using VB 2005 express. I knocked up a little “front loader” app. Very simple, it makes a new excel instance and loads a .xls file called “App.xls” from the same dir into that excel instance then exits.
I had a number of [...]