uktous
02-06-2012, 10:46 AM
Hi,
Could you please write me the macro?
I want to open each workbook in a folder, and then input the name of the opened folder in a particular workbook, and then close the workbook.
After I run the macro, the names for each workbook will be input in a particular workbook.
For each excel workbook in a folder
Step1:
Open a workbook.
Step2:
Write the name of the workbook in a particular workbook (says 1.xlsm).
Step3:
Close a workbook.
Next
Thanks
Could you please write me the macro?
I want to open each workbook in a folder, and then input the name of the opened folder in a particular workbook, and then close the workbook.
After I run the macro, the names for each workbook will be input in a particular workbook.
For each excel workbook in a folder
Step1:
Open a workbook.
Step2:
Write the name of the workbook in a particular workbook (says 1.xlsm).
Step3:
Close a workbook.
Next
Thanks