Run-time error 91

I have a question. At my workplace, I have an Excel file containing a list of Excel files and their corresponding tab sheet numeric names. With another macro, I check the excel planning file to verify if the numbers on the planning sheet match the overview list.

On workstation 1, the macro for checking the planning works correctly.
On workstation 2, the macro for checking the planning works correctly.
On workstation 3, I encounter a "Run-time error 91" related to a tab sheet name in the planning file.

The Excel version is the same on all workstations.
The files we are working with are exactly the same.
The settings for both Excel versions are identical.

My specific question is, what could be the cause of receiving this "Run-time error 91" on workstation 3? Does anyone have any ideas?

There are a few possible reasons why you might be receiving a "Run-time error 91" on workstation 3, even though the Excel version and settings are the same on all workstations:

• The tab sheet name in the planning file on workstation 3 may contain special characters that are not supported by the macro. For example, the tab sheet name may contain a space, a hyphen, or an underscore. You can try removing any special characters from the tab sheet name and see if that resolves the error.
• The tab sheet name in the planning file on workstation 3 may be too long. The maximum length for a tab sheet name is 31 characters. If the tab sheet name is longer than 31 characters, you can try shortening it and see if that resolves the error.
• The tab sheet name in the planning file on workstation 3 may be the same as the name of a worksheet function. For example, the tab sheet name may be the same as the name of the SUM function or the AVERAGE function. You can try changing the tab sheet name to something unique and see if that resolves the error.

Thank you very much for your message. I did indeed check these steps. Unfortunately, they didn't yield any results. The macro is located in a file that can be opened on all three workstations. The planning file is identical on all three workstations. That's why I'm having trouble understanding the issue. If it were a code error, I would expect to receive an error message on all three workstations. If it were an issue with the planning file, I would also expect to receive the error message on all three workstations. Am I reasoning this incorrectly? Could it possibly be a settings-related issue?

I'm confident that it's a 91 error message. The error message '91' is occurring on this line: Set ws = wb.Sheets("Line 1").

Certainly! Here's a friendly message in English:

Indeed, I'm getting the message "wb" variable has not been set while I have defined "wb" as Workbook. Because a new Excel file needs to be checked every week, I'm using the Application.FileDialog(msoFileDialogFilePicker) to select the new file. Could this be the cause? This is my code:

Please Login or Register  to view this content.