excel 2002 problems in windows 7?

[George]

Some time ago, I developed an excel 2002 workbook for someone I knew.
Now, they're converting from XP to Win7, and they tell me the .xls
doesn't work. Specifically, it has a commandbutton that runs some VBA
code, which (button) doesn't respond (at all) when they click on it.
They can enter values in cells, etc.

I'm going to go there and look things over. (All I have is XP.) But,
meantime, if there's an "Oh, yeah, all you've gotta do is ...", please
feel free to share.

Thanks,
George

 

[joel]

Two things to check. first does any macro run. Usually when office i
installed the security settings in Excel is set to high which means n
macro will run. so first try a very simple macro to make sure the macr
will run.

The second thing to watch out is if a PC was upgrade from one versio
of windos or Office to another. Often the library paths do not ge
updated properly. In VBA you may have to manually update the librar
paths. In VBA do do this you have to go into the VBA menu Tools
References and find the library that is associated with the object an
browse for the correct file. I've also have had to do in other place i
excel like that following

1) Worksheet - Insert Object
2) Worksheet Addins - automation
3) VBA userform Toolbox - Right Click - Additional controls


The libraries are either under "Program files - Microsoft Ofice" an
switching from Office9 to Office10 to Office11 to Office12 has caue
problems where the libraries (Dll's) weren't updated properly during a
update.

Make sure all the service packs have been installed for both Office an
Windows. Office 7 is suppose to be a 64 bit operating system and fro
what I have heard microsoft wanted to eliminate the old 16 bit and 3
bit programs. Don't know for sure if that really happened since
haven't used window 7. I think some of the libraries in th
windows\system32 folder may have been eliminated or moved.


I'm don't know which type control buttons you are refereing to. On
worksheet you can have either a control button in the Control toolbo
userform (Active - X button) or in the Forms Toolbar. The active X i
suppose to be old-fashion and microsoft doesn't want people using the
in new macros. Microsoft may have eliminated the DLL's associated wit
the Active-X controls from windos 7. Again not sure but it is
possibility.

 

[Victor Delta]

Some time ago, I developed an excel 2002 workbook for someone I knew.
Now, they're converting from XP to Win7, and they tell me the .xls
doesn't work. Specifically, it has a commandbutton that runs some VBA
code, which (button) doesn't respond (at all) when they click on it.
They can enter values in cells, etc.

I'm going to go there and look things over. (All I have is XP.) But,
meantime, if there's an "Oh, yeah, all you've gotta do is ...", please
feel free to share.

What version of Office/Excel are they using with Win7?

Have macros been disabled?

V

 

[George]

Two things to check. first does any macro run. Usually when office is
installed the security settings in Excel is set to high which means no
macro will run. so first try a very simple macro to make sure the macro
will run.

Yeah - the security was set to "don't run/don't tell". So, no error
msg, even. Thanks.

George