Download File from Internet URL using API functions

[Raj_123]

<TABLE class=tborder id=post1594708 cellSpacing=0 cellPadding=6 width="100%" align=center border=0><TBODY><TR vAlign=top><TD class=alt2 style="BORDER-RIGHT: #ffffff 1px solid; BORDER-TOP: #ffffff 0px solid; BORDER-LEFT: #ffffff 1px solid; BORDER-BOTTOM: #ffffff 0px solid" width=175></TD><TD class=alt1 id=td_post_1594708 style="BORDER-RIGHT: #ffffff 1px solid"><HR style="COLOR: #ffffff; BACKGROUND-COLOR: #ffffff" SIZE=1><!-- / icon and title --><!-- message -->
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".

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.
</TD></TR></TBODY></TABLE>

 

[Joe4]

If you are going to cross-post in differerent parts of the forum, please provide links in each thread to the other thread, and be sure to update both if and when you get a solution.
http://www.mrexcel.com/forum/showthread.php?t=324628

Is your macro in Access? If not, how is Access involved in this issue?