INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Macro issue in Excel

Macro issue in Excel

(OP)
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?

Please advise.
Thank you so much.
Kyle

RE: Macro issue in Excel

"Can't load DLL" usually means you have lost a reference to stuff that VBA needs to execute your macros. Is there more to the message? You may need to reload Excel 2010.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Macro issue in Excel

Download process monitor https://docs.microsoft.com/en-us/sysinternals/down...

Run it up - you may need admin permissions.
Set the item to be monitored to excel.
Run your macro

Have a look at the trace - it will tell you where is is looking for the DLLs and which ones it cannot find.

RE: Macro issue in Excel

(OP)
Hello TheAceMan1 and everyone else.
No, I haven't compiled first. I never went into much VBA in Excel. Funny though, when I was in school for VBA, I knew better to compile first. I guess It can compile under the version and computer that it's currently on. I let you know the results.

RE: Macro issue in Excel

(OP)
Hello,

What happened is that I used a later version of MS Office (2013) on my pc to revise the macros. Then I attempted to run it on the network at my job which is using 2010. The DLL, that is was looking for was pointing to a directory on the C: drive that didn't exist at work. I tried to uncheck it in References under the VBA module where it read 'missing'. But no matter how many times I unchecked it and checked off the correct one, that box 'missing', ends up being checked off again. I tried to create a folder and move the missing DLL file to it, to satisfy and correct the error. However, I needed Admin rights to the Root directory which I do not have. As a resolution, I used an old existing file already on the computer at work and modified the code manually and moved whatever tabs that were needed to that one. Now it works okay. My lesson learned, leave the projects to be done at work.

Thanks for your assistance

RE: Macro issue in Excel

Alternatively install the work version on a VM. My setup is the other way round - I have 2010 at home and 2013 at work so I just use 2013 in a VM.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

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.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close