problem wtih worksheets activate

E

ezil

I am using same office-2003 in two computers but in one computer the
following code only works
workbooks("abc.xls").activate
but in another computer
workbooks("abc").activate only works
But i want to use both the computer changing the code is time consuming
process
How to do this task so that both computer should accept the same code.
Thanks for reply
 
S

Simon Lloyd

ezil;343893 said:
I am using same office-2003 in two computers but in one computer the
following code only works
workbooks("abc.xls").activate
but in another computer
workbooks("abc").activate only works
But i want to use both the computer changing the code is time consuming
process
How to do this task so that both computer should accept the same code.
Thanks for replyAre you sure that there aren't two different files? i.e one "abc" with a
Click to expand...
..xls extension and one "abc.xls" with a .xls extension, in effect the
latter file name would be abc.xls.xls.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
 
Top