Is there any known reason a user of workbook would get the error code 91, but someone else does not?
I cannot really debug the code since I am not getting the error and it's not practical for me to be at the users' machine, nor for me tell them which step to take to help me debug it.
Thanks in advance for your help.
Do you know where they get the error?
If posting code please use code tags, see here.
As soon as the user opens the files. They can't see the codes since they are protected and I can't give them the password unfortunately.
Last edited by wilnexpc; 07-23-2013 at 02:17 PM.
It's kind of hard to help then I'm afraid.
There could be a numbe of reasons for that error and it could occur in various places in the code.
Does the user with the problem have any differences in settings?
I am pretty sure they would have different settings, they are a client company of ours.
My plan is to test the workbook at home on my personal machine and see if I get the same error.
Last edited by wilnexpc; 07-23-2013 at 02:29 PM.
It turned out they were using a different version of excel than I am. There some missing libraries in the Reference Library under Tools in the VBE. Fixing that took care of the problem. A guy named Rollin helped me out.
Thanks again Norie, your pointing out the possible difference in settings help solve the problem
Last edited by wilnexpc; 07-24-2013 at 11:18 AM.
Glad to hear you got it sorted.
I wondered if it was a reference problem but assumed you had checked that.
I am fairly new at this, and work on and off with VBA, so I still have a lot to learn.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks