Can someone explain to me? Pls?
 

My platform is Windows XP and is using excel 97 macros. My supervisor i
using Windows 98 and is also using excel 97 macros. The strangest thin
is that she can open the excel file(.xls) using .activate while I hav
to use the workbooks.open to open an existing excel file(.xls). O
maybe I have missed out something in the midst can someone fill me i
this one and point me to some links about the difference of usin
macros in Windows XP and Windows 98????? Cause I already have problem
popping up ever since I have switched to windows XP platform. :(

In case anyone wants to know what I mean, here is the code:

windows("files.xls").activate = for Windows 98, Pentimum II

Workbooks.Open filename:="D:\files.xls" = for Windows XP, Pentimum

--
stevetan201
-----------------------------------------------------------------------
stevetan2010's Profile: http://www.excelforum.com/member.php...fo&userid=1624
View this thread: http://www.excelforum.com/showthread.php?threadid=27895

Can someone explain to me? Pls?
 

Hi
normally there's no difference in the use of these wo Operating systems
together with Excel macros. I would guess for her the file is already opened

"stevetan2010" wrote:


My platform is Windows XP and is using excel 97 macros. My supervisor is
using Windows 98 and is also using excel 97 macros. The strangest thing
is that she can open the excel file(.xls) using .activate while I have
to use the workbooks.open to open an existing excel file(.xls). Ok
maybe I have missed out something in the midst can someone fill me in
this one and point me to some links about the difference of using
macros in Windows XP and Windows 98????? Cause I already have problems
popping up ever since I have switched to windows XP platform. :(

In case anyone wants to know what I mean, here is the code:

windows("files.xls").activate = for Windows 98, Pentimum II

Workbooks.Open filename:="D:\files.xls" = for Windows XP, Pentimum 4


--
stevetan2010
------------------------------------------------------------------------
stevetan2010's Profile: http://www.excelforum.com/member.php...o&userid=16240
View this thread: http://www.excelforum.com/showthread...hreadid=278958

Can someone explain to me? Pls?
 

Depending on your Windows Explorer "Hide extensions for known file types"
setting, Excel will have a different window title.
When ticked, window title will be "Book1"
When unticked, window title will be "Book1.xls"

From Windows Explorer, Tools | Options | View

Try something like: Workbooks("Book1.xls").Activate


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"stevetan2010" wrote in message
...

My platform is Windows XP and is using excel 97 macros. My supervisor is
using Windows 98 and is also using excel 97 macros. The strangest thing
is that she can open the excel file(.xls) using .activate while I have
to use the workbooks.open to open an existing excel file(.xls). Ok
maybe I have missed out something in the midst can someone fill me in
this one and point me to some links about the difference of using
macros in Windows XP and Windows 98????? Cause I already have problems
popping up ever since I have switched to windows XP platform. :(

In case anyone wants to know what I mean, here is the code:

windows("files.xls").activate = for Windows 98, Pentimum II

Workbooks.Open filename:="D:\files.xls" = for Windows XP, Pentimum 4


--
stevetan2010
------------------------------------------------------------------------
stevetan2010's Profile:
http://www.excelforum.com/member.php...o&userid=16240
View this thread: http://www.excelforum.com/showthread...hreadid=278958

Can someone explain to me? Pls?
 

Hi,
windows("files.xls").activate = for Windows 98, Pentimum II
You have not specified the path where file is located. Still it opens the
workbook?
I don't think so. For Windows().Activate the file must be already open.
Otherwise
you will get error, 'Subscript out of range.'


Workbooks.Open filename:="D:\files.xls" = for Windows XP, Pentimum 4
This makes senses.

Sharad