Windows 7 and Excel 2007/VBA Code Error

[ondafringe]

When trying to run your Excel 2007 VBA code on a Windows 7 machine (code that previously ran fine under Vista)...

...if this line:

Set eSig = New IESignal.Hooks

...generates this message:

Error 430: "Class does not support Automation or does not support expected interface"

...use Windows Explorer and browse to the folder where eSig installed, find the winsig.exe file (this is the file I set my Reference to in VBA), bring up Properties for that file, click the Compatibility tab, and set the application to run in XP SP3 compatibility mode.

I was getting the error message and this fixed the problem for me. Just passing it along in case it helps someone else.

George

[lparkh]

Windows 7 and VBA code error

I experienced the same issue in context of windows 7 and Office 2010.
The fix was the same for me though I did at the winros.exe level rather then winsig.