Show Workbook Names in Combobox Drop Down list

[champ007]

Hey Guys,
I Have Some Queries, is it Possible ?
1) I want to Show Workbook Names in Combobox Drop Down list Means It Should Search the Particular Folder { eg D:\MyFiles\ } And then Show to the Drop down list.
2) When I Press Add button, All the Data should be Added to that file.

Attached Image For your Better Understanding

Example.png

Thanks In Advance.

Regards,
Champ

[mehmetcik]

Try this workbook.

It does more than you ask for.

[champ007]

Thanks Alot Bro.

This would help My First Query Solve but what about Second one how can i add the Data of a particular file in it

[mehmetcik]

So you have a list of workbooks in your list box.

You click on a file name.

What data do you want sheet name, range

Where do you want it to go?

[champ007]

Dear Mehmetcik,
I Have ( Combobox Textbox ListBox ) In Total 10 Columns in Listbox, The Data which i had entered in the ListBox That i Want to Enter in The Particular File Which Is Selected In Location ( Combobox ) Eg Canada to be saved in Canada.xlsx or if i Select it As USA then it should be Saved in USA.xlsx.

For Better Understanding Kindly See my Example.png Shared Above. #1 Post.