I've tried to look through the most of the MSDN to find some info about
transforming in this case steps (the measuring with step motors) to
millimeter. So far I've found:

CentimetersToPoints

InchesToPoints

PointsToScreenpixels

but none of were the one I was looking for sadly enough.

Anyone maybe have an idea or a tip?

best regards - Gobiten


--
Gobiten
------------------------------------------------------------------------
Gobiten's Profile: http://www.excelforum.com/member.php...o&userid=29217
View this thread: http://www.excelforum.com/showthread...hreadid=491073

Excel knows nothing about step motors, so you need to supply the formula.
The motor spec/documentation should tell you the conversion factor; you then
need to put this into an Excel formula: e.g. say the # of steps is in cell
A2 and you want to calculate mm in B2; if mm/step = 0.02 then the formula for
B2 would be:
= A2 * 0.02
Or, to make this into a user function
Const mmPerStep = 0.02
Public Function StepsTomm(Steps as Integer) as Single
StepsTomm = Steps * mmPerStep
End Function
Or, vice-versa
Public Function mmToSteps(mm as Single) as Integer
mmToSteps = Round((mm / mmPerStep),0)
End Function
--
- K Dales


"Gobiten" wrote:


I've tried to look through the most of the MSDN to find some info about
transforming in this case steps (the measuring with step motors) to
millimeter. So far I've found:

CentimetersToPoints

InchesToPoints

PointsToScreenpixels

but none of were the one I was looking for sadly enough.

Anyone maybe have an idea or a tip?

best regards - Gobiten


--
Gobiten
------------------------------------------------------------------------
Gobiten's Profile: http://www.excelforum.com/member.php...o&userid=29217
View this thread: http://www.excelforum.com/showthread...hreadid=491073

thanks mate )
good day to you

regards - Gobiten


--
Gobiten
------------------------------------------------------------------------
Gobiten's Profile: http://www.excelforum.com/member.php...o&userid=29217
View this thread: http://www.excelforum.com/showthread...hreadid=491073