Extract filename from URL

[Arafat]

Hello ,

i have a web url on which if we click a file gets downloaded, i have written a macro to download the files from list of URL's but i am not able to extract the actual filename of it.

Ex: https://www.somename.com/sonename/clients/HHHSSS/documents/T134/play

If we click on this link a audio gets downloaded. they are two types of audio format available here .dss and .wav . In my macro the file gets downloaded always in .dss format even the WAV format gets downloaded in .dss format.

Is there a way to determine the file extension or some workaround ?

Please help Folks

 

[Rick Rothstein]

Assuming URL is a variable containing the URL text, then this code will retrieve the text after the last dot after the last slash...

Ext = Mid(URL, InStrRev(URL, ".") + 1)
Ext = Left(Ext, -Len(Ext) * (Not Ext Like "*/*"))