Using Windows 7 Libraries with Older Excel Versions

I’m what you might call a late adopter. My computers all have Windows XP on them. So if sounds like I don’t know what I’m talking about, well, I don’t. But KeepITCool sent me a Windows 7 tip that just has to be shared.

Ars sez

Windows 7 has a new file management concept called Libraries. … After using the PDC Windows 7 build for a few days now, one feature I have already grown to appreciate is Libraries. The Libraries provide a view of the filesystem that is tailored to specific content types.

KIC reports the Excel 2003 and all versions prior cannot access the contents of these libraries. He writes:

The blockage comes as either an empty folder, or sometimes the error message “Cannot open this location with this program”. My program worked perfectly when running in the VB6 IDE, but failed when running as a compiled addin under excel. So I went digging with the registry monitor, and true enough after a while I found the fiend.

The registry location is HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindowsCurrentVersionShellCompatibilityApplicationsExcel.exe

Either remove the entry STRIPFOLDERBIT or edit the version list to exclude 11.0

This should allow older versions to get at libraries. Someone test this out and leave a comment. Thanks.

Posted in Uncategorized

2 thoughts on “Using Windows 7 Libraries with Older Excel Versions

  1. Not working for me.
    Removed 11.*; – no joy
    Removed STRIPFOLDERBIT value – no joy
    restarted explorer.exe – no joy

    So, no libraries for me in Excel 2003 on Windows 7, but I only use 2003 to check back that things work, I’m full time on 2007 these days.

  2. Why can’t I use Control C to copy formulas from one cell to the next on my windows 7 excel worksheets. I have been use control C to copy and Enter to paste for years. I really don’t like have to use my mouse for everything.

Posting code? Use <pre> tags for VBA and <code> tags for inline.

Leave a Reply

Your email address will not be published.