krakowi

1

votes
1

answer
18

views

Convert string into float for multiple columns in data frame

I am playing with the data set from FIFA 19 and currently trying to convert string value, wage and release clauses into float values e.g. €110.5M into 110500000. Here is my function which takes text as an argument and returns float value: def text_to_num(text): d = {'K': 3, 'M': 6, 'B': 9} new_tex...
krakowi
1

votes
1

answer
38

views

how to pass a variable from one sub to another?

I am struggling to pass a srcFile variable from one sub to another. I would like to do the following: 1) load source file from my local path in loadFile() sub 2) Set srcFile as my source data workbook 3) I would like to call processWorkbook in my Main program so that it will take my srcFile, pass it...
krakowi
2

votes
1

answer
84

views

Which variable type should be chosen type for .Find(LookAt: = xlPart/xlWhole)?

Here is my problem. I would like my function to return a cell object which can be considered as the data start, depending if you look at the part of the string or at the whole word. Function lookForDataStart(sht, word, searchtype as Variant) Set wordLocation = sht.Range("A1:D150").Find(word, LookAt...
krakowi