[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2774
  • Last Modified:

Excel - Error loading DLL

I have excel document using a number of VBA macros.  This particular file will not work on Sony Vaio desktop running windows vista.  The file will not save or save as simply stating "excel can not save file" and when I try to load macro it will give error message "can not load dll".

any ideas?????
0
ahines01
Asked:
ahines01
  • 11
  • 6
  • 3
  • +3
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Can you post the entire Error message, including an Error number?
0
 
ahines01Author Commented:
good idea but there is no error number or message other than "cannot load dll".  The file won't save under any circumstances.  When ever you try to save the excel file, it says "excel can not save file".  That's it.  Here is the order of events.  I send her the file via e-mail.  She downloads the file and opens it.  We try to run the macro's (her security level is low) and she gets error message indicating can not load dll.  I open vba and go to tools menu/reference and it says missing refedit.dll so I change paths and it still doesn't work.  I've never seen this before.  I'm stumped!
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
When you say you "change paths", do you mean you re-reference the .dll? Does your coworker do this as well?

Are you both working with the same version of Excel?
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
ahines01Author Commented:
I created the spreadsheet in excel 2003 and then i upgraded to 2007.  We've had a few issues where the tools/reference missing(refedit) was corrected by changing the path to the refedit.dll.  In her case though she is using 2003 and the path to the missing(refedit.dll) is correct.  she is an end user and I am the guy that created the spreadsheet.  I modify the spreadesheet in 2007 and save in compatability mode.  We've had good results over all with this method and the ones that we've had trouble wih the dll path was usually the problem.  in this case it doesn't seem to work.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Make sure your coworker has the latest SP for Excel and Office ... also make sure the OS is up to date as well.
0
 
Rory ArchibaldCommented:
Does it happen if they start Excel in Safe Mode (by hodling down the Ctrl key when starting Excel then answering Yes to the prompt)? Do they have an anti-virus program with an Office scanning component?
Regards,
Rory
0
 
ahines01Author Commented:
Haven't tried safe mode but here is a video of the problem.  I did gotomeeting with a guy a few minutes ago and this pretty much illustrates the errors.  He is on an XP machine using 2003.  The files he is trying to work with are 2003 files created in 2003, edited in 2007, saved in compatability mode.   They work fine in some places and then in some places you get the mess that is on this video.  I am really desperate for help on this, I don't have a clue how to even tell the guy where to begin.  This file is a zip file that i had to change the extension on to xls.  please change the extension to .zip  This is the file I he is working on.  Also I recorded a brief gotomeeting video that has all of the error codes clearly identified but it is too large for this upload.  If you have e-mail I can send it to you .. I will.  EMAIL ADDRESS DELETED.


PLEASE DO NOT USE EMAIL TO SOLVE PROBLEMS ON EE.

VEE_MOD
EXPERTS EXCHANGE MODERATOR
2007-Budget-Wilmington--version-.xls
0
 
ahines01Author Commented:
do you have any answers for this?
0
 
Rory ArchibaldCommented:
Why do you have a reference to the refedit control when you don't appear to actually use one anywhere? Also, have you tried compiling your code? There appear to be errors in it currently (as well as a few empty modules for some reason), which may be partly causing the issue.
Regards,
Rory
0
 
ahines01Author Commented:
Why do I have a reference to refedit control?  I don't have a clue.  I do have a master control panel I created that control-shift M initiates.  I am not a professional programmer.  These budgets are Macro Driven and contain a lot of code that does some simple things. There is 3 years worth of development time in this budget model and it has worked fine on everyone's computers until this year.  The error messages i sent with the video are what they are experiencing.  I don't know how to complie the code, and while I know there is old code in the modules I don't use, I don't know really how to clean it up.  Any help you can give will be appreciated.  In the meantime I need to figure out why the file won't save and why the dll message is popping up.  I appreciate your help ..... I am an amature that  understands spreadsheets very well, and I use VBA to do things that have worked very well for us (if you guage working by doing what I want, not by the way it looks necessarily).  I'm just buffaloed by this set of issues.
0
 
Rory ArchibaldCommented:
I had a look through your userforms and there didn't appear to be a RefEdit control in use anywhere. You should be able to simply uncheck it from the list of references and save the file (then redistribute as required). That may well cure your dll reference problem and allow everyone to save the file.
You can compile the code by selecting Debug->Compile VBA PRoject in the VBEditor window. It's a useful thing to do while writing code because it will flag up any syntax errors in your code so you can correct them.
Regards,
Rory
PS If I have a chance, I may go through and try and tidy up the code but I can't guarantee it. (and as long as it's working, it doesn't really matter!)
0
 
ahines01Author Commented:
Rory:  I will do that today.  I have a location in texas that I can try that on.  will compliling the code compress it or simply check for syntax?  I'm pretty sure the syntax is correct on all of it.  at any rate, it does work (usually) and I try to learn as much as I can about VBA along the way.  I use onenote to store code that does various things for me and then I patch that into what I'm doing.  I think the problem here is office 2007 and it's compatability mode.  That's just my thought though.  Thanks for your help, I will give this a whirl and see what I come up with.
0
 
Rory ArchibaldCommented:
It will compile the code and perform a syntax check. When I tried it on your code, there was a reference to a non-existent form but I wasn't sure if you had posted a stripped down copy of the workbook. Let us know how it goes!
Rory
0
 
ahines01Author Commented:
i removed that reference (simply deleted the code) and i unchecked the refedit.  (If I don't have a refedit in the project, why would it check missing refedit?).  I am going to send it to them and will let you know.  thanks for your help.
0
 
ahines01Author Commented:
i'm not sure what you mean?  I have a problem that no one seems to be able to help me solve.  i don't know what you mean by your above message, please explain so I don't do it again.
0
 
Rory ArchibaldCommented:
I think it referred to your much earlier comment "If you have e-mail I can send it to you ". That's against EE rules.
Do you still have the problem? I assumed from the silence that everything was OK now.
Rory
0
 
ahines01Author Commented:
sorry .. didn't know about the e-mails and yes it's still a problem and a rather perncious one too.  I have no clue why it's doing this.  I can't find any reason why you can't save the files, I can't track the error codes and i can't explain why it happens on some files and not others since they are all basically the same files.
0
 
Rory ArchibaldCommented:
Have you tried having one of the users with the problem open Excel in Safe mode and then see if the workbook can be saved?
0
 
Jeffrey CoachmanMIS LiasonCommented:
ahines01,

I'm with rorya,
Clean up the code in a known good copy of the file in the *2003* format.
Delete un-needed/Un-used code, modules, subprocedures, or functions.
Delete any un-needed objects and/or objects references
Delete excessive white space
Compile often

Then, make *sure* that  all the functionality you need still works in 2003 on *all* machines.

Then open the file on the 2007 machine and retest.

After this is done, then we can begin to trouubleshoot any issues (dll paths...ect) from a relatively clean slate.

just my 2c

JeffCoachman
0
 
Vadim RappCommented:
Try suggestions in this article: http://support.microsoft.com/kb/271513 . Especially the one about windows safe mode - maybe some antivirus etc is interfering.

I was able to re-save the file you uploaded in excel 2003 on windows xp.  Also after I unchecked the reference to missing refedit.dll, pressing ctrl-sh-M has opened the form successfully. So the problem is most likely in the computer rather than in the file. Since you mentioned that the problem started some time ago, I would check is there were any windowsupdates at that time, as the usual #1 suspect that breaks things.

Other suggestions:
1. open excel, menu tools/macro/security, and set security level to high. Then open this file. Because of security level, the macros will be disabled. Now try to save. If it still fails, then it's not related to anything in the code. So we will at least know where to start looking.

2. run filemon from sysinternals.com, have it looking for failures. Monitor when you try to save the file. Filemon will show if some file has failed reading.
0
 
Vadim RappCommented:
also, just as a blind shot, I would try to delete the cute pictures from the forms.
0
 
ahines01Author Commented:
These are all GREAT suggestions and i will check them all very quickly.  I am on the road right now and will review these ideas as soon as i get an opportunity at the hotel.

andy
0
 
angelmtaylorCommented:
I had this same problem. What I did was open the file in 2007 but leave it in its 2003 format. In the Visual Basic editor, go to tool, references, remove the Ref Edit Control and save. Test all buttons and macros in the 2007 application. Then I found a machine with 2003 on it and tested. No errors...everyones happy.
0
 
ahines01Author Commented:
I stripped the VBA and loaded in 2003 and the file works.  So far so good.
0
 
Jeffrey CoachmanMIS LiasonCommented:
ahines01,

Thanks, but rorya actually deserves points for this as well.

I have no problem with a points split.
;-)

JeffCoachman
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 11
  • 6
  • 3
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now