Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem wtih worksheets activate
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem wtih worksheets activate
ezil;343893 Wrote: 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 ..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) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=96211 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro wtih sumproduct 2 help | Excel Programming | |||
Workbook.Activate / Window.Activate problem | Excel Programming | |||
Help wtih date and time in the same cell | Excel Worksheet Functions | |||
Help needed wtih Vlookup | Excel Programming | |||
How do I use Excel9.olb with computers wtih Excel 97? | Excel Programming |