I need a batch macro to extract the number of bends from sheet metal parts in a named directory and put that data into an Excel spread sheet. As well, I need to extract the file name (part number). The Excel file will have two columns: Part Number Number of bends. Populated below those column headings will be the file name (part number), Bends from
This macro will need to be run where I can choose the directory and/or files I want to include, and allow me to name the Excel spread sheet before saving.
Thanks in advance for your help.