Tuesday, October 31, 2006

Migrating a VBA Solution to Visual Studio Tools for Office

Migrating a VBA Solution to a Visual Studio Tools for Office Add-In  Learn how to use Microsoft Visual Studio 2005 Tools for the 2007 Microsoft Office System to add new functionality to your Visual Basic for Applications (VBA) solutions, using the VBA skills you already have.

Contents:

  • Types of Microsoft Office Solutions
  • Office Solution Architectures
  • A Global Template Example: The Amazon Add-In
  • Migrating the VBA Global Template to an Add-In
  • Conclusion
  • Additional Resources

Friday, October 27, 2006

Office 2007 Developer Posters

2007 Office System Developer Posters Download these posters to learn more about the new features and enhancements  in Office 2007.

Office Accounting 2007 Downloads

Office Accounting 2007 Software Development Kit (SDK)  Includes documentation and samples—everything developers need to write, build, and deploy Microsoft Office Accounting integrated applications.

Office Accounting 2007 Update: Microsoft Office Accounting 2007 Transaction Migration This download provides the update to Microsoft Office Accounting 2007 to enable import of transactions from Intuit QuickBooks.

Wednesday, October 25, 2006

TrayIE: New Applet to Manage Internet Explorer

I am now using IE7, but disappointed that there is still no minimize to the TaskBar IconTray functionality, and I can't find an add-on.

So I built my own applet to reduce screen clutter and re-launch IE instantly after hiding it.

TrayIE sits in your Windows Desktop Icon Tray as an icon and lets you easily manage your Internet Explorer windows. The tray icon changes according to the current status of IE windows on your Desktop:

  • IE is not open. Double-clicking the icon will launch IE.
  • IE windows are open and visible. Double-clicking the icon will hide all IE windows.
  • All IE windows are hidden. Double-clicking the icon will restore all IE windows.

A global hot key [Win+i] saves you double-clicking the tray icon anywhere in Windows.

Left-click on the tray icon to use the popup menu, and set an alternate global hot key.

Download

Tuesday, October 24, 2006

Improved Performance in Excel 2007

Improving Performance in Excel 2007 Learn about the increased worksheet capacity in Microsoft Office Excel 2007 and techniques to improve calculation performance.

Office 2007 Download: Office Sharepoint Server 2007 SDK B2TR

Download: Office SharePoint Server 2007 SDK: B2TR The Microsoft Office SharePoint Server 2007 (Beta) SDK contains conceptual overviews, programming tasks, code samples, and references to guide you in developing solutions based on Microsoft Office SharePoint Server 2007.

Office 2007 Automation: Latest Resources

Improving Performance in Excel 2007 Learn about the increased worksheet capacity in Excel 2007 and techniques that you can use as you design and create worksheets to improve calculation performance.

Integrating Visio 2007 and Project 2007 Take advantage of the new integration capabilities in Project 2007 and Visio 2007 by using a combination of native features and COM add-in features.

Using XML to Write a Trip Report Are you a salesperson who spends time on the road visiting customers? Are you part of a marketing team that tracks sales visits? Find out how you can make creating trip reports easier with Word XML features.

Creating Custom Task Panes Using Visual Studio 2005 Tools for Office  The 2007 release of the Microsoft Office system introduces enhanced custom task panes that you can use to provide contextual assistance to your users. Learn how to create custom task panes with Visual Studio 2005 Tools for Office.

Video: Building Documents from Scratch Using the Office XML File Formats  Demo of the Open XML formats, including the key things that go into building a document.

Integrating Visio 2007 and Excel 2007 See an example of linking data in Visio to Excel by using the Visio Data Selector and an example of creating and populating an Excel Bill of Materials by using Automation code.

Integrating Visio 2007 and Access 2007 Use Automation code to create a Visio drawing from data defining the contents of a drawing

Sunday, October 22, 2006

SQL Server Hosting Toolkit Launched

The SQL Server Group at Microsoft has just launched the SQL Server Hosting Toolkit with the release of the Database Publishing Wizard Community Technology Preview 1:

The objective of the SQL Server Hosting Toolkit is to enable a great experience around hosted SQL Server.  The Database Publishing Wizard works toward this mission by making it easy to upload a database from a development box up to a shared hoster.  In its first incarnation, the Database Publishing Wizard is a command line tool that generates a T-SQL script designed to be executed in the script execution windows provided by most hosters in their database management consoles.  In the coming months we'll be adding a GUI and building seamless integration between the tool and an upload service we'll provide to hosters for deployment.

Details on the Database Publishing Wizard as well as the download can be found at http://www.codeplex.com/Wiki/View.aspx?ProjectName=sqlhost&title=Database%20Publishing%20Wizard.

We plan to be releasing advances in the Toolkit frequently so check out this first CTP and give us your feedback!

Thursday, October 19, 2006

Latest Ms Access Knowledge Base Articles

Access 2000


918144 Description of the Jet 4.0 Database Engine post-837001 hotfix package: May 11, 2006

923274 Description of the security update for Office 2000: October 10, 2006 

Access 2002


922665 How to change the source for a client computer from an updated administrative installation point to an Office XP original release version baseline source

925082 The icon is blank when you insert an object or a file into a document, presentation, spreadsheet, or other Microsoft Office file

922581 MS06-062: Vulnerabilities in Office could allow remote code execution

924122 Description of the Office XP post-Service Pack 3 hotfix package: August 17, 2006

923273 Description of the security update for Office XP: October 10, 2006  

Access 2003

920355 Description of the Office 2003 post-Service Pack 2 hotfix package: July 17, 2006

922326 Description of the Office 2003 post-Service Pack 2 hotfix package: July 3, 2006

917937 Description of the Access 2003 post-Service Pack 2 hotfix package: August 14, 2006

922328 Office 2003 icons appear fuzzy or have poor contrast after you change the DPI setting in Windows to "Large size (120 DPI)"

924866 Description of the Office 2003 post-Service Pack 2 hotfix package for the Dutch proofing tools and for the Dutch Multilingual User Interface Pack in Office 2003, in Project 2003, and in Visio 2003: September 8, 2006

922395 All the fields of a record display #Delete when you copy and paste a record that contains a Null field in Office Access 2003

925152 Description of the Office 2003 post-Service Pack 2 hotfix package for Office 2003, for Project 2003, and for Visio 2003: September 13, 2006

923508 A .tif file or a .tiff file unexpectedly opens in Microsoft Office Document Imaging

923097 Description of the update for Office 2003: October 10, 2006

923272 Description of the security update for Office 2003: October 10, 2006

924424 Description of the security update for Office 2003: October 10, 2006

SQL Server Reporting Services

Building Ad-hoc Reporting Solutions with SQL Server 2005 Report Builder and Analysis Services OLAP  This paper introduces Microsoft SQL Server 2005 Report Builder and demonstrates how to build an end-to-end ad-hoc reporting solution for enterprise customers using Report Builder and Microsoft SQL Server 2005 Analysis Services OLAP.

Get More Out of SQL Server Reporting Services Charts  Review general information, best practices, and tips for designing charts within Microsoft SQL Server Reporting Services reports.

Latest Office 2007 Resources

Download: Windows SharePoint Services SDK  Conceptual overviews, programming tasks, samples, and references to guide you in developing solutions based on Microsoft Windows SharePoint Services 3.0.

Download: Office Project 2007 SDK: B2TR  Documentation, code samples, How to articles, and programming references to help customize and integrate the Project 2007 clients and Project Server 2007 with other Office applications.

2007 Office System Document: Lists of Control IDs (Beta 2 TR)  Download containing files that list the control IDs for built-in controls in all applications that use the Office 2007 Ribbon.

Building Better Business Applications Using 2007 Office System   MS Office 2007provides a set of servers, clients, and tools to make it easier for enterprises and software vendors to build and deploy OBAs to connect current LOB systems with the people who use them through the Microsoft Office interface.

Wednesday, October 18, 2006

Download IE 7 Now!

Yahoo has released its version of Internet Explorer 7. Download

10 Step Security Lockdown

Frem TechRepublic.com:

10 Tricks For Handling Null Values in Access

10 tricks for handling null values in Microsoft Access Null values indicate that data is missing or unknown, and if not handled correctly can cause runtime errors or corrupt your data. These pointers for MS Access from TechRepublic.com will help you understand and effectively address null values in various situations.

Integrating Office with ASP.NET 2.0

Integrating MS Office Applications with ASP.NET 2.0 Web Sites  Integrate Microsoft Office Word 2003 and Microsoft Office Excel 2003 with ASP.NET 2.0 Web sites to generate form letters in Word and graphical reports in Excel.

Tuesday, October 17, 2006

Understanding Workflow in SharePoint and Office 2007

2007 Office System Document: Understanding Workflow in Microsoft Windows SharePoint Services and the 2007 Microsoft Office System In this white paper, learn the basics of the Windows Workflow Foundation, how this technology has been integrated into both Windows SharePoint Services and the 2007 Office System, and how to benefit from workflows applied to business processes.

Monday, October 16, 2006

SQL Server Database Publishing Wizard CTP 1


SQL Server Database Publishing Wizard CTP 1 The SQL Server Database Publishing Wizard provides a way to publish databases to T-SQL scripts for later use. The Wizard enables the deployment of SQL Server 2005 databases into a hosted environment on either a SQL Server 2000 or 2005 server. It generates a single SQL script file which can be used to recreate a database - both schema and data - in a shared hosting environment where the only connectivity to a server is through a web-based control panel with a script execution window.

Friday, October 13, 2006

New Office 2007 Articles from MSDN

 

Business Contact Manager for Outlook 2007 Developer Guide Microsoft Office Outlook 2007 with Business Contact Manager combines the familiar appearance of Outlook with customer information management to help small business owners track customers and sales opportunities more effectively.

Integrating Office Applications with ASP.NET 2.0 Web Sites Read about how one MVP integrates Microsoft Office Word 2003 and Microsoft Office Excel 2003 with ASP.NET 2.0 Web sites to generate form letters in Word and graphical reports in Excel.

Developing Add-ins (XLLs) in Excel 2007 Learn about Microsoft Office Excel 2007 features that affect XLL add-ins and enable new XLL functionality, as well as changes to the XLL C API itself.

Migrating a Shared Add-in to a Visual Studio Tools for Office Add-In Read this article to learn about issues you might have with existing shared add-ins. Learn how to migrate add-ins to Microsoft Visual Studio 2005 Tools for the 2007 Microsoft Office System and how to convert command-bar code to support the new Ribbon.

Working with Content Controls in Word 2007 View this screencast to walk through using content controls in Word 2007.

Integrating Visio 2007 and Access 2007  Use Automation code to create a Visio drawing from data defining the contents of a drawing and the connectivity between shapes stored within Access tables.

Integrating Visio 2007 and Excel 2007 Visio 2007 and Excel 2007 provide built-in integration capabilities. See an example of linking data in Visio to Excel by using the Visio Data Selector and an example of creating and populating an Excel Bill of Materials by using Automation code.

Creating Custom Task Panes Using Visual Studio 2005 Tools for Office The 2007 release of Office introduces enhanced custom task panes that you can use to provide contextual assistance to your users. Learn how to create custom task panes with Microsoft Visual Studio 2005 Tools for the 2007 Microsoft Office System.

Mutimedia: Building Documents from Scratch Using the Office XML File Formats Watch this webcast to learn about creating documents using

Thursday, October 12, 2006

The Office 2007 Collaboration Platform

 

2007 Office System Document: Working Together in the New World of Work In this white paper, explore the Microsoft communication and collaboration platform and see how it offers a flexible solution set to businesses of all types.

Office 2007 Developer Video: The SharePoint Services Platform

 

2007 Office System Video: Windows SharePoint Services Platform 2007  Learn how Windows SharePoint Services provides the unified server foundation for many of the 2007 Microsoft Office system server capabilities. This download presents videos of  conference sessions including:

  • Microsoft Office "Live" Services: An Overview and Benefits to Developers
  • Microsoft Office SharePoint Designer 2007: Building No-Code SharePoint Solutions
  •  

      Testing SQL Server Rules

      Test the SQL Server Business Rule Chaining Method Chaining database stored procedures to execute business logic in your SQL Server database. This article from TechRepublic.com explains the concept of business rule chaining, and provides an implementation example.

      Tuesday, October 10, 2006

      Office 2007 Client Development How To

      2007 Office System Video: Client Development Download this series of developer-oriented videos to view conference breakout sessions about using the Microsoft Office System client.

      New SQL Server 2005 MSDN Articles

      Using Visual Studio 2005 to Perform Load Testing on a SQL Server 2005 Reporting Services Report Server Visual Studio 2005 Team System includes a load-test tool you can use for performance and stress testing of a SQL Server 2005 Reporting Services deployment. The tool runs the tests you create, and optionally logs the data into a SQL Server 2005 database.

        Designing and Delivering Rich Office Reports with SQL Server Reporting Services 2005 and SoftArtisans OfficeWriter Use SQL Server Reporting Services 2005 and SoftArtisans OfficeWriter to design and deliver full fidelity, data-driven Microsoft Excel and Word reports.

        Monday, October 09, 2006

        Google Launches Code Search Portal

        Google Code Search gives software developers a tool for searching billions of  lines of on-line source code.

        Office 2007 Enterprise Content Management

        Office 2007 System: Enterprise Content Management Download this series of developer-oriented videos to view conference breakout sessions about the new, extensible content management features in Offcie 2007.

        Saturday, October 07, 2006

        Accessing SQL Server 2005 Databases with PHP

        Accessing SQL Server 2005 Databases with PHP  Improve your Web development by configuring the PHP extension with SQL Server 2005 Express Edition databases.

        Thursday, October 05, 2006

        Download Office 2007 Smart Client Development Videos

        2007 Office System Video: Client Development

        Download this series of developer-oriented videos to view conference breakout sessions about using the Microsoft Office System client.

          2007 Office System Video: Business Intelligence

          Download this series of developer-oriented videos to view conference breakout sessions about building smart client and browser-based BI solutions leveraging a wide array of extensible capabilities, including key performance indicators, PivotTables, Web parts, and spreadsheet-based Web services.

          Latest Reources On the Office 2007 GUI

          · Developer Overview of the User Interface for the 2007 Microsoft Office System

          · Download: 2007 Office System Document - Lists of Control IDs

          · Office Noir: Chapter II - The Ribbon Bar

          · Screencast: Extending the Office 2007 UI with a Custom Ribbon

          · Screencast: Extending the Office 2007 UI with a Custom Task Pane

          Tuesday, October 03, 2006

          WinZoomBox - The Easy Way to Edit Smaller Text Boxes


          WinZoomBox v1.1 Freeware 4-Oct-2006 ©2006 Anthony D'Ambra. All rights reserved.

          To overcome my frustrations when editing Windows Shortcut properties, I have developed a new free system applet: WinZoomBox.

          WinZoomBox sits in the Icon Try of your Windows Taskbar. You use the Hot Key combination, Win+Z, to display WinZoomBox wherever you are in Windows or an application to view/edit text at the Cursor location in any edit control where Copy and Paste commands are available. WinZoomBox will pick-up the text in the edit control and display it for editing. After editing, click the Copy To Clipboard button to send the edited text to the Windows Clipboard ready for pasting into the original location. WinZoomBox includes case-sensitive find and replace functionality. Version 1.1 adds Auto-Paste and an alternate Hot Key. Download from aadconsulting.com