Kill ONLY .xls (2003 excel) files

[Shift-4]

Hi

I have a macro that converts old .xls files to .xlsx files.
After that is run I want to delete all the .xls files

I have used the following code

Please Login or Register  to view this content.

However that is deleting the newly created .xlsx files as well

Any suggestions?

Thanks

[Leith Ross]

Hello Shift-4,

Are you sure it reads

Please Login or Register  to view this content.

And not this. Notice the extra asterisk at the end of xls.

Please Login or Register  to view this content.

[Shift-4]

Yup. 100% sure. Copied my sample directly from my code.

I thought the same thing and double checked myself

[Leith Ross]

Hello Shift-4,

Can you post the code for the Sub or Function you are using?

[Shift-4]

Here is the full code.
Replacing it to .xlsx works fine.
The 'kill' ends up killing everything however.

I temporarily have disabled the kill portion with '
(just in case you though that was my issue)

Please Login or Register  to view this content.

[Shift-4]

I also can't get code to work to ignore 'update links'
If anyone could help with that it would be appreciated as well

[shg]

I don't have the courage to use a wildcard in a Kill statement. I would move the xls files to a temp folder in the same directory and delete them later -- much later.

[Leith Ross]

Hello Shift-4,

You said...

The 'kill' ends up killing everything however.

Does this mean it is eliminating other xls files you did not want deleted?

The nature of the wildcard is to match any file with the pattern. In this case ALL files ending in .xls will be deleted. So not just the workbooks but also any other non workbook files too.

[Shift-4]

Hello Shift-4,

You said...


Does this mean it is eliminating other xls files you did not want deleted?

The nature of the wildcard is to match any file with the pattern. In this case ALL files ending in .xls will be deleted. So not just the workbooks but also any other non workbook files too.

It also deleted .xlsx files
I thought with using "*.xls" it should only kill those files that only end in .xls but it deleted everything.

[shg]

In my brief testing, it deletes any file containing .xls not followed by another dot -- bob.xls, bob.xlsm, bob.xlsabc, ..., but not bob.xls.txt.

As I said, I don't have the courage to use a wildcard in a kill statement. They don't go to the recycle bin.