Excel 2008: Error bars / barres d’erreur

Virtually every time I use Excel, I use it to play around with data and plot the results. Excel 2008 had a nasty issue: you could not add custom error bars to a chart. The application would display it if it had been created in a previous version of Excel, but the user interface to create a new one was simply not there. Well it’s fixed in the Service release 1 🙂 I can finally trash Excel 2004 and use 2008 instead (I don’t really…

Continue reading »

Scripts (again) for the File Type issue in Office 2008

Thanks to Steve Maser, I’ve been able to correct additional issues. I now have two scripts. The first one works through Drag & Drop. You can drag files or folders on the script and it will scan for the old file types and replace them with the new ones (recursively in the entire folder if you dropped a folder). At the end of the process, it tells you that the files have been converted. It doesn’t necessarily mean that files were outdated and were converted,…

Continue reading »

Second version of the Office 2008 converter script

Well Steve Maser asked me to come up with a version that would work recursively on all files inside a folder you would drag to the script. He also suggested that I added the W6BN type (for Word 6/95 files). So I based the script on one of the examples provided by Apple, and here is the result: — This droplet processes files dropped onto the applet on open these_items    repeat with i from 1 to the count of these_items       set this_item to item i…

Continue reading »

Converting files for double-click in Office 2008

In the Service release 1 for Office 2008, Microsoft decided to prevent files with old file types to open through a double-click or a drag and drop (and don’t know why and that’s not the point here). There is a workaround to open these files. MS recommends that you use the Open dialog from within Office applications. If you have hundreds of old files affected with this problem, that’s hardly a decent solution. You can batch-wipe out the creator code of your files as well.…

Continue reading »

Réparation automatisée des fichiers refusant de s’ouvrir avec Office 2008 SR1

Grâce à l’aide de Steve Maser, nous sommes parvenus à trouver une solution plus automatisable pour réparer les fichiers qui refusent de s’ouvrir dans Office 2008 SR1 d’un simple double-clic dans le Finder. Le problème semble être lié aux codes Type et Créateur de ces fichiers. Leur suppression permet de pouvoir à nouveau ouvrir ces ficheirs d’un double-clic. Il existe de nombreux utilitaires pouvant vous assister dans cette tâche. Celui qui me vient en premier à l’esprit est bien sûr File Buddy. Il est un…

Continue reading »

Batch-fixing files that won’t open with 2008 SR1

Thanks to the help of with Steve Maser, we found a solution that should allow to batch process files that refuse to open through a Double-click with the Service Pack 1 for Office 2008. The problem appears to be related to the file Type and Creator. Wiping out the file and creator for these files fixes the issue and allows you to open them through a regular double-click again, There are several utilities that allow you to batch process files to wipe out the file…

Continue reading »

Office 2004 11.4.2

Office 2004 11.4.2 is now available on the Mactopia website This one is a simple security update, but as always, still well worth installing. Office 2004 11.4.2 est désormais disponible sur site Web de Mactopia Juste une mise à jour de sécurité, mais ça vaut toujours le coup de l’installer.

Continue reading »

Office 2008 Service Pack 1

A second major announcement bout Office from Macworld. It looks like the Service Release 1 for Office 2008 is just around the corner. It is to be released today and bring a ton of improvements in all Office applciations. It will be avilable on MacTopia and probably shortly after through auto-update. EDIT: It is now available. Roughly 180MB… Une seconde nouvelle pour Office de conséquence annoncée par Macworld. Il semblerait que le Service Release 1 pour Office 2008 est ur le point d’être mis à…

Continue reading »

Macworld | Microsoft to bring back Visual Basic in Office for Mac

Macworld just announced tht Microsoft is to bring back Visual Basic in Office for Mac. Huge news indeed. It looks like the myriad of users who said that they had to rely on it for their day to day work made a difference. It should come for the next major version, in 2010, or 2011… Macworld vient juste d’annoncer que Microsoft va ramener le Visual Basic dans Office pour Mac. C’est une énorme nouvelle. On dirait que la myriade d’utilisateurs qui ont fait savoir qu’ils…

Continue reading »