[AccessD] Exchange Rate - Currency Converter thingy

jack drawbridge jackandpat.d at gmail.com
Fri Jun 29 07:33:50 CDT 2012


Hi guys,

My interest in the xmlhttp and DomDocument were an attempt to use these
with vba (and answer Darren's post). I could find no vba samples
interacting with these and it seemed (perhaps I am the naive one) that it
should be available/doable. I did find some Excel vba specific examples.

Glad to see that Shamil has more free/idle time than JC to show us several
ways to get the exchange rate (parse XML).
???How do these guys have the time(stamina) to rebuild multi gig servers,
latest HW, understand the details of all these languages, respond(with
examples) to a variety of questions, and still have time to make a living,
and maintain family life???

I did see samples where people treated the xml (or html in many cases) as a
plain text string and began using InStr, Mid etc, (head-down brute force)
but did not use any constructs (xml parser,XSL,??? etc).

Happy to see alternatives.

Jack

On Fri, Jun 29, 2012 at 8:16 AM, Gustav Brock <gustav at cactus.dk> wrote:

> Hi Shamil
>
> No, you are right of course. "Always", "never", "best" are dangerous
> words. "It depends" is probably the most valid phrasing.
>
> /gustav
>
>
> >>> mcp2004 at mail.ru 29-06-12 13:52 >>>
> Hi Gustav --
>
> > *I guess the API method would be marginally faster for fetching small
> > files and few values - but very inflexible.*
> Well, 'flexibility', 'adaptability',... don't have an absolute meaning for
> software projects, do they?
> API + parsing "naive hardcoder"'s "quick & dirty" *solution could be
> considered as the most flexible in some contexts - after all it doesn't
> depend on XML parsers, XSL transformations etc. - it just works...
>
> Thank you.
>
> -- Shamil
>
> Fri, 29 Jun 2012 13:27:09 +0200 от "Gustav Brock" <gustav at cactus.dk>:
>
>
>
> Hi Shamil
>
> No no. By the phrasing:
>
> > next step would be to just download the xml-string and parse it.
>
> I just meant to fetch the file content without using the XML library and
> then parse it (the same way as you demonstrated or similar).
>
> As to your project, I guess the API method would be marginally faster for
> fetching small files and few values - but very inflexible.
>
> /gustav
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list