Carlo76ita
New Member
Dear Developers/Friend @Chandoo.
I'm doing a job for a friend who has a biomechanic lab.
He has some sensors which return data in a file with a txt format.
The work we actually do is
1) opening the file fje in excel ( drag n drop )
2) inserting the column names
3) adding the A column which is 0.01 for each row ( a1 is 0.01 a2 is 0.02 and so on )
What I'm not able to do ?
I'd like to import the fje file and working it to get the sheet with the final result.
I think I can do this in VBA but I don't know how !!
Maybe importing file to an excel template which has all the column names AND the first
( time ) column ?
I attach the fje file and the resulting file actually I am working on.
Thank you for your support !
I'm doing a job for a friend who has a biomechanic lab.
He has some sensors which return data in a file with a txt format.
The work we actually do is
1) opening the file fje in excel ( drag n drop )
2) inserting the column names
3) adding the A column which is 0.01 for each row ( a1 is 0.01 a2 is 0.02 and so on )
What I'm not able to do ?
I'd like to import the fje file and working it to get the sheet with the final result.
I think I can do this in VBA but I don't know how !!
Maybe importing file to an excel template which has all the column names AND the first
( time ) column ?
I attach the fje file and the resulting file actually I am working on.
Thank you for your support !