9 July 2011 0 Comments

Access Database Engine 2010 Service Pack 1 released

If you’ve read my previous blog post ” Accessing Excel files on a x64 machine ” and you loved our ACE OLEDB Provider, I want to let you know that we released ” Access Database Engine 2010 Service Pack 1 “. This update is also available in Windows Update.

28 March 2011 0 Comments

Creating multi-series Bubble Charts in Excel

Bubble Charts are a great way to visualise data that has three numerical values for each point. Two of the values are plotted on the X and Y axis, while the other is represented via the diameter of the bubble

3 August 2009 0 Comments

Chinese MVP Finds A Place For Excel At Home

MVP Qing Lin Zhou , has great passion for Microsoft Excel.

24 July 2009 0 Comments

MVP Excels In Professional Development

MVP Rob Bovey , along with his fellow authors have collaborated together on a new book entitled, “Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET” . The book looks at a number of best practices for planning, architecting and building Excel applications that are robust, secure, easy to maintain and highly usable. Professional Excel Development is designed for professional developers and Excel experts and the authors share insider’s knowledge that they have acquired building Excel applications for many of the world’s largest companies—including Microsoft

14 July 2009 0 Comments

Check out the online videos of Office 2010 in action!

As mentioned in my, “ Microsoft Office 2010 Hits Major Milestone and Enters Technical Preview ” post earlier, the Technical Preview of Microsoft Office 2010 is now released.  Yesterday at Worldwide Partner Conference, attendees were able to see Microsoft Office 2010 in action, showing off some of the very cool new features it is going to bring to individuals and workers around the world.  Here is your chance to see some of these features for yourself, in a series of short, online videos of the Microsoft Office 2010 applications.  Take a look for yourself. Be sure to check out the awesome video & web/smartphone capabilities in PowerPoint 2010 and some of the amazing management and ease of use features in Outlook 2010!  There’s also the web access, edit, and live interaction with the Office 2010 applications!  Did I mention the incredible business intelligence for everyone features in Excel?  I haven’t even talked about the new things in Word 2010 yet…  But instead of me rambling (any more), take a look for yourself

9 July 2009 0 Comments

Excel mit SharePoint synchronisieren

Wenn Sie aus dem ShaerPoint eine Liste mittels “Nach Excel exportieren” exportieren, ist es seit Office 2007 nicht mehr möglich, Änderungen im Excel zurück in den SharePoint zu synchronisieren. Diese Funktion ist im Offcie 2007 nicht mehr vorhanden. Sollten Sie dennoch diese Funktion verwenden wollen, gibt es einen Workaround, welcher aber nur mit Excel 97-2003-Dateien funktioniert (Open XML Format wird nicht unterstützt)

14 June 2009 0 Comments

Single charting engine across all of Office 2007

You may notice that copying and pasting from Excel 2007 into PowerPoint 2007 works better (especially with charts). The main reason for this is that we now have a single charting engine across the suite

12 June 2009 0 Comments

How to autoresize parent frame height from child frame

Scenario A parent document contains a frame that loads a file which content is dynamic and you want the frame to not scroll and autosize the height of the frame. Solution function autoResizeParent() { // if no parent don’t attempt to change if (parent != null) { var frameList = parent.document.body.getElementsByTagName(“iframe”); // is there any frames

29 May 2009 0 Comments

DCO Workshops a Big Hit…

Thank you to everyone who attended the NAV DCO/MOSS workshops over the last couple of weeks. The feedback has been fantastic

17 May 2009 0 Comments

Adventures in Packaging – Episode 1

Technorati Tags: OPC , OPC basics , Open Packaging Conventions , ISO 29500 , ECMA 376 If you’re developer who creates or accesses data files (and who doesn’t?), then this blog might be one for you to keep an eye on. Welcome to the first installment of Microsoft Packaging Team blog! The Packaging team works in the Microsoft Windows Division to provide programming APIs that support the Open Packaging Conventions standard.  Open Packaging Conventions (“OPC”) is a new file technology documented by the ISO/IEC 29500-2 and ECMA 376-2 standards. Several members of the team worked on the original System.IO.Packaging APIs released for managed-code in .NET 3.0.  We’re particularly excited now with the upcoming release of Windows 7 which will include new native-code Win32 Packaging APIs that will ship as part of the operating system! Microsoft is strongly embracing open standards and interoperability – the commitment to incorporate OPC as an integral element of the operating system is another step in that direction.

15 May 2009 0 Comments

Publishing PerformancePoint Server in an Extranet – White Paper Now Available

Now available is a white paper outlining the technologies and steps required to publish PerformancePoint Monitoring Server dashboards in an Extranet. You can download this white paper from: http://go.microsoft.com/fwlink/?LinkId=151630…( read more )

13 May 2009 0 Comments

BizTalk 2009 supported upgrade paths

Folks, I’ve actually received a whole swag of questions around the paths that we currently support for upgrade to 2009. This table provides a good overview of the supported paths (Note, we still do not support a direct 2004 to 2009 Upgrade. As and when we publicly release a guidance on that, I’ll update my blogs): BizTalk Server 2006/R2 BizTalk Server 2009 Evaluation Edition BizTalk Server 2009 Branch Edition BizTalk Server 2009 Developer Edition BizTalk Server 2009 Standard Edition BizTalk Server 2009 Enterprise Edition Evaluation No No No No Yes Partner No No No Yes Yes Developer No No Yes No Yes Standard No No No Yes Yes Enterprise No No No No Yes