One user is receiving error when others are not within the macro

[cubangt]

So we have reports for each of our teams. I have set them all up to automatically update for each of the teams by a simple press of a button within the report.
I have one team that always gets an error and cannot update their report, BUT i can open the same file from the same location and it works for me.

The file is located within our teams app, but we both open it from teams, we both open within the excel app(not teams viewer) and i can click the button and everything updates, but when they click the button the get the below error.

The highlighted line is where the "debug" takes me when trying to test their file.

Is there any improvements i can make to this area of the macro that would help? Is that line written the best it can be? Is there a better way to write that line?

At the moment, i dont hava a file to upload because these reports are so involved, if i try to strip it clean to upload, it may not work at all and introduce new errors..

right now just looking to see if there is anyway to improve this portion of the logic to test with that team.

I can provide the whole routine code here:

Please Login or Register  to view this content.

[6StringJazzer]

Your screenshot does not match the code you posted. My comments below address the code you posted.

The error means that either there is no open workbook named "ChangeRequests" or that the workbook has no sheet called "Page 1".

You are instantiating a workbook object wb but then not taking full advantage of it. The most reliable change to the code will be

Please Login or Register  to view this content.

I think the reason they are getting the error is that you are referring to "ChangeRequests" instead of "ChangeRequests.xlsx". But I don't know why that would only cause an error for some people and not others. Does everyone have the same version of Excel?

[cubangt]

yea that was my poor attempt at changing names up and didnt realize, thats not the issue though..the name in the screen shot is the legit name and the code is my attempt at cleaning out actual names of files and such..

but i will make the tweak on the wb line..

And yes we are all using office365.

[cubangt]

well ill be

the fix was the changing that to wb
all this time i kept looking and looking and that never stood out as the problem.

thank you

[6StringJazzer]

You're welcome and thanks for the rep!

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."