What I’ve been consuming
I'm reading...Spook Country - William GibsonAugust 2007Random Quote
There's a swagger in my walk
A grade 'A' in my report
I'm the salmon who made it upstream
- SqueezeThe archive
Categories
Tags
ABC This Week AWS ColdFusion COM Dylan faith George F. Will home maintenance hubris Is It My Code Or Is It A Bug Java linux newbie ListQualify Meet the Press Microsoft N.T. Wright Palm PDA PHP podcasts pynchon reading Ron Coulter security Spy Sweeper Stack Overflow Technology the blog VBA Virtual PC WordPress XML XSL
Category Archives: Microsoft
Dumping file info into an Excel spreadsheet
So you’ve got a folder full of documents and you want to know what’s in the folder, how big the files are, and when they were last modified? And of course you want to be able to filter and sort … Continue reading
Export Microsoft Outlook Journal entries to Excel
If you’re a Microsoft Outlook Journal user, save this code into a macro to export journal entries from a select time range into Excel. Updated for Excel 2007. In your macro window, under Tools>References, make sure you check the Microsoft … Continue reading
Shun Virtual PC 2007 if you want Ubuntu
I wish I had read the Ubuntu forum posting about Microsoft Virtual PC before wasting an hour+ of my life trying to get Ubuntu 9.10 to work on Microsoft Virtual PC 2007. Everything installed fine, but I could get the … Continue reading
Cool Excel formula for replacing line breaks
If you copy and paste from another application into Excel, chances are you’ll come across some boxes that create unsightly line breaks in your cells. Use this formula to make those line breaks disappear: =SUBSTITUTE(SUBSTITUTE([celladdress],CHAR(13),” “),CHAR(10),”") where [celladdress] is the … Continue reading
Find and replace for fixed width text in Microsoft Word
If you have rows of fixed-width data (in this case the first 12 characters of each row) and you want to put a tab at the end, put this in your “Find what” box in Microsoft Word: (^13*{12}) and put … Continue reading
CD burning problems
I have of late, but wherefore I know not, lost all my ability to burn CDs. Continue reading
Posted in Microsoft, Technology
Comments Off
Another helpful innovation from Internet Explorer
If an add-on is hosing Internet Explorer, you have to run Internet Explorer WITH ADD-ONS ENABLED in order to manage your add-ons. McAfee Site Advisor is completely hosing a friend’s Acer Aspire. I advised installing Firefox, and somehow Site Advisor … Continue reading
Excel formula
Let’s say cell B5 has a number between 0 and 100, where 0-33 is low, 34-66 is medium and 67-100 is high. Here’s a formula to display the appropriate text =IF(B5
Posted in Microsoft
Comments Off
Access 2007 ApplyFilter issue resolved
Switching from Microsoft Office 2003 to 2007 has not been fun. The most painful part has been Access. I had a form button that ran a macro that used ApplyFilter on a query based on form inputs. It always worked … Continue reading
Posted in Microsoft
Comments Off