Sharepoint 2007 - change multiple items with manual workflow

I need a workflow that will change a field for multiple items in a list based on the item status. So if 45 items have a status of Resolved, I want to change that status to Closed with a manually started workflow. I cannot start it automatically on item change, as the status of Resolved can apply for an indeterminate amount of time.

I don't want to have to start the workflow from each list item. Can anyone suggest options for achieving this?  I have access to SharePoint Designer.

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

you won't be able to do it with sharepoint designer. you would have to custom code it with visual studio. The part I don't understand is your reason for not being able to do it on item change when status is set to resolve. You said it could stay at resolved for an "indeterminate" amount of time. Well how would your manual workflow know which resolved's to change to closed and which ones to leave as resolved?
It sounds like a better plan to use admin job that runs every a few minutes to check the status of the items and then make changes based on your criteria. This will require programming in Visual Studio not SharePoint Designer.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
TEEDAAuthor Commented:
it would change all resolved calls to closed at a point in time chosen by a tech. An item could be resolved and remain so for a week, a month. Calls show as resolved until the tech sends a report showing all calss and their status, then the resolved calls need to be closed so they dont show on subsequent reports.

Thanks, guys. I had a feeling this wasnt going to be an easy one.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.