How to convert String to Integer

Hi. I’ve looked everywhere and the advice is too technical and doesnt seem to apply to StudioX.

Basically I created a loop via Foreach item as I cant find the While and sequence and other things on the tutorials.

I finally managed to get it working but now im having problems incrementing the number. I learned that it has to e converted to Integer and theres no clear information anywhere how to do that.

This is used to retrieve a specific row in excel, which has to increment each loop.

Thanks.

CInt(yourStringVariable)

Hi,
we have 2 methods:

Syntax VB:

CBool(expression)
CByte(expression)
CChar(expression)
CDate(expression)
CDbl(expression)
CDec(expression)
CInt(expression)
CLng(expression)
CObj(expression)
CSByte(expression)
CShort(expression)
CSng(expression)
CStr(expression)
CUInt(expression)
CULng(expression)
CUShort(expression)

https://docs.microsoft.com/en-us/office/vba/language/concepts/getting-started/type-conversion-functions

Or:

Convert.
System.Conver.

image

int_num = CInt(str_num)
int_num = Convert.ToInt32(str_num)

Thank you so much for the helo guys! I appreciate it.

Its like all of a sudden StudioX stopped being user friendly and forces you to go to Studio which is too technical for some like me.

Those codes look intimdating. ehehhe

If I helped, mark the topic as resolved. Thanks! :slight_smile:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.