Generic Window/Workbook text

[jase]

Maybe I'm missing something obvious here!
I wrote the following code as part of a routine:

Workbooks(myName).Close False
Kill "I:\" & myName & ".xls"

Problem I have encountered is that in my Window dropdown it says
"Example" whereas in the Window dropdown of other people who use the
spreadsheet it says "Example.xls" !

What would people suggest without changing the settings on either
machine?

Any help greatly appreciated.
Jason

[Tom Ogilvy]

always use the example.xls which works regardless of settings.

--
Regards,
Tom Ogilvy


"jase" <biggest.ears@talk21.com> wrote in message
news:1135766039.534238.164400@o13g2000cwo.googlegroups.com...
> Maybe I'm missing something obvious here!
> I wrote the following code as part of a routine:
>
> Workbooks(myName).Close False
> Kill "I:\" & myName & ".xls"
>
> Problem I have encountered is that in my Window dropdown it says
> "Example" whereas in the Window dropdown of other people who use the
> spreadsheet it says "Example.xls" !
>
> What would people suggest without changing the settings on either
> machine?
>
> Any help greatly appreciated.
> Jason
>

[Martin Fishlock]

you need to check the string and I suggest this:

Workbooks(myName).Close False
Kill "I:\" & myname & IIf(LCase(Right(myname, 4)) = ".xls", "", ".xls")

There may be problems with the drive if it is not saved on I and therefore I
suggest using the following:

mynamefull = Workbooks(myName).FullName
Workbooks(myName).Close False
Kill mynamefull & IIf(LCase(Right(myname, 4)) = ".xls", "", ".xls")
' may even add the .xls on in all cases.

--
HTHs Martin


"jase" wrote:

> Maybe I'm missing something obvious here!
> I wrote the following code as part of a routine:
>
> Workbooks(myName).Close False
> Kill "I:\" & myName & ".xls"
>
> Problem I have encountered is that in my Window dropdown it says
> "Example" whereas in the Window dropdown of other people who use the
> spreadsheet it says "Example.xls" !
>
> What would people suggest without changing the settings on either
> machine?
>
> Any help greatly appreciated.
> Jason
>
>