Hello!
I am a creator of macros for my workplace, where a majority of the end users are work at home users. There is a macro that works fine for a vast majority of end users but for one, it behaves differently and it actually goes off and does something different. We have a major file where all the macros are housed and have a reloader that will update everyone's macros as needed so everyone should have the same file. I did double check with this member to make sure that everything is identical with what we have on file. I was able to execute this macro flawlessly so there was no issues on my end but this member instead of going to a particular screen, it just kind of sat on a particular screen, arrowed over to the left and right (I believe it was a save dialog box) and then just sat there and did nothing until it brings up a time out box, which I have set for 20 seconds. That was for a different issue but shouldn't be related as again no one else seems to be having this problem.
What makes this puzzling is that it doesn't do it all the time. It will work lines of data (Excel) without any problem and then suddenly a line will be a trouble spot. We skip that line and go onto the next line and it works until the next time it causes an issue.
We all utilize virtual machines in order to run macros so that we can also have those run in the background so other tasks can be done during the day.
Is there something outside of coding that would cause for a macro to behave differently on one person's machine vs another person's? As we are all work at home, could an internet connection cause issues? I'd like to be able to explain this better as we seem to have this issue on a couple of members of the team. Thank you for any assistance anyone can provide.
