Hi, John. I left out the code in hopes I was committing an obvious error
<g, also I may have to simplify it or add elaboration for others to
understand it. If need be, I'll do that and post it.

To clarify, I coded only a call to another sub in the SaveBefore workbook
event using:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
Application.Run ("DualSave")
End Sub

Does that part look right?

I noticed from testing that the crash occurs, not during the execution of my
code added to the SaveBefore event, but when it is finished and Excel
proceeds to do its normal save it crashes. So, it does not seem to like
saving to an FTP site, then saving as the same original file (over-writing)
to my hard drive, then doing its normal save.

I can see how it could get confused, but do not know what to do about it.
Any ideas?

Thanks,
Pat


As you didn't post the code that you were using, it's difficult to
attempt to diagnose what might be wrong with it.
As a rule, I *never* actually code anything directly in the Workbook
Events other than a call to another sub. Makes testing a lot easier
and I don't have to worry if it's the *event* that's causing the problem
since I can just add a MsgBox to the event (for testing purposes)
just to see if/when it's firing.

John


"Pat Beck" wrote in message
...
Excel 2002
WindowsXP

I have a macro in a module that works great when ran directly. But when
I
run it from ThisWorkbook on a BeforeSave event it crashes Excel
constantly.
Basically, the macro saves to an FTP site as well as the hard drive when
the
user saves. I can have the user hit a macro button to run my
saveFTP/saveHardDrive macro directly and everything is great, but I'd
like
to launch this action upon a normal save as well. But, like I said,
calling
it up in BeforeSave crashes Excel.

I've had other projects become unstable when I called a macro from
within
ThisWorkbook. So, I must be doing something consistently wrong. I shy
away
from adding any code at all to ThisWorkbook because of my experiences.
Maybe
I'm doing something wrong that can easily be corrected?

Does anyone have ideas or do I need to furnish the exact code?

Thanks,
Pat Beck