Hi Team,
I am a fresher & new to this group.
Using API function ,I wrote a Macro code to download the file from Internet. This works when I have complete value of the URL. But I want to download the file without entering full value of the URL.
In detail:-.
Each and every day, new files will be updated in my(x.com) website. For example, the URL of the website is www.me.com
URL of the file to Download is http://www.me.com/13jun2008_1200.txt
The standard format of the file name is " DDMONYYYY_HHMM.txt".
http://www.me.com/13jun2008_1200.txt
Here the problem is ,I know the date part (DDMONYYYY) of the file name but I do not know the exact time(HHMM) value part of the file name.
But I am sure the , only one file will be updated for each day with varying time.
I have to write a code to download the file each day automatically.
Please advise , as like directory file path I cannot specify (*)http://www.me.com/13jun2008_*.txt - This is NOT working.
In VB macro how to find out the valid remaing value of the URL?
Can anybody help me on this. Thanks in advance.
I am a fresher & new to this group.
Using API function ,I wrote a Macro code to download the file from Internet. This works when I have complete value of the URL. But I want to download the file without entering full value of the URL.
In detail:-.
Each and every day, new files will be updated in my(x.com) website. For example, the URL of the website is www.me.com
URL of the file to Download is http://www.me.com/13jun2008_1200.txt
The standard format of the file name is " DDMONYYYY_HHMM.txt".
http://www.me.com/13jun2008_1200.txt
Here the problem is ,I know the date part (DDMONYYYY) of the file name but I do not know the exact time(HHMM) value part of the file name.
But I am sure the , only one file will be updated for each day with varying time.
I have to write a code to download the file each day automatically.
Please advise , as like directory file path I cannot specify (*)http://www.me.com/13jun2008_*.txt - This is NOT working.
In VB macro how to find out the valid remaing value of the URL?
Can anybody help me on this. Thanks in advance.