Hi all,

I'm hoping someone is particularly expert with VBA to help with this...

Context:
I have multiple SQL jobs whose outputs are transformed through a template Excel file output.
There are multiple Excel file outputs, each with one visible tab (aggregates data) that needs to be copied to a new workbook, converting cell contents from formulas to values (for upload elsewhere).
The end goal is to convert these larger workbooks into single-tab XLSX (cannot be CSV) files that contain only values (not formulas), deleting the original workbooks if possible.

I need to create a macro that does this:
  • On run:
  • Open folder selection menu
  • For each workbook in selected folder...
  • get active sheet for each file
  • copy values (not formulas) from each file's active sheet to a new workbook (1:1, not combined, not CSV)
  • Finally, delete original file.

I've got a couple macros that can do some conversions (convert from XLS to CSV, CSV to XLS...) but having trouble unifying it all, especially with any sort of delete function after file conversion.