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.
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.