We have been rolling out new Windows 7 workstations (all new computers) at
work over the last few months and a strange problem has developed. Prior to
Windows 7 we were using Windows XP with Office 2007.

The problem is, we have a workbook which uses a UserForm for filling in all
required information. Prior to rolling out the new Windows 7 workstations,
the workbook and UserForm were working flawlessly (for over a year) and they
still work flawlessly on the first 3 Windows 7 workstations but on the last
2 workstations we rolled out if you open the UserForm and leave it open for
a few minutes (while you gather some needed information) when you come back
and complete the UserForm and click Finish, it crashes Excel. Also when you
open the workbook you get an error msg saying that corrupt data was detected
but if you trust the source click yes. If you complete the UserForm without
delay Excel does not crash.

Has anyone else out there had an issue like this. IT suspects my code, to
which I respond "well it works fine on the first 3 workstations you rolled
out".

This smells like a malware problem. Make sure your MIS department has
loaded all the windows 7 updates before allowing user to use there
computers. I did a search for the error message you posted on the web
and found a few hits. Here is one of them

'Second Windows 7 beta UAC security flaw: malware can silently
self-elevate with default UAC policy – istartedsomething'
(http://tinyurl.com/awf97r)

The userform in excel runs a DLL in your windows\system32 folder and
RUNDLL32 is often called by these DLLs. I haven't used Windows 7 but
have seen articles on the web that said windows 7 eliminated a lot of
the legacy system32 applications. Not sure of the details what has been
eliminated and what hasn't been eliminated. The system32 executables go
back to the days of DOS and windows 95 and run less efficiently that new
exectables. Microsoft has problems with Vista running slow and looked
for ways of speeding up Windows 7 to avoid having simialr problems that
occured with Vista.

I found other hits on google with similar problems to yours that said
in 2007 the calendar objects in excel had problems and recommended
converting all excel files to xlsx files.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=194554

http://www.thecodecage.com/forumz