Hi all
I am importing my testdata from an Excel sheet that is provided to me by a colleague and thus pre-formatted.
Column B consists of both First- and Last name, but my app has 2 separate webedit fields for First name and Last name.
What is the VB code for reading the value of a cell until a space and saving it in a variabel like FirstName and then reading the value after the space and saving it in LastName ?
I am importing my testdata from an Excel sheet that is provided to me by a colleague and thus pre-formatted.
Column B consists of both First- and Last name, but my app has 2 separate webedit fields for First name and Last name.
What is the VB code for reading the value of a cell until a space and saving it in a variabel like FirstName and then reading the value after the space and saving it in LastName ?
