Worksheet reference does not work on all computers

[zuki]

I have the following strange problem:
In a visual basic code i do references like: Workbooks("WorkbookX").Worksheets("WorksheetY").DoSomething
And they work fine. For some other people when running it does not find the worksheet i.e. gives the same error as if I had written
Workbooks("WorkbookX").Worksheets("WorksheetZ").DoSomething
where WorksheetZ does not exist. It helps if I change to the generic naming in excel i.e. Sheet8, Sheet9 but it would be quite cumbersome to change all references.
Does anyone have an idea?

 

[RoryA]

Are you sure it's the Worksheet reference it's objecting to and not the Workbook one? It's better to supply the extension too:

Workbooks("WorkbookX.xlsx").Worksheets("WorksheetY")

 

[zuki]

The problem was indeed with the extension! You are a genius! Do you know why it is sometimes necessary to include it?

 

[RoryA]

If a computer has Windows Explorer set to show file extensions, you have to include it in your code. If you include it anyway, it will work regardless of the explorer settings.

 

[zuki]

Thank you very much! I have no idea how I would have found out if it was not for you