Hello,
I currently have the task of sending variables to excel cells in a spreadsheet after they are calculated in a function. I don't know much about VB and am converting from a Java program to a Visual Basic Module
Here is an example of the original JAVA code:
peakTemp = 2 * theta_eff - tamb
setEccentricityRatio(ecc);
setAttitudeAngle(att);
setSommerfeldNo(som);
setPressureAverage(pressure_average);
setDimensionlessOilFlow(dof);
setDimensionlessFrictionCoef(dfc);
setFilmThickness(clearance_eff);
setPowerloss(loss);
setOilFlow(flowTotal );
setTheta(theta_eff) ;
setPeakTemperature(peakTemp);
setDeltaTheta(deltaTheta);
So, the VB functions don't call any variables, but need to send variables like Theta_eff to the Excel Cell Theta. Can somebody post an example of how this would be done for one of these variables?
If this is already discussed somewhere, I apologize.
Thanks!
B
Bookmarks