Macro crashes from time to time when running from another computer

I have developed a Macro in excel 2010 that runs perfectly on my computer.
The issue is: When trying to use it from another computer with Office 2007 sometimes it crashes giving a runtime error 1004.
all what I have to do to fix it is to open it from my computer and save it then it works on the other computer before it crashes after few times.

Does your macro involve too much of copy pasting? Anything that is clogging up the clipboard and also the memory which leads it to crash?

No it Doesn't. Except for the below sentence which i think has nothing to do with the memory

Please Login or Register  to view this content.

Any help will be greatly appreciated

Have you narrowed down which line it crashes on?

no. It runs good on my computer. The module is password protected and some times it gives that error when other employees are using it so it cant debug to point the exact line.

Did you write it? If so, you need to add error logging for situations like this! A generic error number caused occasionally by code we cannot see is hard to diagnose.

Thanks. I will investigate it and let you know

If you do not already use it, I would recommend getting hold of MZ Tools addin for VBA (it is free, but you can donate to the author if you find it useful) which will allow you to add line numbers to your code. You can then use a central error logging routine called from each routine, passing a module name and line number (using Erl).

never heared of it before.
Thanks

You can get it here - it is truly invaluable.

Hi, well this is the line that crashes the program from time to time.

Please Login or Register  to view this content.

Impossible for me to tell anything from that alone, since clearly there is nothing inherently wrong with saving a workbook. Could be network problems, permission issues, event code interfering and so on.

Hi, I have a suggestion.
After ThisWorkbook.Save put a line of "DoEvents". This allows windows to do stuff and finish before coming back and trying to run the next line of your code. http://support.microsoft.com/kb/118468

Where will the workbook be saved ?
Does the
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
event contain any code ?

Please Login or Register  to view this content.

snb. I think it was solved. Thank you for the help.