Create a Excel file and Save based on cell value

[Santhosh krishna]

Hi Guys,

I am very new to VBA and have a assignment in hand.

I have an excel sheet which contains the list of Hospital Names in the range A2:A3000 ( Roughly has a data of 3000 hospitals). I would like to create a macro based on the cell range A:2 to A3000 and save this in a folder ( The name of the spreadsheet should remain as the cell value.

Please help me out

Pasting the data for your reference
A1
<table x:str="" style="border-collapse: collapse; width: 767px; height: 2632px;" border="0" cellpadding="0" cellspacing="0"><col style="width: 239pt;" width="318"> <col style="width: 32pt;" width="42"> <col style="width: 54pt;" width="72"> <col style="width: 250pt;" width="333"> <tbody><tr style="height: 14.25pt;" height="19"> <td class="xl67" style="height: 14.25pt; width: 239pt;" width="318" height="19">Clinic Name / Doctors Name</td> <td class="xl67" style="border-left: medium none; width: 32pt;" width="42">New</td> <td style="width: 54pt;" width="72">
</td> <td class="xl67" style="width: 250pt;" width="333">Adress</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Abhinandan Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;" x:str="#27, Nagasandra II Main , ">#27, Nagasandra II Main , </td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Andree Polyclinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;">#28, Andree Road,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Anurag Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;"># 502, 6th Main Road, 9th Cross,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Ashwini Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;">No:26, Railway Pipe Line Road, R.P.C.Layout,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Aswini Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;"># 28, Bazaar St,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">B.T.M. Multi Speciality Hospital</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;">100ft, Ring Road,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Care Diagnostic Centre & Polyclinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;"> </td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Chetan Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;"> </td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">City Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;">I st Main Road, Maruthinagar,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Deepak Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;"># 278, 80ft Road,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Dr.B.G.Srinivasa Murthy</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;">Opp.Hanumantha Nagar Co-op Bank</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Dr.H.Satishchandra Hegde</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;">#89/1, 1st Floor, 5th Cross</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Dr.Nishath Abrar Ahmed</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;">#67/1, Shivaji Road,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Dr.P.S.Bopaiah</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;" x:str="#478, ">#478, </td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Dr.Syed Abrar Ahmed</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;">43/1, Charminar Masjid Road,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Dr.T.P.Ishwar</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;"># 11/2, Cambridge Road,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Eshwari Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;">#79, Sri Rama Krupa, "G" Main St, Joghupalya,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Ganesh Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;"># 1012, 2nd Main, 3rd Cross, II Block,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Geetha's Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;">C.J.V.Road,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Guna Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;">#393, Nagavarpallya Main Road,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Halasuru Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;" x:str="G.Street, Jogupalayam, ">G.Street, Jogupalayam, </td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Health Care Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;" x:str="7th Cross, Broadway, ">7th Cross, Broadway, </td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Hebbar Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;"># 113, 4th Main Road,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Kishore Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;">#425, 18th Main Road, 33rd Cross, 4th "T" Block,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Krishna Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;">No.82, 12th Main Road, Ist Block,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Kumaraswamy Poly Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;">#726, 14th Main, Opp, Police Station</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Malleswaram Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;">17th Cross, 8th Main Road,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Mohan's Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;">First Stage, 2nd Main,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Pristine Consultation & Diagnostics</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;">#50, KHB Colony, 8th Block,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Raghavendra Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;">1st, Block East,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Rishab Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;">No.72 & 73, Shop No:3, 24th Main End, Puttenahalli, 7th Phase</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Royal Clinic & Diagnostic Centre</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;">#38, 22nd Main, Near BDA Complex,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">S.S.Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;"># 305/66, 40th Cross,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Sampige Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;"> </td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Sanjeevini Polyclinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;">#33/4, 35th Main, 17th Cross, Sarakki Garden,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Shilpa Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;"># 2925, 14th Cross, K.R.Road,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Shivakrupa Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;">MIG II KHB Colony,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Shree Shyla Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;">#320-B, II Phase,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Sree Raghavendra Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;">#1454, Iith Cross, West of Chord Road,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Sree Vijaya Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;">No.56, 19th Cross, 12th Main, 1st, Block,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Sri Balaji Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;">Subramaniyapura Main Road, BSK II Stage,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Sri Banashankari Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;" x:str="# 8, 8th Cross, 8th Main, "># 8, 8th Cross, 8th Main, </td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Sri Guru Health Line</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;"># 252,2nd Main, 8th Cross,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Sri Venkateshwara Hospitals</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;"># 86, Hosur Main Road,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Sri Venkateshwara Hospitals</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;">No.938, 16 th Main,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Sri Vijayalakshmi Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;"># 2, Kothanur Main Road,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Srinivasa Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;"># 21, Lalitha Nivas, Double Road,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Vasundhara Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;"># 1537, 14th Main Road,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Venkateshwara Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;"># 578,3rd Stage, 4th Block,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Vinayaka Clinic</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;">Austin Town</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Yellamma Dasappa Health Centre</td> <td class="xl66" style="border-top: medium none; border-left: medium none;"> </td> <td>
</td> <td class="xl66" style="border-top: medium none;"># 262, S.C.Road,(Inside Ramakrishna Lodge)</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Sree Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">Chruch St,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Shri Venkateshwara Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">Airport Road,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Raju Health Centre</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;"> </td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Prasantha Hospital</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">#90/D, Bommanahalli Circle,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Kamala Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">#509/B, Water Tank Road,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Anand Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">#132, Kathriguppe</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Lake Side Nursing Home</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">Behind Canara Bank</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Balaji Nursing Home</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">Dommasandra Main Rd,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Aditya Nursing Home</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;"> </td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Soorya Nursing Home</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;"> </td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Eswari Nursing Home</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">Muthanallur Road,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Soorya Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">Mullur Road, Kodathi Gate,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Soorya Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">#261/C, HAL 3rd Stage, 4th Main,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Soorya Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">Kristal Complex,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Sri Lakshmi Venkateswara Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">Puttenahalli Palya, Kothanoor Main Road,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Vanamala Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">#28/29, Kothanur Main Road,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Vanamala Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">#457, RBI Layout, II Main, V Cross,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Aithal Hospital</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">#9, 2nd Mian Rd, Santhrupthinagar,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Nelofer Polyclinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">Kenchappa Road,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Hillside Hospital</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">#113, 4th Cross, R.K.Layout,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Mahalaxmi Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">#5th Main, Giddappa Block,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Ashwini Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">#43/1, Guddadahalli Main Rd,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Ideal Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">#153, Sowkarlane, Ambedkar Medical College Road,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Poornima Nursing Home</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;"># 19/7, Dinnur Main Road,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Kamala Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">#1, Boweelance "A" St, Bazar St,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">State Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">#119 (37-A,)</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Hema Poly Clinic & Child Health Centre</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">Opp. Tulasi Theatre</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Hema Children & Speciality Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">#1358, AECS Layout,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Vijaya Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">#144/9, I Main, VII Cross,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Tanush Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">#8, 12th Cross, B.B.Nagar,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Mouisha Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">#6, Narjappa Building, Narjappa Main Rd,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Gupta's Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;"># 956/2, V Block, Bel Layout, Vidyaranyapura Main Rd,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Gokul Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">M.S.R.Main Rd,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Manjusha Health Centre</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">V.Nagenahalli Main Rd,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">People's Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">Cholanayakanahalli,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Sushmna Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">#23/1, 2nd Main,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Vijaya Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">#56/5, I Main (Mathkere) Road,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Eshwar Poly Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">Channasandr Main Rd,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Manipal Poly Clinic & Nursing Home</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">Gurumurthy Reddy Layout</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Deepa Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">#27, Old Madras Road,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Shirdi Sai Hospital</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">#519, 2nd Main, Nethravathi St, Opp.SLK Software, Devasandra,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Adarsh Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">Geddalahalli</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Ambika Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">#16, A.E.C.S. Layout, I Stage,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">RAO'S Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;"># 55/55A, 60th Road, Krishnappa Layout,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Shubha Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;" x:str="# 2968, Mariyappana Palaya, B-21, "># 2968, Mariyappana Palaya, B-21, </td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Naveen Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">#3273, I Main Rd,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Balaji Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;"> </td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Sai Deep Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">#19/03, VII Cross,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Dr.E.Manohara</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">#85, III rd Main,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Sanjeevini Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;" x:str="Opp. Vijaya Bank, ">Opp. Vijaya Bank, </td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Ashraya Hospital</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">Magadi Main Rd,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Anand Nursing Home</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">Vinaya Complex, Pipe Line Circle,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Sri Venkateshwara Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">I st, Main Rd,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Sunitha Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">#127, Rajagopal Nagar Main Rd,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Sri Thirumala Hospital</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">SMR Arcade , S.M.Road, Jalahalli Cross,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Jyothi Nursing & Maternity Home</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">Attiguppe</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Poojitha Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">#14, Gurukrupa, I Main Rd, Kavika Layout,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Mysore Road Hi-Tech Hospital</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">#17, Pantharapalya,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Yashashwini Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;"># 311, Kuvempu Road,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Nazir Clinic</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;" x:str="#6,D.B. St, 4th Main, ">#6,D.B. St, 4th Main, </td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Swathi Nursing Home</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">#1764, 14th Main,</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl65" style="border-top: medium none; height: 15.75pt;" height="21">Ashwini Hospital</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">N</td> <td>
</td> <td class="xl66" style="border-top: medium none;">Bilekahalli,</td> </tr> </tbody></table>

 

[VoG]

Hello and welcome to MrExcel.

Try this - it will add the files to the same folder as the workbook running the code.

Sub NewFiles()
Dim LR As Long, i As Long, nm As String
Application.ScreenUpdating = False
LR = Range("A" & Rows.Count).End(xlUp).Row
For i = 2 To LR
    nm = Range("a" & i).Value
    Workbooks.Add (xlWBATWorksheet)
    With ActiveWorkbook
        .SaveAs Filename:=ThisWorkbook.Path & "\" & nm & ".xls"
        .Close
    End With
Next i
Application.ScreenUpdating = True
End Sub

 

[Santhosh krishna]

Hello VOG,

Great place to post excel questions.

Many thanks for the code which is exactly doing as I intended to do. However, there is one glitch if there are 10 names which are matching the person has to click the replace prompt 10 times in view of saving. Is there any way that replace functions can be eliminated by manual clicking

Many thanks in advance

 

[VoG]

Try this

Sub NewFiles()
Dim LR As Long, i As Long, nm As String
Application.ScreenUpdating = False
Application.DisplayAlerts = False
LR = Range("A" & Rows.Count).End(xlUp).Row
For i = 2 To LR
    nm = Range("a" & i).Value
    Workbooks.Add (xlWBATWorksheet)
    With ActiveWorkbook
        .SaveAs Filename:=ThisWorkbook.Path & "\" & nm & ".xls"
        .Close
    End With
Next i
Application.ScreenUpdating = True
Application.DisplayAlerts = True
End Sub

 

[Santhosh krishna]

Hi VOG

It worked great.

Is there any way we could save the date for dd/mm/yyyy as a excel file name. As I try to run the existing macro I get a debug - The logic is we can save any file with 22/22/2022.xls.

Do we have any solutions here?

 

[VoG]

The / character is not allowed in a Windows filename so you need to use something like

ThisWorkbook.SaveAs Filename:=Format(Date, "dd-mm-yyyy") & ".xls"