AnsweredAssumed Answered

Applying PiSamDat using Excel VBA?

Question asked by Jacob134 on May 17, 2019
Latest reply on Jun 19, 2019 by PhilippeCloutier

Hello,

 

I am trying to create an excel test report that will give the user an option of manually entering data (copy and paste from an older report) or to use the PISamDat function to get data from the server.

 

I have VBA code that will enter the formula (code below) into the cells, but it requires the user to click on each column and select apply on the sample data menu.

 

Is there a way to automatically apply the settings?

 

=PISampDat("TrayTester.Current_Load",Import!$B$7,Import!$B$8,Import!$B$11,1,"\\BLHS1")

Outcomes