Worksheet names in Excel Cells If you are working in Excel, and you want to show the worksheet name in a Cell on that worksheet, you can use the CELL function to do so. By default the CELL function will return the current document name, if used with the filename info_type: =CELL("filename") This provides a full path to the spreadsheet, with the worksheet of the current Cell at the end, e.

If you use Unix, and need to migrate your Business objects CMS from one database to another database, you will probably use the cmsdbsetup.sh script. This script migrates and manages your database connection in a Unix environment using Business Objects Enterprise (BOE). In my case I am Using Solaris 9, and have Oracle 10g databases and client files for use by BOE. When running the cmsdbsetup.sh script you get the following error pertaining to clntsh:

I’ve uploaded the initial public release, v1.2, of my simple Tweet plugin to the WordPress Plugin Repository. You can install the plugin by: downloading it from http://wordpress.org/extend/plugins/tweet/ ; or On a recent version of wordpress, v2.7 or above, follow these steps: Login to your wordpress dashboard Select the Plugins/Add New menu item as shown Search for Author lantrix as shown Click on the Install link for the Tweet plugin If you need any assistance, you can leave a comment over on the dedicated page for the Tweet WordPress plugin for Twitter.

So you have a pattern you want to match across multiple lines, and you have a regular expression that matches it. You will probably be used to doing this in perl like this: /some.+?stuff/s or using regex in ruby like this: /some.+?stuff/m However you have just started to get used to Textmate as an editor and you see it supports regex matching. Why though does it not use /s or /m for multi-line dot matching?

A quick one today, but worthy of note is the upcoming now out WordPress iPhone Application. This means an update of techdebug.com is on the cards… You can read about it on the dedicated iPhone page. via TUAW

Forgive my triple Post Hiccup. When Textmate posted my blog posts, I got errors. Thinking the post had not completed, I retried until I figured out the problem. If you use WordPress V2.3 and post with Textmate, then don’t try to add a new category when posting an article. You get this problem: <br /> Fatal error: Cannot use object of type WP_Error as array in wp-includes/taxonomy.php on line 1010<br /> Looks like I am not the only one.

I use vim a lot of the time, mostly with splits and diffs, so the following key mappings and functions really helped me with managing the split windows. Maybe they will help you too. (Thanks to the Vim tips wiki for these). If you use vertical splits, this will help move left and right across the split. Put in your ~/.vimrc <br /> " Map multi window keys<br /> set wmw=0<br /> " CTRL-H move to left window<br /> nmap <c -h> </c><c -w>h</c><c -w><bar><br /> " CTRL-L move to right window<br /> nmap <c -l> </c><c -w>l</c><c -w><bar><br /> </bar></c></bar></c> When scrolling up and down a window, you can use zz to jump the current line to the middle of the window.

I use eReader on my Palm, but only for free documents and not often enough to warrant paying for it. Now that is no longer required. As I noticed at the downloadsquad, eReader Pro for Palm and Windows mobile devices is now being offered for free. If you would like your own copy for Palm (or windows mobile) you can download it from the ereader website.

I received and email from the MacHeist directorate today. The controversy has been solved by YazSoft offering a free upgrade to Speed Download 5 for MacHeist customers, but only for a very limited time – March 13 2008 until March 27 2008. It is nice that I got the email, albeit 5 days after the offer was extended. This list of changes that come with SD5 are available online. So if you purchased Speed Download 4 with MacHeist II, and choose to upgrade, then proceed to yazsoft’s website in a quick and orderly fashion to get the upgrade offer.

David Watanabe announced the most recent upgrade to Newsfire RSS as now free for all users. In David’s own words, he explains what the buzz about news aggregation is, and why Newsfire is a must for ALL mac users: For those new to this, NewsFire is a news reader for blogs, news sites, and anything else that publishes an ‘RSS’ syndication feed. It watches for news so you don’t have to.