Error in Executing a simple macro

[YCJ]

Hi all

I'm kinda puzzled by this issue. My macro works great in my own pc, it is a report generator, I tested it on another 2 pc, no problems at all, however, when I used it on one particular pc, this execution fails.

Windows(fileName).Activate

I looked at it, there wasn't any problem at all. The windows with the title fileName is already opened, I just wanted to activate it because I was copying data from another window. The fileName has no error, however it just won't work. Other pc works just fine. It wasn't microsoft excel version difference anyway, we were using the same version in the office. The error is Run Time error 9: Subscript out of range. I don't know exactly how this happen. Help is very much appreciated.

Thanks for your time,
CJ

 

[Cindy Ellis]

Just a guess...but some people choose to hide extensions of files of a known type, and others choose to show the extensions. Take a look at the entire window name...see if there's a difference between the entire displayed filename in the banner.

 

[YCJ]

Thanks a lot! You solved my problem, it seems that it was the extension problem that caused the issue.

Have a nice day,
CJ

 

[Richard Schollar]

It's fairly rare that you ever need to refer to workbooks via Windows() - if you use Workbooks() instead you should avoid this problem

 

[YCJ]

Oh, meaning if I use Workbooks(), it would not care about it's extensions at all?

CJ