var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Extract data from an ASP server with Excel?
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:
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:
But with this ASP servers... I don't know how
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!
And use this code:
'La consulta en si misma
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;" & vURL _
, Destination:=Range("H" & vFilaUltima + 1))
.Name = _
.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
No ideas in how to use code like that?
Thanks for your comments.