Hi,
This is new territory for me, and I've spent a while trying to get this
website to return a table of data based on selections other than the
defaults, but not had any luck.

This is the website:
http://www.so-cdu.ru/Reporting/Repor...en_cons_hourly
its a Russian power industry website.
(looking at the source code I think it should appear in English, but
doesn't for me (in England))

The drop downs are for Region and Date, and the data I want to import
is at down below the chart.

No matter what I do it just gives me the default region and today's
date.
Here's my code, which just tries to change the date:

sub Test()
With ActiveSheet.QueryTables.Add(Connection:= _

"URL;http://www.so-cdu.ru/Reporting/Reports.aspx?name=gen_cons_hourly",
_
Destination:=Range("A1"))
.PostText = "Date=15.10.2006"
.Name = "Reports.aspx?name=gen_cons_hourly"
End With
End Sub

I've tried different date formats, field names (DATE and date and Date)
but no luck.
I think I must be doing something stupid.

(If I get this working my next challenge is to change the region - and
when I've tried to paste the region names into VBa the Cyrillic
characters don't appear.)

Any help would be greatly appreciated,
Regards,
Dransfield