Macro won't run in the newer version

[Guest]

Ever since I had newer version of Excel installed I can’t run macro
which was executing perfectly before an update.
Excel version: 2003 SP2
VB version: 6.3 9972

Below is the code, which always shows as a stopper ….

Workbooks("SummaryMaster2").Activate
Workbooks("SummaryMaster2").Sheets("Main").Select

And the error message is
“Run-time error ‘9’
Subscript out of rangeâ€


Any help will be greatly appreciated.

TC

 

[Don Guillett]

Are you sure? Did you forget .xls?

with Workbooks("SummaryMaster2.xls")
.Activate
.Sheets("Main").Select
end with

 

[Guest]

Don,

Thank you for responding. I had tried this before and
it didn't work. I had tried one more time as you suggested below
but it didn't work. Could you suggest anything else?
This macro is working on version SP1
I'll appreciate any help.

Teresa

 

[Don Guillett]

What I proposed should work if your Summary.xls is OPEN.

 

[Guest]

Thank you Don.

I had forgotten about other places in the program that
should be changed as well. Your advice did help somehow,
although I think there must be other problems.
It did started the program however the macro is not
being executed as was the case in my older version.
Would you know of any change in syntax conventions?
Or, do I need any additional program tools installed on my computer?
Thank you enormously for your help.
Any other suggestions will be welcomed.
Thank you.

Teresa