Extract data from an ASP server with Excel?

pepemosca · #1 (**permalink**) 05-27-08, 11:31

Hello,
Does anyone has a method to extract data from an ASP server using Excel?

I want to extract data from a server like this one:
http://energia.mecon.gov.ar/upstream/US_MPerf.asp

So, what I need is to create all the options and "press" "<< Consultar >>" and get the data.

Is easy to do it when you have a PHP server, where I will do something like:
http://energia.mecon.gov.ar/upstream/US_MPerf.asp?Anio=2007&Mes=1

But with this ASP servers... I don't know how

Ideas?
Thanks!

gvee · #2 (**permalink**) 05-27-08, 12:06

your question does not make sense to me; if it was PHP how would you achieve this?

The bit on the end of the url (everything after the question mark (?)) is called a querystring; which is not PHP specific - in fact they're used widely in ASP, too!

pepemosca · #3 (**permalink**) 05-27-08, 13:43

I will use this:
http://img261.imageshack.us/img261/7008/dibujohk3.jpg

But that doesn't work with with this page:
http://energia.mecon.gov.ar/upstream/US_MPerf.asp

Any ideas how to copy that page?

pepemosca · #4 (**permalink**) 05-27-08, 13:44

And use this code:

Code:

'La consulta en si misma
With ActiveSheet.QueryTables.Add(Connection:= _
    "URL;" & vURL _
    , Destination:=Range("H" & vFilaUltima + 1))
    .Name = _
    "Import"
    .FieldNames = True
    .RowNumbers = False
    .FillAdjacentFormulas = False
    .PreserveFormatting = True
    .RefreshOnFileOpen = False
    .BackgroundQuery = False
    .RefreshStyle = xlInsertDeleteCells
    .SavePassword = False
    .SaveData = False
    .AdjustColumnWidth = True
    .RefreshPeriod = 0
    .WebSelectionType = xlEntirePage
    .WebFormatting = xlWebFormattingNone
    .WebPreFormattedTextToColumns = True
    .WebConsecutiveDelimitersAsOne = True
    .WebSingleBlockTextImport = False
    .WebDisableDateRecognition = False
    .WebDisableRedirections = False
    .Refresh BackgroundQuery:=False
End With