Microsoft

No Code Business Solutions in Microsoft SharePoint

Resources to show you how to create code-free business solutions in Microsoft SharePoint


📖 Posts | 📎 Enterprise, Microsoft, Windows | 🔖 hardware, laptops

New Laptop: Lenovo ThinkPad Yoga

I have the pleasure of trying a new laptop right now as we consider them for work. The Lenovo ThinkPad Yoga. We have this configured with an Intel i5, 8GB RAM, 1TB HDD with 16GB SDD speed boost, the touch & pen screen. It is a nice laptop with a screen that folds right over so you can use it as a slightly chunky tablet, the keyboard locks in this mode so you don’t accidentally press keys.

Microsoft 64-bit Application Support (lack-of)

Microsoft’s 64-bit support is still sorely fragmented as we find out with a brand new laptop trying to access Microsoft SharePoint.


📖 Posts | 📎 Microsoft | 🔖 office, word

Microsoft Word Wildcard and Regular Expression Search and Replace

One often missed aspect of the Find dialog in Microsoft Word is the ability to use wild cards. In fact, Word not only has the simple wild cards (* and ?) but uses simplified Regular Expression (REGEX) searching. In this article, I’ve put together a number of examples of advanced finds and replaces that I’ve found useful. I’ll update it from time to time.


📖 Posts | 📎 General, Microsoft | 🔖 facebook, fail, google, microsoft, office

Microsoft’s Facebook Docs.com fails at the first hurdle

Had my first test for Microsoft’s new docs.com this week – and it failed badly. In case you don’t know, Microsoft recently announced a new beta Office Live link-up with Facebook. You can log in using your Facebook login instead of a Microsoft Live Id. So you would think that it would be possible to use docs.com as a collaborative document editor and I suspect that you are supposed to be able to – as long as your documents don’t contain anything complex – such as comments!


📖 Posts | 📎 Development, Microsoft, Windows | 🔖 maps, office, vba

Nearest Postcode Search in Microsoft Excel

I need to find a load of addresses by proximity to a postcode. I have the addresses in a Microsoft Access database. 1. Download Paul Jenkins’s UK Postcode csv and import into Access as a table 2. Create a query on your own table adding the following calculated field: <pre>PCregion: Trim( Left( [My Table]![Postcode], InStr( [My Table]![Postcode], &#8221; &#8221; ) ) )</pre> Create a second query that joins the above query to the imported postcode table.


📖 Posts | 📎 Microsoft, Software, Windows | 🔖 vista, webdav, win7

How-to use WebDAV on Windows Vista and Windows 7

Windows is supposed to have a built-in WebDAV client. However, it doesn’t ever seem to have been especially robust and certainly since Vista a lot of people (myself included) have found that it simply doesn’t work on many supposedly WebDAV enabled sites. Thankfully there are a couple of free (and some not free) options that, while not as nicely integrated into Windows Explorer, do enable you to transfer files back and forth.

Copy and Paste to OneNote (AutoHotKey script)

After yesterdays OneNote tool post, I thought I’d do another while I think about it. Another annoyance of OneNote is it’s lack of control over pasting information from the clipboard. I’ve raised a suggestion with MS to improve this; you can see my comment in the newsgroup. To ease things a little if you need to copy and paste lots of stuff to OneNote, here is an AutoHotKey script to help.

Setting list item gaps in Microsoft OneNote (AutoHotKey script)

Although I like Microsoft OneNote and use it continuously, it does have a few failings. One of these is the inability to set the default styles and layout for text. In particular, when you create a new paragraph or list entry in OneNote, the default – non-changeable – setting is to have no white space between the paragraphs. This is very poor design and makes more than a small amount of text quite unreadable.