June 2006
M T W T F S S
« May   Jul »
 1234
567891011
12131415161718
19202122232425
2627282930  

Archives

Archive for June, 2006

Selection to CSV

( General )

Obviously you could adapter it to do what ever type of text file you like (well, and Excel can handle)

Option Explicit
Private Const BIF_RETURNONLYFSDIRS As Long = &H1
Private Const BIF_DONTGOBELOWDOMAIN As Long = &H2
Private Const BIF_RETURNFSANCESTORS As Long = &H8
Private Const BIF_BROWSEFORCOMPUTER As Long = &H1000
Private Const BIF_BROWSEFORPRINTER As Long = &H2000
Private Const BIF_BROWSEINCLUDEFILES As Long [...]

Excel 2007, what’s the story

( General )

Well it’s been out for a while, but I’ve not seen a lot about it in the Excel community. So what do you think to the new version?

I have uninstalled it on my mechanics; it was way too much of a pain. I couldn’t open files by default in an earlier version and that was [...]

Making Spreadsheets Correct

( General )

Don't worry I'm still alive! Despite only making one post last month I have in fact been doing quite a lot of programming. I hope to have something reasonably interesting to post soon.
In the mean time, if you care to drag yourselves away from that Beat for a few moments, this might be worth a [...]