Can someone explain to me? Pls?

[stevetan2010]

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

 

[Guest]

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

 

[Rob van Gelder]

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

 

[Sharad Naik]

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