mmulder6

Search for batches in Excel VBA by unit

Discussion created by mmulder6 on Jun 17, 2010
Latest reply on Jun 18, 2010 by hanyong

Hello,

 

I am writing some VBA code in Excel to retrieve batchID's and put this into a listview.
I worked out the code for getting the batchinformation but I could not find anyway to include the unit name as a search parameter

 

When you do this in Excel using formulas there is an option called PIBVUnitBatchSearchMasks which is a subset of PIBVSearch. I want to have the same search option via VBA. I'm currently using a Set batchList = BatchDB.PIBatchSearch(SearchStart, SearchEnd) and I get a nice result of all batches within the specified time period but this result is over multiple units that have nothing to do with each other.

 

Does anyone have any experience with this?

 

Any help is appreciated!

 

Kind regards,

 

Martin

Outcomes