Download File from Internet URL using API functions

Raj_123

New Member
Joined
Jun 13, 2008
Messages
2
<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>
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
56,910
Office Version
  1. 365
Platform
  1. Windows
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,129,352
Messages
5,635,785
Members
416,882
Latest member
ericvrealty

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top