R/vba - Open and save several workbooks (+500) and discarding formulas ie. keeping only dataframe

I would like to open several workbook files (xlsx), with multiple spreadsheets, discard the formulas in each cell and only keeping the data inside. I would do it mannualy but with at least 500 workbooks i would like to automise the task.I would like to open several workbook files (xl