| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Dec | Feb » | |||||
| 1 | ||||||
| 2 | 3 | 4 | 5 | 6 | 7 | 8 |
| 9 | 10 | 11 | 12 | 13 | 14 | 15 |
| 16 | 17 | 18 | 19 | 20 | 21 | 22 |
| 23 | 24 | 25 | 26 | 27 | 28 | 29 |
| 30 | 31 | |||||
Mike Martin the aurthor of SpeedBasic recently contacted me about his product. It turns out that development has not in fact stopped. Mike took a look at B++ and noticed some areas he thought could be improved. He did the same with his own Speed basic. Taking all this on board and re wrote SpeedBasic […]
While we’re on the subject of toolbars and the customise dialog, I would recommend to all Excel/Office users the following tip. Turn OFF the show menu after short delay option and turn ON the always show full menu option. Again this can be found in the customise dialog, under the options tab. Checking this option […]
Microsoft hold the average user has 4 or more toolbars displayed at any one time. This represents quite a lot of the screen “real-estate”. This is especially pertinent with the advent of “wide screen” type set ups popular on many laptops. A colleague of mine has about 25 rows on display, that’s on a 17” […]
Sometimes we want to hide our data but still display the values in a chart. By defult Excel will remove the chart content when we hide rows or colunms.
The answer is to change a setting in the Excel Maze, sorry options box.
Select the chart you wish to change then goto: Tools > Options > ;Chart
then […]
Big Dick Kusleika over at Daily Does of Excel made some suggestions for Excel 12. One of which was to have captionless worksheets.
The following example sort of does it, it’s a modification of Steven Bullen’s and Tim Clem’s Form fun class.
I didn’t spend very long on this as it’s not really of any use to […]
POS has nothing to do with memory locations.
I bought this (although it was the 1g version) for £60, not that cheap really. I got it about 10 months ago. After about 3 months the plastic cum rubber key hook thing broke, in fact the casing was rubbish from the off.
After about 8 months the whole […]
So i installed and played around with SpeedBasic. I chose to install the Borland C++ compiler, even though i have MSVC. I can honestly say it was a breeze. Much easier that installing VS6 or VB express! (This is stupid, how can it be that one man working by himself can do it better […]
New ideas capture peoples imagine, no doubt about it. But this struck a chord when I re-visited J-Walks old blog.
As you might expect, you’ll find lots of predictable comments and jokes by people who don’t know what they’re talking about. But there are a few interesting comments. For example:
Someone need to start OVER and rethink […]
Following a question over at JMT forums, I have literally thrown together some examples of methods for displaying “in-line” help.
By “in-line” I mean the sort of help that’s displayed right next to the area where it’s needed/used. I don’t believe any of these methods should form the base for a well structured help system, and […]
I have just installed a word addin that lets me post to my blog from word. Very easy to setup, just enter your user name and pass word!
But how well does it work!!!!! Well with this post we shall find out!
BOLD
Underlined
Italic
Link (to addin page)
First problem! does not support images!!!!!!!!!, but i can edit […]
So I’m looking for a free BASIC complier that I can use commercially. There are quite a few around , but I really need a GUI. JustBASIC seems ok, if not a little lite weight , hey you get what you pay for!!!.
FreeBASIC looks very impressive, but I need to check out the licensing. […]
A large spread sheet saved as XML can lead to some big files, there hard to understand - for me anyway:
Eric Bachta has a cool solution, he writes his own simple XML!
I wish there as some kind of add-in for pre 2003 excel which allows XML to be used in it - properly! Any […]
David Gainer was kind enough to answer the mulit thread .xll question
Excel 97 does not support multi-threading. I can see what I wrote was confusing. What I meant was that if you had some XLLs that you have been using for some versions that you want to participate in mult-threaded calc, you can recompile them […]
http://support.microsoft.com/default.aspx?scid=kb;en-us;291392
this is for me really. :-)
XL dennis posted these links over at Dave Gainer Blog, useful, I must read PED also.
http://blogs.msdn.com/eric_carter/archive/2004/12/01/273127.aspx
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q178474
Maybe I’ve missed the boat on this one but I never knew you could open an Access table directly inside excel, I’ve always exported them to .xls files in Access, or used Get Extrenal Data. In Excel, file open (pick all from the type drop down) and click on the Access DB, give you this:
Cliciking […]
I’m not really up to speed with c programing etc, although it is somthing i’m gonna start to look at. Anyway, i dont understand this, from David Gainer Excel 12 blog
Note, the Excel4 API will also respond appropriately to the “$” character, so if an XLL author wants to take advantage […]