Macro Not Working For All Users

[snehpetselyk]

I've created a macro that runs from a commandbutton click. The macro opens 3 other files off a network drive, does a save-as (new filename is based on text in a cell), clears some fields, saves and closes all workbooks.

I can run the macro with no problems under my user login, on any machine. All other users get an error after all files are opened, while it is trying to do the save-as. Stepping through the macro, nothing after that point will work for them (clearing fields etc.), on any machine except mine (the machine the code was written on).

What could be causing this?

thanks,
Kyle

 

[Joe4]

Welcome to the Board!

What exactly does the error message say?
Are you are all on the same version of Excel?
Do you have the same references selected in VB?

 

[PCL]

When the files are opened, does manual manipulations working: Delete, Cut .... just to be sure that access is enable

 

[snehpetselyk]

Welcome to the Board!
What exactly does the error message say?
Are you are all on the same version of Excel?
Do you have the same references selected in VB?

Error code is;
"Run-time error '9'
Subscript out of range"

We are all using office 2013 or 365 whatever its called.

I'm not exactly sure what this means. The referenced sheets that are unable to be save-as are the ones the macro just opened.

 

[snehpetselyk]

When the files are opened, does manual manipulations working: Delete, Cut .... just to be sure that access is enable

Yes, the users can delete, update, etc. manually, and even save or save-as manually. Just not with the code.

 

[Joe4]

On a version that works:
- Go to the VB Editor
- Click on the Tools menu, then select References
- Note all the references/libraries that are selected

On a version that doesn't work:
- do the same steps as above, compare the two, and note any references/libraries that are not selected

Regarding your error, does it give you a "Debug" option?
If so, when you click it, what line of code does it highlight?

It probably would be beneficial if you could post the code here, too.

 

[snehpetselyk]

On a version that works:
- Go to the VB Editor
- Click on the Tools menu, then select References
- Note all the references/libraries that are selected

On a version that doesn't work:
- do the same steps as above, compare the two, and note any references/libraries that are not selected

Regarding your error, does it give you a "Debug" option?
If so, when you click it, what line of code does it highlight?

It probably would be beneficial if you could post the code here, too.

Thanks for the info on references. All references are the same.

The error does give a debug option, and the code it references is a save-as statement.

Workbooks(LrDate & "_data").SaveAs ("\\fullpathname_" & NrYear & "\Working_Folder\" & NrDate & "_data.xlsm")

 

[Joe4]

Are you sure that the users have the file path that you are building accessible to them on their computer?

 

[snehpetselyk]

Are you sure that the users have the file path that you are building accessible to them on their computer?

Yes, the users have access to the file path. They can run the code just fine from my machine with their user login, but no other machine will work for them. I can run the code from any machine with my login. Doesn't make sense to me.

 

[Joe4]

Note that file/drive mappings are not only user specific, but can also be computer specific.