jack drawbridge
jackandpat.d at gmail.com
Fri Jun 29 15:57:30 CDT 2012
Thanks Shamil, I agree with your comments re stockpiling. My stockpiling has been going on a long time and is limited to a few tidbits and goodies gleaned from AccessD and a few forums. I've been retired for 4 and a half years and may just keep stockpiling and lurking - with a response every so often. I hadn't seen anything with vba and interacting with webpage/webservice. I'm using 2003 on XP and haven't quite gotten to Vb.net c#.net etc. It's difficult to get into .Net when you're not working in the field every day. Hard to remember from one concept to the next over a few days intermixed with adding a porch to the cottage, electrical, plumbing, flooring and finishing... and hopefully some fishing this year. I enjoy the forum, even though participation is quite rare. Jack On Fri, Jun 29, 2012 at 12:43 PM, Salakhetdinov Shamil <mcp2004 at mail.ru>wrote: > Hi Jack -- > > Short note: Glad you liked it, my pleasure! :) > > -- Shamil > > ----------------------- > > Longer note: > > Hi Jack, Gustav and All -- > > > My interest in the xmlhttp and DomDocument were > > an attempt to use these with vba (and answer Darren's post). > Yes, that's clear. > > Glad to see that Shamil has more free/idle time than JC > I guess I don't - but I don't need keeping tuning/rebuilding such a > powerful hardware "park" as JC does - so I can spend my free/idle time on > "musing on software coding techniques" :) ... > Happy to see alternatives. > Glad you liked them. In fact IMO what we're doing here in our > free/idle(?) time is investing in our own and this community software > development techniques knowledge accumulation or I'd call it, this > knowledge accrual process, getting often a shape of conglomeration of, on > first glance unrelated "knowledge bits", I'd call it even knowledge > stockpiling as one never knows when that hoarded knowledge will pay back, > but it will, I'm sure... > > ...and I'm planning (if free/idle time will allow) to continue such a > musing in coding in dba-VB as C#/VB.NET give many more options to solve > the same task "the most straightforward yet effective and flexible way", > which always depends on many factors as Gustav noted - and the factor of > "order of ignorance" (http://c2.com/cgi/wiki?OrdersOfIgnorance) is often > the main one - and by musing in coding here I'm lowering my own order/level > of ignorance trying to get at the 4th level of competence ( > http://c2.com/cgi/wiki?FourLevelsOfCompetence) in the software > development areas, which are or could be useful in my everyday professional > practice... > > Stay tuned... > > Thank you. > > -- Shamil > > > Fri, 29 Jun 2012 08:33:50 -0400 от jack drawbridge <jackandpat.d at gmail.com > >: > > > > 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 > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >