I'm having an issue in VBA. I have macros that have been working fine in MS Excel 2010. However, when I made minor changes such as change the path of a file location which I used MS Excel 2013, then ran it back on another computer with 2010, it worked for a little while. But now I receive errors when the macros are ran. The error reads Can't load DLL. I'm not sure what it's referring to. When it attempts to repair it reads that it's not recoverable. When I look at the macros, all the names changed such as macro 1, macro2, etc. instead of the actual names that were created. Why could this be happening? Where can I look to find the error? Is there something like a code analyzer that I can run?
Thank you so much.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.