29 October 2007 by Ross McLean
There is nothing that can be done on Monday mornings that can’t be done on Tuesday afternoons – save breakfast – so take a peak at these. And for god sake Mike C, you’re spilling your coffee!
Possibly not work safe.
Funny name, but it gets a bit interesting at “Br#####k’s formal parent language” – where you can seen that a UTM only needs 6 commands to pass the test – give me enough polynomial time, a lever long enough and I can climb any mounting – I may be mixing my metaphors somewhat.
This is worth a read:
Where’s the Bottleneck?, I think I agree with one commenter:
“Microsoft finds itself surrounded by world class problems. Lawsuits brought not just by a single nation but a consortium of nations; a shift of the primary revenue stream from private citizens to big companies and governments; ever increasing demands from big companies and government for functionality, such as security, that the old customers don’t value as much; and the requirement to remain compatible with the past (old code base), which exacerbates their problems.”
And I think this should be taught as a law of computer science:
Diseconomies of Scale and Lines of Code
Possibly why so many Excel solutions are used every day.
Lastly, a funny:
The Last Language War
Good day to you sir!
Categories: General, White Noise •
3 Comments »
28 October 2007 by Ross McLean
The Excel Developers Kit has been out of print for almost a decade, sadly there has been no update, but you can find a e-copy here:
http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/office97/html/edkfrnt.asp
Most of the stuff is out of date now and much of the C++ stuff just wont work – I understand that some of it didn’t work when it was published! I actually have the hard copy of this is book so if you really need any of the example files I might be able to get them for you?
The second is a link to some general C++ books, not read them myself but though I would post a link as they look good (and are free :-))
http://www.mindview.net/Books/TICPP/ThinkingInCPP2e.html
Enjoy!
Tags: Books, Downloads
Categories: Books etc, C/C++ •
No Comments »
26 October 2007 by Ross McLean
You know the score, you’ve done a pivot table and there are a load of empty cells. You want to fill them up:
[NB: you have to copy the PT as values or the code will fail!]
I use this almost every day:
[vba]
Sub fill_in()
Dim cell As Object
Application.ScreenUpdating = False
For Each cell In Selection
If cell.Value = “” Then
cell.Value = cell.Offset(-1, 0).Value
Else: End If
Next cell
Application.ScreenUpdating = True
End Sub
[/vba]
I think this may be a repost – I did look back but i could not find anything that i had done before, but i remember that Zack Barresse suggesting a none vba way that involvde a special paste of some sort.
Well there you are…
Tags: Examples, VBA
Categories: Functions •
5 Comments »
25 October 2007 by Ross McLean
UPDATE - Check out the comments for a better solution! – boy I sure am glad I finished the post the way i did!
In VB.Net (well any dot net language really) you can add a “SplitContainer” control I like to call it a splitter control. It’s good, it’s great for getting your .Net controls to resize automatically. All you have to do is fill dock your splitter control to the form, then dock your other controls into the panes of the splitter control simple!
One thing that has caused me a slight problem today however it that when you add a tool bar to the form, the docked splitter control does not run “up to” the bottom of the toolbar, but still goes all the way to the top of the window. The problem with this is that when the form changes size (is made larger) the splitter control does not “slide up” to the bottom of the toolbar, so you get a gap.
OK like this:
Not so good:
You can set the location of where the actual split will be placed at run time, so you could get round this by setting it to very low value. However by doing this you have now placed any controls on the lower part of the splitter behind the tool bar!
I added one line of code to over come this issue it works nicely, notice that the 2 is to take account of the width of the splitter handle, which I have set at design time to 1, this seems to make it “hidden” at run time
[CSHArP]
Sub Panel1Paint(ByVal sender As Object, ByVal e As PaintEventArgs)
Me.splitContainer1.SplitterDistance = Me.toolStrip1.Height -2
End Sub
[/cSHArP]
This is a bit of a bodge really as it will not work for all situations, but if you want a quick way to automatically resize form controls and you want a toolbar this might be a workaround.
Any better ideas?
Tags: VB.Net
Categories: VB.Net •
4 Comments »
19 October 2007 by Ross McLean
Simon (am I obsessed with him?) found this paper about the Excel 2007 bug. It’s not only an excellent investigation in to that bug but is generally very interesting to read, and highlights some of the complexities behind the workings of our favour Spreadsheet(thats Excel btw), well worth a read if you have a few minutes.
Also check out the guys web site for some awesome programming examples.
Tags: Blogs, MS
Categories: Books etc •
No Comments »
