Re: Word template - Workflow System - Event Handler problem
- From: "Jared" <ask.me@xxxxxxxx>
- Date: Thu, 22 Dec 2005 08:58:04 -0600
Fernando,
I would like to see an alternative method to VBA. The user could choose the
"Disable Macros" option and this too would fail. Are there any other
sugguestions / solutions for this? Also, how do you "tell" office apps that
they should save the currently opened file to a different library with out
prompting for location?
Thanks for the suggestion Fernando,
Jared
"Fernando Hunth" <FernandoHunth@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2C68657E-32A8-40C8-9356-3E3C0576AECF@xxxxxxxxxxxxxxxx
> An option can be that when the user saves the document a vba macro closes
> it.
>
>
>
>
>
> Fernando Hunth
> Microsoft 3DCE
> Senior Developer
> http://msdevelopers.blogspot
>
>
>
> "Jared" wrote:
>
>> I am trying to create a simple workflow system using several document
>> libraries as staging areas. The first library in the chain allows the
>> user
>> to complete a Word document template and save back to the library. An
>> Update event fires and my handler moves the newly updated document to the
>> next queue/stage based on extended properties of the library (status,
>> product, amount, etc). However, if the user saves the document and
>> selects
>> one of the property items that the handler "subscribes" to the move will
>> fail (the document is still open).
>>
>>
>>
>> My question is: How can I react to the document when the user still has
>> it
>> open in one of the office applications?
>>
>>
>>
>> A simple scenario would be: Amount > 1000
>>
>>
>>
>> Open template
>>
>> Fill-in
>>
>> Save
>>
>> Event Handler - Amount is greater than 1000 ß Evaluates to true
>>
>> Move Document to different queue ß Fails because the document is still
>> open,
>> how do prevent this?
>>
>>
>>
>> TIA
>>
>> Jared
>>
>>
>>
.
- Follow-Ups:
- Re: Word template - Workflow System - Event Handler problem
- From: Bil Simser [SPS MVP]
- Re: Word template - Workflow System - Event Handler problem
- References:
- Prev by Date: Re: Adding a webpart or script to a custom list view
- Next by Date: Re: Word template - Workflow System - Event Handler problem
- Previous by thread: Word template - Workflow System - Event Handler problem
- Next by thread: Re: Word template - Workflow System - Event Handler problem
- Index(es):
Relevant Pages
|