Triggered action

[b00gieman]

Hi!
Can some sort of a trigger be made,so when a users saves a file to the disk,this trigger activates?
Thanks!

 

[stevexff]

Use the BeforeSave event. It will get called each time the user tries to save the workbook, where you can do whatever processing you need and optionally prevent the save if you wish.

Steve

[small]"Every program can be reduced by one instruction, and every program has at least one bug. Therefore, any program can be reduced to one instruction which doesn't work." (Object:erlDesignPatterns)[/small]

 

[fumei]

Assuming of course the OP was actually talking about saving a Workbook...ie. it is for Excel. Considering no application is mentioned whatsoever, this is, in fact, an assumption.

Although, probably correct.

But just in case...there is no BeforeSave event in Word.

faq219-2884

Gerry
My paintings and sculpture

 

[b00gieman]

Thanks.The file it's an excel file

 

[b00gieman]

But would beforeSave do what I want(after a user saves the file,some actions are triggered)?