Dear all,

I have the following codes worked prefectly well in Windows 98 and Windows
2000.

with workbooks("Control")
.worksheets("Main").activate
end with

However after I put the excel file onto a Windows XP machine, it does not
work anymore. I need to put extra code on the top of it.

workbooks("Control.xls").activate
with workbooks("Control")
.worksheets("Main").activate
end with

Is this the way how it should be in Windows XP? It would be a nightmare to
me as I would need to make a lot of modification in my program since there
would be quite a lot switching between different workbooks in my program.

Please advise!
Thanks in advance