Runtime error occurs only on 1 out of 4 workgroup users

[gulaoye]

I have macros running smoothly on a workbook that is shared by several users. An unusual runtime error pops up when the same code was executed on a new user recently added to the workgroup.

The error is "Subscript out of range", came upon when executing the following line:

Workbooks("POMacros").saved = True


POMacros is an empty Workbook that stored the VBcodes linked to buttons on a Custom ToolBar , it is opened ReadOnly (automatically from my auto start codes embedded in the workbooks which loads the Toolbar.)

All the files involveed are located under the same path and are shared by workgroup users through a wireless connection. This line gets by fine with all other users.

The versions of Excel running on each machine vary, however, the one that produced this runtime error had the same version (2002) installed as another one that worked fine.

It really puzzles me . . . and it's annoying.

[Kuskush]

The error is "Subscript out of range", came upon when executing the following line:

Please Login or Register  to view this content.

The error occurs because of different settings in the Windows-Explorer (Menue: Extras > Options > show/hide File name extensions).

You should change the code by including the File extension .xls. Then it will work whatever setting is selected.

Please Login or Register  to view this content.

[gulaoye]

I had tried putting in full path with extension, for some reason the procedure came to a halt - but it didn't issue the runtime error that time. I should have followed through and looked into it.

But it certainly was the root of the problem and working fine now after I added the extension.

Thanks a lot.