Delete workbooks with specific prefix in its name

**Manish84** · 01-26-2014, 03:07 PM

Hi friends,

I have a small question, is it possible to close and delete open workbook with some specific prefix in the file name.

Suppose i have 4 open workbooks, say Workbook 1, Data 2, Data 3 (Number will keep on changing), RawData 4

Now from Workbook 1, i want to close and delete the second and third workbook with file name prefix "Data" (The numerical values will keep on changing so i cant give the full workbook name to close and delete).

Please let me know if it is possible and how.

Thanks & Regards

**xladept** · 01-26-2014, 05:14 PM

Check this out:http://www.mrexcel.com/forum/excel-q...lications.html

**Manish84** · 01-26-2014, 11:26 PM

Hi xladept,

The link which you have suggested, is deleting the main workbook only from which i am running the code, it is supposed to delete other open files which some specific prefix in its name.

**Trebor76** · 01-27-2014, 01:25 AM

Hi Manish84,

Try this (just bear in mind that files will be deleted, no questions asked so back them up if need be):

Please Login or Register  to view this content.

Regards,

Robert

**xladept** · 01-27-2014, 03:21 AM

But that link shows the use of Kill - it's a killer

**Manish84** · 01-27-2014, 02:21 PM

Yes xladept, its a killer

**Manish84** · 01-27-2014, 02:24 PM

Originally Posted by Trebor76

Hi Manish84,

Try this (just bear in mind that files will be deleted, no questions asked so back them up if need be):

Please Login or Register  to view this content.

Regards,

Robert

Thanks a lot Robert,

Your code is working fine, and i have also learned a new thing.

Thanks a lot Robert.

**Trebor76** · 01-27-2014, 06:07 PM

You're welcome

Delete workbooks with specific prefix in its name

LinkBack

Thread Tools

Rate This Thread

Display

Delete workbooks with specific prefix in its name

Re: Delete workbooks with specific prefix in its name

Re: Delete workbooks with specific prefix in its name

Re: Delete workbooks with specific prefix in its name

Re: Delete workbooks with specific prefix in its name

Re: Delete workbooks with specific prefix in its name

Re: Delete workbooks with specific prefix in its name

Re: Delete workbooks with specific prefix in its name

Thread Information

Users Browsing this Thread

Similar Threads

Loop for adding specific worksheets in specific workbooks

[SOLVED] Macro to copy an entire worksheet from one open workbook to another with a specific prefix

[SOLVED] Alter code to work only on workbooks with a specific prefix?

Macro to extract data from multiple workbooks, specific sheet, specific cells

How to search multiple workbooks for a specific value in a specific cell

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions