David Overton's Blog and Discussion Site
This site is my way to share my views and general business and IT information with you about Microsoft, IT solutions for ISVs, technologists and businesses, large and small.  

Browse by Tags

  • How to copy or archive files by year using the command line and robocopy

    I got this question via e-mail and decided I would post the answer here in a blog. (Updated 16th Feb 2017 with a typo correction) I want transfer all files created in Office Word 2003 by year (annual batchs - ex: 2005, 2006, etc.) to external HD. How can to do this? I will appreciate your answer. Edgar To do this via the command line you can use Robocopy which is present in Windows Vista and Windows 7. If you have Windows XP download the Server 2003 Resource Toolkit and install it. Robocopy will be part of the install and found in the install directory. The actual command would look like this and would need to be entered into a command prompt: for /L %x in (2009,-1,2000) do robocopy source destination \%x *.doc? /maxage:%x0101 /minage:%x1231 /s To break it down a bit.. for /L %x in (2009,-1,2000) do This creates a counter from 2009 up in steps of -1 (or down in steps of 1) until 2000 is reached. Each time the counter changes it is set into %x, so %x will become 2009, 2008 and so on. It then executes the command...
  • Office 2003 running on Windows Server 2008

    I saw that someone searched against this and hit my blog, so I decided to quickly add a note on this. Office 2003 does run on Windows Server 2008, but there is a problem with the Rights Management System client. The Knowledge Base support article Release notes for the preliminary release of Windows Server 2008 has the following to say: Office 2003 is unable to detect the Windows Server 2008 Rights Management System (RMS) Client when you try to use the Windows Server 2008 RMS to protect Microsoft Office 2003 documents. This is planned to be fixed in the future, but since many people don't use the RMS functionality, this is good news. Thanks David Technorati Tags: Office 2003 , Windows Server 2008
  • Office from the past, ODF and OOXML (Office of today and tomorrow) and why is organic growth nearly always bad for software and why re-writing is not good either

    As I have said many times in the past I used to write document conversation tools. I believe this gives me a valid reason to be able to pass comment on the ODF/OOMXL debate that is raging at the moment. If these types of questions interest you, have a look at the book I talk about later ( In Search of Stupidity: Over 20 Years of High-Tech Marketing Disasters (UK) or here for US link ) Lets start with some history about the Office 97-2003 file formats. Joel was writing about this today ( Why are the Microsoft Office file formats so complicated? (And some workarounds) - Joel on Software ). Note that part of what he has commented on is the fact that the documentation for the binary file format is now available from Microsoft: Why are the Microsoft Office file formats so complicated? (And some workarounds) This item ran on the Joel on Software homepage on Tuesday, February 19, 2008 Last week, Microsoft published the binary file formats for Office . These formats appear to be almost completely insane. The Excel 97...
  • Business Contact Manager Team Blog - good information, including SQL and VBA tools, Smartphone and product information

    I was hunting for an answer to a questions someone asked me and I came across this the BCM Team Blog. Below are some of the recent posts. It is worth adding to your RSS feed list. Troubleshooting BCM for Pocket PC/Smartphone Get Business Contact Manager with Outlook Standalone How to Change BCM Polling Interval? Happy Holidays Business Contact Manager for Outlook 2007 SP1 is Live Business Contact Manager Team Blog ttfn David Technorati Tags: Microsoft , BCM , Business Contact Manager , Office 2007 , Office System , CRM , Small Business
  • Where to start to build products that integrate with Microsoft Office

    I came across the OBA (Office Business Applications) web site www.OBACentral.com which has lots of information about nearly 200 OBA solutions. While there is a getting started and "on ramp" information on the site, I found the MSDN site ( Office Integration ) which I like almost as much. Given the prevalence of the Office Platform, assuming it is there and building on it can make life much easier!! Office Integration Need to integrate two or more Office products? Need to integrate Office products with other Microsoft products and technologies? Want to learn about designing and building applications using the Microsoft Office System? This section of the portal provides pointers to resources that will help you build real-world business solutions. Office Business Applications The 2007 Microsoft Office system provides a comprehensive set of servers, clients, and tools to make it easier for enterprises, software vendors and developers to build and deploy a new class of business applications called Office...
  • Finding out where something is in Office 2007 and where it was in Office 2003 (Outlook, Word, Excel, PowerPoint and Access)

    I saw this recently and thought I had to blog it - if you know something was there in Office 2003 and now can't find it in Office 2007 then look at these spreadsheets to get some advice. The 1st set of links (ms-help:) will work on a machine with Office 2007 installed and the 2nd set pull the data from the Microsoft Office web site. From the installed help files Outlook ms-help://MS.RIBBON.12.1033/RIBBON/outlookmap.xls Word ms-help://MS.RIBBON.12.1033/RIBBON/wordmap.xls Excel ms-help://MS.RIBBON.12.1033/RIBBON/excelmap.xls PowerPoint ms-help://MS.RIBBON.12.1033/RIBBON/powerpointmap.xls Access ms-help://MS.RIBBON.12.1033/RIBBON/accessmap.xls From the Internet Outlook http://office.microsoft.com/search/redir.aspx?AssetID=AM101954661033&CTT=5&Origin=HA101934281033 Word http://office.microsoft.com/search/redir.aspx?AssetID=AM101938681033&CTT=5&Origin=HA100625841033 Excel http://office.microsoft.com/search/redir.aspx?AssetID=AM101864291033&CTT=5&Origin=HA100860481033 PowerPoint http://office...
  • How do I take a public folder offline

    I seem to have been asked this a number of times recently, so here is the answer. To take a public folder offline, simply add it to your favourites and then enable synching of public folders. Mark the public folder as a favourite (right click on the folder and select make favourite Go into your account settings and ensure that public folders are enabled for caching Tools / Account / Properties for the Exchange Account / More Settings / Advanced - then tick the box Now, when you sync the favourite public folders will be copied too. That is it ttfn David Technorati Tags: Offline , Public Folders
  • Questions from today's Webcast

    I promised to load the questions from todays webcast. The blog on the webcast can be found at Slides from todays Webcast on Windows SharePoint Services on SBS (WSS v2 & WSS v3) . The Questions were: Do uploaded files take up space in the system partition or can they be stored in a different partition They can do - all files are stored in the SQL database, so moving the SQL database will move the files from the system partition. if the existing SharePoint 2 is almost empty - will you loose out anything if you upgrade? Don't upgrade it - do a clean install and then move data across Do you recommend any books for end-user/creators? If you do this search, you can see a couple of books http://search.live.com/results.aspx?q=windows+sharepoint+services+book+sbs&src=IE-SearchBox - some people seem to rate the step by step book. You have a contacts list, can a specific detailed with field relevant to my business be created? Any fields can be added or removed from the WSS contacts fields, so yes, you can create...
  • Slides from todays Webcast on Windows SharePoint Services on SBS (WSS v2 & WSS v3)

    Today I did my last Webcast on SBS. It was the 3rd of a 3 parter on SBS. Part 1 was about how to use the OPK, part 2 was on Configuring SBS. I will post links to part 1 & 2 later today, but thought I would get the last one out 1st. If you watched the Webcast you will know that explorer crashed on my machine stopping the demos with word and excel working, which was not desired, but I did load 2 beta patches onto my system yesterday, so now the diagnosis as to wether that was the problem begins. Anyway, if you want the slides set they can be found here . Some of the useful links from the deck are: WSS v2 Office 2003 web parts (the last ones) http://www.microsoft.com/downloads/details.aspx?familyid=38be67a5-2056-46a1-84b1-337ffb549c5c&displaylang=en Samples and information http://www.sharepointcustomization.com/wss/articles.htm Enable Office 2007 support http://uksbsguy.com/blogs/doverton/archive/2007/03/13/how-to-get-companyweb-windows-sharepoint-services-v2-to-work-with-office-2007.aspx Backup and restore...
  • Simple overview of what is in Windows SharePoint Services 2007 & MOSS 2007 and how to develop on them

    For those who wish to expand into SharePoint enhancements (remember that you can enhance the site without any dev tools using the browser features) I found this simple blog entry ( Know your options for developing with SharePoint 2007 - Program - .Net - Builder AU ) and it is quite nice. Read the whole blog, but here is a snippet. The editions of SharePoint One of the more confusing aspects of SharePoint is that there are two versions available: Windows SharePoint Services (WSS) 3.0 and Microsoft Office SharePoint Server (MOSS) 2007. Developers follow the same basic steps to get started with SharePoint regardless of the version. Here's an overview of both offerings. |> WSS: This is the so-called "free" version, as there are no additional licensing issues. It is included with the Windows Server 2003 operating system (version 2.0). The current 3.0 version is available via download. It provides core document management, collaboration, and search functions, which include blogs, wikis, RSS feeds, e...
  • Upgrading to Office 2007 using retail boxes - what can you upgrade from

    [updated to change blog title to something meaningful] I was asked about this today - for those people with retail copies of Office, what can they upgrade from to Office 2007. Full details on Word, Excel, Access, Publisher and the suites can be found at 2007 Microsoft Office system pricing - Products - Microsoft Office Online . To see if you have a retail box of an earlier version of Office and if it will load without you needing to upgrade onto a new machine with Vista, have a look at http://uksbsguy.com/blogs/doverton/archive/2007/05/09/buying-vista-and-then-installing-an-old-version-of-office-whatare-you-allowed-to-do.aspx 2007 Microsoft Office suites 2007 Microsoft Office Suites Estimated Retail Price /Upgrade Price Qualifying Products for Upgrade Microsoft Office Basic 2007 Available only through OEMs; price not quoted Upgrade not applicable. Microsoft Office Home and Student 2007 $149/NA Upgrade not applicable. Microsoft Office Standard 2007 $399/$239 Microsoft Works 6.0–10; Microsoft Works suite 2000–2006...
  • Business Contact Manager 2007 (BCM) is NOT supported on Windows Terminal Server, but a little hack will make it work

    [updated on 28th July] Hi, I've pinged this around a bit internally and the answer I got back is that this is not supported and will not work. I have not tried it myself, but don't expect it to work. If you need this sort of functionality you need to look at MS-CRM I am afraid. History: You need a Volume License of Office 2007 to run in Terminal Services. You can get BCM with Volume Licensing of Office 2007 as noted at http://office.microsoft.com/en-gb/suites/FX101635841033.aspx Outlook running in Terminal Services does not run in cached mode - http://technet2.microsoft.com/Office/en-us/library/ba930d00-dc38-4564-ad00-8304d74f1d8c1033.mspx?mfr=true 3) BCM requires Outlook to run in cached mode (Office 2003 note in a KB about this - http://support.microsoft.com/kb/831747/en-us and I have had PSS confirm this is still the case with BCM and Office 2007) Wish this was not the case, but better to say up front rather than pretend. Now, updated, if you look at How to enable cached mode for Outlook when used inside...
  • Show Classic Menus and Toolbars on Ribbon of Office 2007 - two product choices

    I saw a blog entry at Susan Bradley's blog about her now deploying Office 2007 with a classic menu . It was worth of a blog link for all those who want to stick to the old, old ways where you search for items over multiple menus (especially if you turn on personalised menus which hide all the things you don't use regularly). The tool looks slick, but then I found a 2nd one are realised that some cunning ISVs had seen this as their great opportunity to fill a gap that is very unlikely to be filled by Microsoft. The Two solutions are shown below and can be linked to from pschmid.net - RibbonCustomizer™ Feature Tour - Part 3: Classic UI Tabs and Show Classic Menus and Toolbars on Ribbon of Office 2007 : V1.1 Feature Tour - Part 3: Classic UI Tabs RibbonCustomizer™ V1.1 ships with a set of Classic UI tabs for Excel, PowerPoint and Word 2007. Those tabs emulate the Office 2003 menus and toolbars in Office 2007. We provide these tabs to help you familiarize yourself faster with the new Ribbon User Interface...
  • How to get the Office Assistant in Office 2003 (clippy) to work in Windows Vista, i.e. remove the "Not enough memory" error messages

    [updated 24th January 2009 with new download location for x64 systems] [updated 31st December 2009 with Windows 7 information] I have been asked this question several times and finally dug into the system to make it work. N.B. while this will work with Windows 7 the "agent" will have a pink background. Given the age of this technology it is unlikely to be fixed. The solution The Office Assistant relies on some "agent" technologies. To fix this we need to install the agent technologies and then copy a DLL across. Since I was playing around it is possible that there is an extra step or two that is not actually needed, but since this is a small process and simple to do I don't think it will do any harm. What is more, I was not about to rebuild a system, load Vista and Office 2003 just to see if I could remove a 10 second step :-) Download the MSAgent technology from http://www.microsoft.com/msagent - select the CORE files, so for me that was this item - Download the Microsoft Agent core components...
  • How to get rid of the installer / configuration dialog when running Office 2007 and Office 2003 on the same system - for Vista and other versions of Windows

    I have been asked this many times following up on the blog entry Installing Office 2003 and Office 2007 on the same system where once people have removed the problem with the End User Licensing Agreement (EULA) appearing every time they start Office they then get the dialogs below every time they switch between Word 2007 and Word 2003. when starting Word 2003 when starting Word 2007 The fix to the problem is very simple as it turns out - simply run the following commands (by pressing the Windows Key+R or typing it into the Start/Run command box. Use the line with Office\11.0 if you have Office 2003 installed and Office\12.0 if you have Office 2007 installed. You can use both if you have both installed : reg add HKCU\Software\Microsoft\Office\11.0\Word\Options /v NoReReg /t REG_DWORD /d 1 reg add HKCU\Software\Microsoft\Office\12.0\Word\Options /v NoReReg /t REG_DWORD /d 1 That is it. Office 2007 might want to have one more spin round the block with it's configuration dialog box, but that should be it. ttfn...
  • Microsoft Office Outlook Connector Beta (how to connect Office Live Basics or Windows Live Hotmail to Outlook)

    Don't you love the way the title of a product described what it is? While this product does what it says on the tin, it misses out the most important thing - what can you connect Outlook to. The answer is e-mail and contacts based on our Hotmail service, so this includes OfficeLive. If you sign up to one of the subscription OfficeLive services (i.e. you pay us to use it) then you get a connector which can do all this AND synchronise your calendar items too. Once in Outlook you can do all the searching, filing and manipulation you want to do. Today you can now download the beta of the next version of the Microsoft Office Outlook Connector. Download: Microsoft Office Outlook Connector (Beta) The Microsoft Office Outlook Connector is designed to let you access your Windows Live Hotmail account through Outlook 2003 or Outlook 2007. You will be able to download and install the Connector to sync up your email and contacts in Windows Live Hotmail for free. However, if you are a paid subscriber of MSN Premium, Office...
  • Whatever happened to FrontPage and what has it got to do with SharePoint Designer or Web Expression

    I seem to be being asked this a lot, so I thought I would pop up my simple answer: FrontPage has been both extended and then split into two products. We now have SharePoint Designer which is one child of FrontPage, but obviously ideally suited to modifying SharePoint (and OfficeLive) sites and then we have the “any type of web page editor” which is Expression Web. If you look at http://www.microsoft.com/products/expression/en/web_designer/fpwd_faq.mspx you will also see: How is Expression Web different from Microsoft Office FrontPage 2003? Expression Web builds on Microsoft Office FrontPage® 2003 technologies to provide an unprecedented level of support for creating standards-based Web sites. Valuable feedback from customers like you have helped us create a new product that fully supports Web standards such as Extensible Hypertext Markup Language (XHTML), cascading style sheets (CSS), and Extensible Markup Language (XML). If you are familiar with FrontPage, then you will find Expression Web easy to use. Expression...
  • Office XP, 2003, 2007 feature comparison for small businesses

    I saw this on the Small Business site in the US and thought it was an excellent tool as to what has changed between the versions of Office from XP through to Office 2007. Simply go to http://www.microsoft.com/smallbusiness/products/wowpc/CompareOffice.aspx and click out the tabs to get the details. Ttfn David Technorati Tags: Office System , Office 2007 , Office 2003 , Office XP , Comparison , Small Business
  • Responding to another "I can't load Office 2003 on Vista" e-mail

    [updated to correct a typo - 10:48 27th May 2007] I get lots of mails similar to the one below as a result of the blog entries on the EULA not going away and the Office 2003 on Vista and in some cases the issues have been Vista, sometimes the CD and sometimes non-genuine software that someone has been sold (as a side note - it has never been the new security - UAC that has been at the root of the problem). Hi David, I have read your blog entry re: 2003 installation on Vista but I have a problem not previously mentioned. I am doing an install from the CD and have disabled UAC. I attempt to run the SETUP.EXE (as Systems Admin and even with the compatibility set to WinXP SP2) to no avail. The next dialog window comes up saying that the SETUP.INI file cannot be found (path: ./FILES/SETUP/SETUP.INI). I'm baffled because I take the same installation CD and I put it in my old WinXP box and I can explore to find the SETUP.INI file exists. Why is my Vista box not able to see this .ini? Do I need to install the mentioned...
  • Installing Office 2003 and Office 2007 on the same system

    [updated 16:42 9th May 2007 with url for MS Support of this] [updated 9:45 22nd July 2007 with url to fix for install dialog coming up with word] I was recently asked in Office 2003 and Office 2007 can co-exist on the same system. The answer is yes, except for Outlook which as in previous versions get a little precious if this is attempted (it will not let you do this, btw). You can choose to have them both installed to the same drive or one to an external hard drive, it does not matter. The key option is when installing Office 2007 is to customise the options and select to NOT uninstall the previous versions. When you install both copies of Office to be installed on 1 machine that switching between Word 2003 and Word 2007 will result in an install dialog box coming up. See How to get rid of the installer / configuration dialog when running Office 2007 and Office 2003 on the same system - for Vista and other versions of Windows to fix this. For more support information, look at http://support.microsoft.com/default...
  • Buying Vista and then installing an old version of Office - what are you allowed to do

    I have already discussed on this blog what is and is not support for Office on Vista (any version from 2000 on) here . However there is always the question of licensing what is actually allowed and what would be piracy. I am going to try to make it very simple here. · If you have the Home and Student (was the Student and Teacher) Edition then this can be installed on 3 computers in the same household · If you have a previous “Full Packaged Product” – the pretty box you bought at a retailers – version of the product then this can be removed from one computer and installed on a new computer. It can only be installed on one computer at any time · If your software is provided as part of a volume license agreement then you can install on a new computer or other computers, but if you change the number of computers that it is installed on you may have to pay more for the extra usage. · If you have neither of these then you have an OEM copy – this is provided and supported by the people who supplied your computer and...
  • May security updates for Server DNS and Office 2003/2007 and IE7. Also Quicktime needs an update

    I did a quick scan and it seems that this month Office is the main target of updates, along with one critical one for Windows Server (for DNS RPC attack) and one for IE7. Worth a quick download and install :-) I also got this in the mail today: Apple QuickTime 7.x must be upgraded to 7.1.5 or higher. On the security updates: Microsoft is releasing the following new security bulletins for newly discovered vulnerabilities: Bulletin Number Maximum Severity Affected Products Impact MS07-023 Critical Microsoft Excel (all currently supported versions) Remote Code Execution MS07-024 Critical Microsoft Word 2000, 2002, 2003, 2004 (Mac) Remote Code Execution MS07-025 Critical Microsoft Office (all currently supported versions) Remote Code Execution MS07-026 Critical Microsoft Exchange (all current versions) Remote Code Execution MS07-027 Critical Internet Explorer - all current versions on all currently supported versions of Microsoft Windows Remote Code Execution MS07-028 Critical CAPICOM, BizTalk Server Remote Code Execution...
  • New downloads for Business Contact Manager for Office 2007 (and 2003) to provide Pocket PC / Windows Mobile 5 & 6 support, Admin a database on a SBS box, setup a database on a SBS box and offer Office Live Maps for contacts

    I have just got my new mobile phone and I thought I would update the BCM client - a quick trip to http://download.microsoft.com (link takes you to these results) led me to these results below. I think the ones shown are key for many people. Results for - "business contact manager" Title Release Date Popularity Outlook 2007 with Business Contact Manager: Prevent error message about version mismatch when certain Office 2007 applications are launched Prevents error message about version mismatch when you start certain Office 2007 applications on a computer that is running Microsoft Office Outlook 2007 with Business Contact Manager 5/1/2007 #963 Outlook 2007 or 2003 with Business Contact Manager Add-in: Business Contacts for Pocket PC This release is an add-in that allows you to synchronize your business contacts and a subset of your communication history to your Microsoft Windows Mobile 5.0 Pocket PC. 4/25/2007 #536 Business Contact Manager Database Admin Tool Users of Business Contact Manager for Outlook...
  • How to open Office 2007 (Word, Excel, and PowerPoint 2007) files on Office 2000, Office XP and Office 2003 by downloading the Microsoft Office Compatibility Pack for File Formats

    I get asked this question quite often, so I thought I would point out the download location for the tool to make files work between Office 2000, XP, 2003 and 2007. Just to cover off some details - Office 2007 can save in Office 97-2003 file format as well as the new Open XML and PDF file formats. Using this download, files can be opened and saved in Office 2007 format in Office 2000 and later. Of special note is that if you are using Microsoft Office XP or 2003 you MUST install all High-Priority updates from Microsoft Update before downloading the Compatibility Pack . Also, if you don't have those Office programs, but you have the viewers (Microsoft Office Word Viewer 2003, Excel Viewer 2003, and PowerPoint Viewer 2003) then you can use the pack to view files saved in these new formats. For more information about the Compatibility Pack, see Knowledge Base article 924074 . Also Note: If you use Microsoft Word 2000 or Microsoft Word 2002 to read or write documents containing complex scripts, please see http://support...
  • How to add external contacts to the GAL (global address list or the list of names found by default in Outlook) by adding them to Active Directory

    So you may remember the call for help that led to the article How to add public folders to the list of contacts in Outlook : We currently have several public folders which contain email address and contact information for people outside of our company that we want to keep up with. I would like to put these in the All Contacts list on the server, so everyone can open it and reference it when sending email. The only thing I can find it to put them in Active Directory so they can be on the list. Surely there is another way to get this done, but how. I also am not opposed to manually typing them in (and weeding out old contacts), but don't feel very comfortable putting 800 outsiders in my AD. Having proposed the solution in the above link, I then got back the following reply: Thanks David for the reply. I have some address books in the public folder that I have done that to, but was trying to move away from the public folder and have the addresses included in the "All Contacts" under the "All Addresses" section for...

(c)David Overton 2006-18