An Excel Front loader (Dot Net, dot slow! )

Posted on Wednesday 8 February 2006

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 problems:
The form does not display correctly (on my PC’s), and there does not seem to be a form.paint option – I understand .Net handles this differently, I’m sure there’s a work round I just haven’t found it yet.
I wanted just to hide the form, but this didn’t work (frmLaod.visible = false), so I had to exit the app altogether.
I’m sure there are ways to do this, I just could find them!

Oh yes one other tinny thing, this is the slowest bit of software I have ever seen in my life!!!!, It’s a embarrassment, now that could just be my programme or it might not!

Here’s the .exe
Here the vb project