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:


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.



Terence Tham