Comments by behruz12 (Top 4 by date)

What does this mean: apri file read only & if file is read only then third component should be ReadOnly:= True and not False (please give your solution).

In case for open a workbook as read only you can't make a change for workbook and need to save a copy of it. here:
set source = workbooks.open(Filename:="your path/your workbook name", ,Readonly:=True)
https://excelchamps.com/vba/open-workbook

In Excel CSV file you can in one empty cell put =lower(true) and copy it then select all cells with true via Ctrl+F & Ctrl+A and paste as values in a simple way.
Macro for formula and copy:
Sub copy()
'empty cell d4 place =lower(true)
[d4]="=Lower(true)"
[d4].copy
End sub