check your initialization code for calls that Excel does not allow during the load process.If you have a test program that runs perfectly - but then you add the working code to your Excel Add-in and get the "This file could be corrupted or unsafe" message. It's not the simple DLL load that we expect when we're writing code to be loaded by a normal process.
I thought I had a 64-bit problem, but I'm beginning to wonder if I have a Windows 7 problem. IESHIMS.DLL // Typical from my Windows XP experience on working XLLs API-MS-WIN-CORE-WINRT-STRING-L1-1-0.DLL API-MS-WIN-CORE-WINRT-ROBUFFER-L1-1-0.DLL XLCAL元2.DLL // Typical from my Windows XP experience on working XLLs Run "Dependency Walker for Win64(圆4) Version 2.2.600, Developed by Steve P. Install Microsoft Visual C++ 2012 Redistributable (圆4) - 6. Install Microsoft Visual C++ 2010 圆4 Redistributable - 9. The file could be corrupted or unsafe." (If I say "Yes" it loads it like a text file, showing me binary code in the XLL in the spreadsheet.)īased on previous (Windows XP/32) XLL experience, this message can mean almost anything - including a lack of required DLLs.
No functionality from Generic.xll appears.Ĭlose and reopen Excel - upon reopening, I get a message box saying "The file format and extension of 'GENERIC.xll' don't match. It loads silently, no messages (including no message saying it loaded Generic.xll) SET PLATFORM=圆4 // I think this was preset anywayĬd C:\2013 Office System Developer Resources\Excel2013XLLSDK\SAMPLES\FRAMEWRKĬd C:\2013 Office System Developer Resources\Excel2013XLLSDK\SAMPLES\GENERICĬopy the resulting C:\2013 Office System Developer Resources\Excel2013XLLSDK\SAMPLES\GENERIC\圆4\RELEASE\GENERIC.xll to a network folder accessible by the Windows 7/64 computerįile - Options - Add-ins - Manage Excel Add-ins - Browse, go to the network folder containing Generic.xll, click it.Īllow Excel to copy Generic.xll to the standard folder. Start Menu - "Open Visual Studio 圆4 Cross Tools Command Prompt (2010)" On my Windows XP/32 machine, where I have Visual Studio 2010 Professional installed:ĭownloaded & installed the Microsoft Excel 2013 SDK.
Here's the simpliest version of what I've done - sorry this is long and pedantic. I'd now like to create a Windows 7/64 bit version and am having trouble - I can't even get the Generic.xll example to work. I'm not a skilled Windows programmer, but I created and have been maintaining an XLL add-in for 32-bit Windows XP / Excel for many years.
0 kommentar(er)
