About Us

Sifemer

thanks Don,
i sent you my email adress to

"Don Guillett" wrote:

As I said, the only way I can think of to do this is to actually do the web
fetch starting with 20 and working backwards until it gets a hit.
Give me your email and I will send a workbook that stops the last one at
version 13.

--
Don Guillett
SalesAid Software

"Sifemer" wrote in message
...
I want that the macro will look for the version number (the last one) and
put
it in the URL adress (because the URL adress contains that number its
after
teh
date)"URL;ftp://aftp.ieso.ca/pub/reports/PUB/SAADaily/PUB_SAADaily_20070512_Vnumber.0.htm".
thats why i need to know wich is the last number ( to put it in the URL
adress)

thanks again Don

"Don Guillett" wrote:

I'm still not sure why you need to know which is the last version. They
don't appear to change. I did try working backwards from 20 until I got a
hit on the web fetch. so maybe ??? something like this. I would need to
try
it.

for i=20 to 1 step -1
on error resume next
if get a hit msgbox i (would give the last available version)??
next i
????

--
Don Guillett
SalesAid Software

"Sifemer" wrote in message
...
Don,
waht i wanna do is :

private sub lastversion()
dim number as interger
number =1
do while
dir"URL;ftp://aftp.ieso.ca/pub/reports/PUB/SAADaily/PUB_SAADaily_20070512_vnumber.0.htm")<""
number=number+1
loop
lastversion = number
end sub

i know that the funtion dir is wrong thats what i'm looking for.
(something like dir or something wich gonna help me to test if url
exists
or
not)
thanks again
"Don Guillett" wrote:

It depends on what you are trying to do. I can't tell without an
actual
sample with the real url. Perhaps a for i to 22 and stop if you find
it.
--
Don Guillett
SalesAid Software

"Sifemer" wrote in message
...
thak you Don!
the question is how to know what is the last version in the adtress
is
it
V12, V13.....it starts at V1 and there are around 16 Versions a day
the URL:"http://blablabla_"&mynewdate&"_v " & VersionNumber &
".0.htm"

"Don Guillett" wrote:

basic idea to incorporate into a loop
"http://blablabla_"&mynewdate&"_v12.0.htm"

--
Don Guillett
SalesAid Software

"Sifemer" wrote in message
...
Hi,
i import data from a web site using web query, but the URL
changes
manytimes. the adress contains date and version "let say:
http://blablabla_yyyymmdd_v12.0.htm". if anyone has an idea how
to
loop
trought the adress to check for the last version for each date.
thanks

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Import New Database Query (Union Query) in Spreadsheet	klock	Excel Discussion (Misc queries)	2	September 24th 09 01:30 AM
Convert hard coded query criteria to Parameter Query	Melanie[_2_]	Excel Discussion (Misc queries)	0	July 15th 08 09:59 PM
Excel 2007 / MS Query - editing existing query to another sheet	Hotpepperz	Excel Discussion (Misc queries)	0	June 13th 08 06:53 PM
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook?	jocke	Excel Discussion (Misc queries)	1	November 29th 05 01:44 PM
Problem with .Background Query option of ODBC Query	Shilps	Excel Programming	0	April 19th 04 06:41 AM

Menu

About Us