View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Mirror a workbook

i have a macro that does pretty much the same. save to my
c drive, saves to network drive and saves to a flash drive
for off system backup. I used the
Application.DisplayAlerts=false and reset to true after
the save.(recommended)
I put mine in a standard module and run in from an icon.
try the standart module instead of the before save event.
from what you described, this is just a straight save and
not one that needs to be triggered by an event.
good luck.

-----Original Message-----
Dear experts,
I would like to mirror a copy of a certain workbook on

another server.
Basically, every time my source workbook is saved, it

needs to be saved both
on its server, and on another one, deleting the previous

copy of the workbook
present there.
I have tried with the "workbook_beforesave" event, but my

Excel crashes down
when trying to execute the macro. I have put all an
Application.DisplayAlerts=false also there, but it does

not seem to work...

Could you please help me?
Many thanks in advance,
best regards,
--
Valeria
.