View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Deen Deen is offline
external usenet poster
 
Posts: 22
Default Fetch data from multiple .csv file paste into single sheet

Hi team,

I hope all are doing well,

I have query, in my excel sheet i have a user form in that 10 text box and
10 command button name called"browse" , And i have 1 main spread sheet name
called "inventory"

Question:

I need, once i click 1st browse button windows need to open, browse the
path select the .csv file, same thing is applicable for all 10 "browse button"

Note: in that text box is need to display the browse path.

And there is only one "ok" cmd button, once i click the OK button fetch the
data from multiple .csv file and paste into main spread sheet"inventory"

Please help on this....

Thanks in advance