Windows Name Now Has Changed ?

[sbmaurer]

Hello and happy Friday to everyone,

This may be a very simple question.

Somehow the name of my excel windows have changed to including a ".xlsm" at the end.

Specifically I used to be able to reference a window by writing

Windows("BIA Master Drop Down List").Activate

Now I need to reference by writing

Windows("BIA Master Drop Down List.xlsm").Activate

Can anyone shed some light as to how this changed, is there some setting that I turned on or off? I would like to know because on another users machine the code will not work because of this mis-naming.

Cheers!

 

[JLGWhiz]

Hello and happy Friday to everyone,

This may be a very simple question.

Somehow the name of my excel windows have changed to including a ".xlsm" at the end.

Specifically I used to be able to reference a window by writing

Windows("BIA Master Drop Down List").Activate

Now I need to reference by writing

Windows("BIA Master Drop Down List.xlsm").Activate

Can anyone shed some light as to how this changed, is there some setting that I turned on or off? I would like to know because on another users machine the code will not work because of this mis-naming.

Cheers!

It is probably in your Windows application settings(Control Palnel), where you can opt to show file extensions or not. If you opt to show the file extension, then you must use it in your code because it is part of the file name.
And it will apply to all applications, Word, power point, Outlook, etc.

 

[shg]

The latter syntax will always work, so it is greatly preferable.

 

[Gary's Student]

Good answer...............additionally you can always tell which form to use by examining the Caption:

Sub marine()
MsgBox Application.ActiveWindow.Caption
End Sub

 

[sbmaurer]

Hello,

Thanks everyone this certainly solves the problem. Two key things to mention.

1) Went to the control pannel and restored default settings and that did change the name of the window
2) Used the latter syntax above with the ".xlsm" extension and the code works on all types of window naming conventions


Thanks for the help,

Cheers!

 

[shg]

You're welcome.