Deleting on files via Excel macro

Thank you. How do wildcards work in the Kill statement?

I'd like to delete all files starting with "Combined Town Report" and end with ".xlsx". The bit in the middle is normally the date which differs each day. How would I do this? Every variation I can think of doesn't appear to work.

An additional question to above. I've tried deleting all .XLS files in a folder on our intranet with the following code but I get the error sayign file not found. What am I doing wrong?:

Please Login or Register  to view this content.

And yes there are .xls files in the folder. :-)

OK, it seems I cannot save or delete anything on that intranet (http) addresses in an Excel macro. Is this correct?

Basically this code works:

Please Login or Register  to view this content.

But this doesn't:

Please Login or Register  to view this content.

Any thoughts on why the Kill command will not work with intranet/internet links? FlieCopy also doesn't appear to work.

The error is bad file but the code is exactly the same apart from being online.

Anyone know why FileCopy and Kill commands don't appear to work on intranet/Internet addresses?

Right, shame that as it means the marcro will need some manual work still. Ta for the reply.

I've found a solution to this, at least for me. I can change the http addresses to \\intranet\ addresses.

Kill and FileCopy commands seem to work with this type of address. Pretty simple in the end.