troubleshooting Question

Lotus Script - working with selected documents in a view

Avatar of BillTr
BillTr asked on
Lotus IBMVB Script
19 Comments3 Solutions5134 ViewsLast Modified:
I have a script that exports lotus views to excel. It works fine when all the docs in the view are exported. But I want to update it to work with selected documents in a view. From everything that I have found so far it looks like this can only be done via a collection. Normally I'd be fine with that, but in this case the export is of the available columns in the view, which makes the code very usable on any view.

My inclination is to say that I have 2 possibilities here.

#1. Assign the export script to 2 agents. One with selected documents in a view. Then call the agents via my action. If I see unprocessed docs in the collection, I call the agent associated. I know I could make this work but I'd have code in 3 places to maintain, etc. The action would still be portable though. I'm assuming it's possible to call an agent from VB script...

#2. I could pull the UNID off of each selected document in the collection into an array, then match that on the view before exporting. This keeps in the view, with code that's portable, but it just seems like a clumsy way of handling what s/b a simple problem.

I see a lot of entries for exporting to excel, but I haven't found anything about exporting selected documents. Since most of the notes are from years ago, I'm hoping that Notes has another way to handle these now....

Any advice is appreciated...

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 3 Answers and 19 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 19 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros