Excel Help2

[mukeshc]

I have a folder with many excel workbooks containing the same set of sheets with in them.

In few of them in sheet1 & cell B10 i need to insert text "NO".

The few workbooks where i need to do this is separately provided in a list.

I need a macro coding were it picks Workbook name from the list open it from the folder do the task of inserting "No" to sheet1!B10, saves the workbook and move on to the next workbook of the list.

thanks in advance for the help.

 

[mumps]

What is the name of the sheet containing the list? In what range on that sheet is list located? Does the list include the full path to the folder including the workbook name or does it contain only the workbook name? Does the workbook name include the extension (xlsx, xlsm)? If the list doesn't include the full path and the extension, what is the full path to the folder and what is the extension?