AnsweredAssumed Answered

Using PIBVSearch in VBA

Question asked by thamt on Feb 11, 2016
Latest reply on Feb 12, 2016 by thamt

Hi all,

 

I am trying to use a macro to retrieve batch information in excel. I simply copied the formula from the spreadsheet as follows:

 

Range(Cells(7, 7), Cells(2000, 12)).Value = Application.Run("PIBVSearch", 2, "server", "", "", "", "2", Cells(2, 8).Value, Cells(3, 8).Value, "", "B.0,S.0,E.0,P.0,I.0", 409, Application.Run("PIBVUnitBatchSearchMasks", "", "", Cells(1, 8).Value, "", ""))

 

But, this is what I get:

Problem_PIBVSearch_VBA.png

I seems like I am missing a parameter to specify the column count. Can someone please tell me how I can make this work?

 

Thank you.

 

Regards,

Terence Tham

Outcomes