Vba will be placed in a seperate file
my file name sample1.xlsx I have a column D which contains numbers with decimals so i want to remove the data from decimals by vba
example
column D
data
10
10.2352
25.02547
what i want is to remove the data from decimal means
10.2352 to 10
25.02547 to 25
like this
all files are located in same place vba will be placed in a macro.xlsm
and macro.xlsm and sample1.xlsx are in same place
sample1.xlsx is not opened so we have to open the same by vba
and after the process completed save and close the file