Blake's profileThe Road to Know WhereBlogListsGuestbook Tools Help

Blake Handler

Occupation
Location
BLAKE is a Microsoft MVP and award winning programmer with over 20 years experience providing complete Windows and networking support for small to medium sized businesses.

BLAKE was also a Personal Technology Coach for residential clients on the Los Angeles West Side.

BLAKE now works full-time for a major media company.

The Road to Know Where

Quick nuggets of technical information in an easy to understand format.
November 19

Microsoft Releases "PowerPivot" Data Analysis Add-in for Excel 2010

 
Microsoft PowerPivot for Excel 2010, is a data analysis add-in that delivers unmatched computational power directly within Excel 2010. PowerPivot gives users the power to create compelling self-service BI solutions.
Take advantage of familiar Excel tools and features:
 
    • Process massive amounts of data in seconds
    • Load even the largest data sets from virtually any source (including Access, Excel, SQL Server…)
    • Use powerful new analytical capabilities, such as Data Analysis Expressions (DAX)
    • Make the most of multi-core processors and gigabytes of memory
Download --> PowerPivot for Excel 2010 (32-bit & 64-bit)
 
 
Download --> PowerPivot Sample Data contains sample data in a variety of formats to help you quickly get started using Microsoft PowerPivot for Excel.
 
November 18

Microsoft Updates Office Filter Packs for Windows 7 & Office 2010 Beta

 
Microsoft Office 2010 (Beta) Filter Packs is a single point-of-distribution for Office IFilters. IFilters are components that allow search services to index content of specific file types, letting you search for content in those files.  They are intended for use with Microsoft Search Services (Sharepoint, SQL, Exchange, Windows Search).
The Filter Pack includes: 
 
    • Legacy Office Filter (97-2003; .doc, .ppt, .xls)
    • Metro Office Filter (2007; .docx, .pptx, .xlsx)
    • Zip Filter
    • OneNote filter
    • Visio Filter
    • Publisher Filter
    • Open Document Format Filter

Microsoft Releases Free Office 2010 Software & Resources

 
Lots of exciting things happening at Microsoft's Office 2010 Beta Website: 
DOWNLOAD MICROSOFT OFFICE 2010 - Client, Web & Mobile
 
    • Download --> Microsoft Office Professional Plus 2010 - With Microsoft Office Professional Plus 2010, your people get a wide range of powerful new ways to do their best work from more places – whether they’re using a PC, smartphone or web browser. From insightful updates to Excel, PowerPoint, Word and Outlook, to new server integration capabilities that make it easier for everyone to track, report and share vital information, Office Professional Plus 2010 offers the complete package through familiar, intuitive tools.
What's Included:
 
    • Access  
    • Communicator 
    • Excel
    • InfoPath 
    • OneNote  
    • Outlook  
    • PowerPoint  
    • Publisher  
    • SharePoint Workspace 
    • Word   
Download --> Microsoft Office 2010 Also Available in:
 
  • Download --> Microsoft Office 2010 Web Apps (Beta) are online companions to Microsoft Word, Excel, PowerPoint, and OneNote, enabling people to access and do light editing or sharing of Office documents from virtually anywhere. 

  • Download --> Office Mobile 2010 (Beta) brings the powerful Microsoft Office 2010 tools you use every day at work, home, or school, to the screen of your Windows phone with rich interfaces especially designed for small devices.
Features:
 
    • View and edit your Microsoft® Office documents with confidence.
    • Stay connected to work from anywhere with SharePoint Workspace Mobile.
    • Stay connected to work from anywhere with SharePoint Workspace Mobile.
    • Use PowerPoint Mobile as a presentation aid.
 
ACCESS 2010:
 
    • Access 2010 Office System Driver: Data Connectivity Components installs a set of components that can be used by non-Microsoft Office applications to read data from and write data to 2010 Office system files such as Microsoft Access 2010 (mdb and accdb) files and Microsoft Excel 2010 (xls, xlsx, and xlsb) files. Connectivity to text files is also supported.  ODBC and OLEDB drivers are installed for application developers to use in developing their applications with connectivity to Office file formats.
    • Access 2010 Beta Download: Access Runtime provides a rich platform for developing database management solutions with easy-to-use customization tools. If no end-user customization is required (including report modifications), you can choose to distribute those Access 2010 solutions so that they run without requiring a full installation of Access 2010 . To do so, you must package and distribute your application with the Access 2010 Runtime.
 
EXCEL 2010:
 
    • Excel 2010 Add-In for Manipulating Points on Charts (MPOC) - Microsoft's Excel Team felt the ability to directly resize or reposition points on a chart had deprecated since Excel 2003.  For example, in Excel 2003 double-clicking on a data point in a column chart would reveal surface handles that could be used to resize the columns, or visually smooth the curves.  In an effort to restore this lost functionality, they have developed a sample Add-In that can be used in both Excel 2007 and Excel 2010.  (From: MSDN)
    • PowerPivot for Excel 2010, is a data analysis add-in that delivers unmatched computational power directly within Excel 2010. PowerPivot gives users the power to create compelling self-service BI solutions. (Support: PowerPivot Help File, PowerPivot Sample Data)

OUTLOOK 2010:
 
    • Business Contact Manager for Outlook 2010 Beta (32-bit64-bit) provides contact management, sales, marketing and project management for the small business or small team. 
Business Contact Manager for Outlook 2010 Database Tool (Beta) allows administrators to host Business Contact Manager for Outlook 2010 Beta database on a computer on which Microsoft Office 2010 Beta and Business Contact Manager for Outlook 2010 Beta are not installed.  
 
Business Contact Manager Language Packs (32-bit & 64-bit
    • VDialer is a CodePlex add-in that allows you to initiate a Vonage call directly from the Outlook contact list or contact item. Just select the contact you want to call and your phone will start ringing - as soon as you pick up the phone call is placed. 
       
POWERPOINT 2010:
 
    • Deploying Broadcast Slide Show - Broadcast Slide Show is a new capability in Microsoft Office 2010 that enables presenters to broadcast a slide show from PowerPoint 2010 to remote viewers who watch in a Web browser. Broadcast Slide Show provides companies with a low-infrastructure presentation broadcast capability that works through the Web. This paper provides a summary of this capability for SharePoint system administrators and IT managers and prepares them to effectively evaluate, plan for, and implement Broadcast Slide Show in their environments. 
    • Presentation Companion 1.0 [Beta] works with Microsoft Office PowerPoint Mobile to control a PowerPoint presentation on your laptop, as well as view speaker notes on your Windows phone as you control the presentation.
Download --> Microsoft Project Professional 2010 Beta (32-bit64-bit) - Microsoft Project Professional 2010 Beta gives you powerful, visually enhanced ways to successfully manage and deliver a wide range of projects. Easier and more intuitive, Project Professional 2010 Beta provides flexible choices to simplify planning, collaboration and resource management.
    • Project 2010 Reference: Software Development Kit (SDK) is a beta release helps solution providers, value-added resellers, and other developers learn about new features in the Project Server 2010 platform, and how to extend and integrate Project Server 2010 with other applications for enterprise project management (EPM). It features conceptual and "How to" articles, sample code, and programming references for the Project 2010 clients and Project Server 2010.
 
Download --> Microsoft Visio Premium 2010 Beta (32-bit64-bit) takes diagramming to a new level with dynamic, data-driven visualization tools and templates, enhanced process management capabilities, and advanced Web sharing. Bring real-time data together from multiple sources, including Excel and Microsoft SQL Server, in one powerful diagram using vibrant graphics like icons and data bars. Manage processes with sub-processes and rules and logic validation to ensure accuracy and consistency across the organization. Create SharePoint workflows and export them to Microsoft SharePoint Server 2010 for real-time execution and monitoring. Share refreshable, data-linked diagrams over the Web with anyone, even those who don’t own Visio.
    • Visio 2010 (Beta): Software Development Kit contains the latest documentation, samples, header files, libraries and tools that you need to develop custom solutions for Visio 2010 (Beta).
    • Visio 2010 (Beta) Viewer allows anyone to view Visio drawings and diagrams (created with Visio 5.0, 2000, 2002, 2003, 2007, or 2010) inside their Internet Explorer version 5.0 or later Web browser. 
 
OFFICE 2010 TOOLS:
 
    • Microsoft Office ScreenTip Language (32-bit64-bit) language and help users navigate Microsoft Office applications installed in a language they do not understand.
    • Office 2010 (Beta) Administrative Template files (ADM, ADMX/ADML) and Office Customization Tool includes updated Group Policy Administrative Template files and Office Customization Tool OPA files for use with Office 2010 (Beta) applications. It also includes an \Admin folder with an updated Office Customization Tool, and ADMX, ADML, and ADM versions of Office 2010 (Beta) system Administrative Template files for Windows Vista and Windows Server 2008. For administrative template files, you may use the ADM files for any Windows operating system, or the combination of ADMX and language-specific ADML files on computers running at least Windows Vista or Windows Server 2008. This download also includes a workbook (Office2010GroupPolicyAndOCTSettings.xls) that provides information about Office 2010 (Beta) Group Policy settings and OPA settings.
    • Microsoft Office 2010 KMS Host License Pack contains an executable file that will extract and install KMS (Key Management Service) host license files. These license files are required for the KMS host service to recognize Office 2010 KMS host keys. It will also prompt you to enter your Office 2010 KMS host key and activate that key. After this is done, you may need to use the slmgr.vbs script to further configure your KMS host.
    • Microsoft Office 2010 (Beta) Filter Packs is a single point-of-distribution for Office IFilters. IFilters are components that allow search services to index content of specific file types, letting you search for content in those files. They are intended for use with Microsoft Search Services (Sharepoint, SQL, Exchange, Windows Search).
The Filter Pack includes:
 
    • Legacy Office Filter (97-2003; .doc, .ppt, .xls)
    • Metro Office Filter (2007; .docx, .pptx, .xlsx)
    • Zip Filter
    • OneNote filter
    • Visio Filter
    • Publisher Filter
    • Open Document Format Filter
 
OFFICE 2010 DEPLOYMENT RESOURCES:
 
    • 64-bit Client Installation of Microsoft Office 2010 describes and illustrates the 64-bit client installation of Microsoft Office 2010. Elements include setup overview, processes, requirements, deployment considerations, and supported scenarios.
    • Deployment Options for Microsoft Office 2010 - describes and illustrates the client deployment methods for Microsoft Office 2010. Deployment options include network share, Group Policy startup scripts, managed deployment, and virtualization.
    • Deploy Multilanguage Packs for Microsoft Office 2010 - describes and illustrates how to deploy multilanguage packs for Microsoft Office 2010. Elements include evaluation criteria, planning considerations, and deployment tasks.
    • Deploy Office Web Apps - Office Web Apps are online companions to Microsoft Word, Microsoft Excel, Microsoft PowerPoint and Microsoft OneNote applications that allows users to access documents from anywhere. Users can view, share, and work on documents with others online across personal computers, mobile phones, and the Web. Office Web Apps are available to users through Windows Live and to business customers with Microsoft Office 2010 volume licensing and document management solutions based on Microsoft SharePoint Server 2010.
    • Microsoft Office 2010 Deployment Kit for App-V is required for sequencing and deploying Office 2010 client products with Microsoft Application Virtualization (App-V). This kit includes the components required for Office license activation. This product must be installed on the App-V sequencing station prior to monitoring the Office 2010 client installation. This product must also be installed on the client machines to which virtualized Office 2010 client packages will be deployed.  
 
OFFICE 2010 DEVELOPER REFERENCE:
 
- Combined Office 2010 developer references
- Access 2010 Developer Reference
- Excel 2010 Developer Reference
- Outlook 2010 Developer Reference
- PowerPoint 2010 Developer Reference
- Project 2010 Developer Reference
- Publisher 2010 Developer Reference
- Visio 2010 Automation Reference
- Visio 2010 ShapeSheet Reference
- Word 2010 Developer Reference
 
MICROSOFT OFFICE 2010 TEAM BLOGS:
 
 
MICROSOFT OFFICE 2010 APPLICATION BLOGS:
 
November 17

Advantages & Disadvantages of Microsoft Office 2010 64-Bit Version

 
Microsoft has documented the advantages & disadvantages of installing Microsoft Office 2010 64-Bit Version.
Advantages - Running Office 2010 64-bit provides the following advantages:
 
    • Ability to utilize additional memory.
    • Excel 2010 can load much larger workbooks. Excel 2010 made updates to use 64-bit memory addressing to break out of the 2-GB addressable memory boundary that limits 32-bit applications.
    • Microsoft Project 2010 provides improved capacity, especially when you are dealing with many subprojects to a large project.
    • Enhanced default security protections through Hardware Data Execution Prevention (DEP).
 
Disadvantages - The following issues might affect compatibility:
 
    • Microsoft Access MDE/ADE/ACCDE files - Databases that have had their source code removed (such as .mde, .ade, and .accde files) cannot be moved between 32-bit and 64-bit editions of Office 2010. Such databases that are created by using 32-bit Office (any version) can be used only with 32-bit Office, and a database that is created on 64-bit Office can be used only on 64-bit Office.

    • ActiveX controls and COM Add-ins - ActiveX controls and add-in (COM) DLLs (dynamic link libraries) that were written for 32-bit Office will not work in a 64-bit process. As a result, Office 2010 64-bit solutions that try to load 32-bit ActiveX controls or DLLs will not work.

      In addition to controls that load into Office applications, there are also Web-based solutions that use ActiveX controls in Microsoft Internet Explorer. Office 2010 64-bit editions install Office 32-bit clientside controls for supporting Web solutions in a browser. The workaround for resolving these issues is to obtain 64-bit compatible controls and add-ins or to install Office 2010 32-bit (WOW).

    • Office Graphics (OArt) - For Excel integration, conversion of OLE, form controls, and ActiveX to CompatE2os in Excel 2010, some controls are not available in 64-bit Office 2010. An example is the Microsoft Date and Time Picker Control 6.0 (SP4), which is accessed on the Excel 2010 Developer tab, by clicking Insert, and selecting More Controls under ActiveX Controls section.

      Graphics rendering. There are differences between the 32-bit and 64-bit Graphics Device Interface (GDI) that might have performance implications because of the lack of MMX support on 64-bit. Intel's MMX technology is an extension of the Intel architecture (IA) instruction set. The technology uses a single-instruction, multiple-data (SIMD) technique to speed up multimedia and communications software by processing data elements in parallel.

    • Visual Basic for Applications (VBA) - VBA code that uses the Declare statement to access the Windows application programming interface (API) or other DLL entry points will see differences between 32-bit and 64-bit versions. The Declare statement must be updated with the PtrSafe attribute after inputs and outputs to the API have been reviewed and updated. Declare statements will not work in 64-bit VBA without the PtrSafe attribute. New data types are added to 64-bit Office 2010 VBA: LongLong and LongPtr.
 
General Feature Deprecations - The following section lists feature deprecations:
 
    • Microsoft Access - The Replication Conflict Viewer is removed from both the 32-bit and 64-bit installations of Office 2010.  This functionality can still be implemented by using a documented custom function, ReplicationConflictFunction. For information, see the Access 2007 Developer Reference.
    • Publisher - The Microsoft Works database converter (wdbimp.dll) is removed from both 32-bit and 64-bit installations of Office 2010. This converter was previously used in the Mail Merge functionality to connect to a data source created in Microsoft Works.
    • Word - Microsoft Office Document Imaging (MODI) and all its components are deprecated for both 32-bit and 64-bit Office 2010. The legacy Equation Editor is not supported on 64-bit Office 2010, but is supported for 32-bit Office 2010 installations (WOW64).  WLL (Word Add-in libraries) WLL files are deprecated for both 32-bit and 64-bit Office 2010. A WLL is an add-in for Microsoft Word that you can build with any compiler that supports building DLLs.
November 16

Listen to "KROQ's Almost Acoustic Christmas 2009" Channel on Play.It

 
KROQ's Almost Acoustic Christmas 2009 will be streamed live in a few weeks -- so until then I've create a new channel on Play.It to listen to this year's line-up!
This Year's KROQ's Almost Acoustic Christmas 2009 Line-up:
DECEMBER 12th
 
  • AFI
  • Rise Against
  • Alice In Chains
  • 30 Seconds to Mars
  • Three Days Grace
  • Anberlin
  • Dead By Sunrise 
DECEMBER 13
 
  • Muse
  • 311
  • Slightly Stoopid
  • Phoenix
  • The Bravery
  • Metric
  • Vampire Weekend
  • Cage the Elephant
  • White Rabbits

Listen Now -->  KROQ's Almost Acoustic Christmas 2009

 
Full Disclosure: I provide KROQ with on-site I.T. Support for this event, so I'm a bit biased about the music! (^_^)
 
Thanks for visiting The Road to Know Where!
 
Please Leave a Comment. (^_^)
Please wait...
Sorry, the comment you entered is too long. Please shorten it.
You didn't enter anything. Please try again.
Sorry, we can't add your comment right now. Please try again later.
To add a comment, you need permission from your parent. Ask for permission
Your parent has turned off comments.
Sorry, we can't delete your comment right now. Please try again later.
You've exceeded the maximum number of comments that can be left in one day. Please try again in 24 hours.
Your account has had the ability to leave comments disabled because our systems indicate that you may be spamming other users. If you believe that your account has been disabled in error please contact Windows Live support.
Complete the security check below to finish leaving your comment.
The characters you type in the security check must match the characters in the picture or audio.
i WANT TO DOWNLOAD  MICROSOFT OFFICE 2007 FOR MY EXERSISE§

Nov. 12
Ajithwrote:
Thank you so much.. lots of useful stuff..., your site is one of my home page tab
Oct. 30
aliwrote:
thank you alot
Oct. 24
  Thanks i have actually been Some where that helps
Oct. 21
Yvonwrote:

Good Stuff, now I know where!

Oct. 20