I have a multiple workbooks which has columns to Workbook and I have standard a standard excel file. All i have to copy each workbook into standard template and save the template with cell D1 and re56yrsasz z s,m`nbx xsnww212 3peat the processes for all workbooks
Process in detail:
Say I have workbooks as 1.xslx; 2.xlsx; 3.xslx; etc., in a particular folder
and i have standard Excel template (Xlsm)
data from (specific columns) each workbook gets copied to excel template and save the template as cell d1 of workbook
how do I create a vba to do this?
I have found some help here but how can read all the excel workbooks?
hope I am clear