Search results

I'm no longer using Mid() to try & extract the exact string "Amazon", but now using the Instr() function to look for the string "Amazon" somewhere along the row of captured text (I'm thinking that Amazon have different ways of saying they're selling the product, so I can't assume the text will...

Thanks guys excellent work - following on from my last post, I cracked on with my code & have it working - ish ...I think amazon are throttling, because when I ran it on my list of 150 ASINs I got an error after about 50 requests ...this led me to think that my IP address may end up getting...

I think they only use XML...this is of massive frustration...I came to their APIS totally new...I spent ages learning how to parse it & use the result within Access ...I figured that other platforms/marketplaces world take a similar approach....only to find that JSON seems to be the future! My...

Prepare to be amazed(!) - this is their closest API - close indeed, but no cigar... https://docs.developer.amazonservices.com/en_UK/products/Products_GetCompetitivePricingForASIN.html ...it doesn't yield the explicit information I need. Believe me...I've dealt with Amazon for years..they are...

So I found this useful tutorial... http://analystcave.com/excel-scrape-html-element-id/ which looked to be a good contender, so I modified it a little... Public Function GetElementById() Dim url As String Dim id As String Dim SoldByAmazon As Boolean Dim XMLHTTP As Object...

Hello Colin, I went back & took a look at your code...it looks (to me) like you are saving the webpage html to a text file, then parsing the text file using filesystem object to pull out the data of interest? Clearly that approach works, but I'm wondering whether there's a quicker way...

Yes I remember it well...at that time there was no meaningful JSON VBA parsing option available ...it looked like I was going to move website cart software & all their related APIs were JSON orientated (& therefore I was considering going with a different programming language) ....well in the...

Not my particular ASINs, but 5 randomly selected ASINs ... https://www.amazon.co.uk/dp/B0073H1CIC (not sold by Amazon) https://www.amazon.co.uk/dp/B00UQ8D5OE (not sold by Amazon) https://www.amazon.co.uk/dp/B01LWQBKMO (sold by Amazon) https://www.amazon.co.uk/dp/B0001IW8TW (sold by Amazon)...

To clarify - I just want to scrape a bit of text on an Amazon product webpage to see if Amazon are the seller of a product (if Amazon aren't selling the product themselves, then another seller's name will appear instead - so the text I am hunting for is "Dispatched from & Sold by Amazon")...

I'm not at my home PC at the moment but this looks very promising - I really appreciate the time you've put into this & look forward to attempting to integrate it into my larger overall body of code when I get home! (I actually need to Access traverse down a list of about 150 products - I...

Actually, I think that might be the problem, when I tried to debug.print the returned html, there wasn't any ...since posting, I've now had a good night's sleep - so I'm off to delve further & perhaps take another approach - thanks!

So I seek to have VBA go fetch an amazon product listing & extract the bit of text that tells me if Amazon themselves are the seller of the product. I found this ... https://www.wiseowl.co.uk/blog/s393/scrape-website-html.htm ...which is a great start/primer, but I'm still struggling! I wish...

Don't get me wrong guys...I'm not diss'ing Access...in fact I'd go so far to say it's been the one single revelation in running my one man business...I remember I had a 'penny dropped' aha moment when I realised I needed my own database to help me run my business - I fired up MS access for the...

You've pretty much summed it up, json (& I'm no expert!), is just another way of 'wrapping data' for transferring in a standardised manner...the problem is 'unwrapping it' when it arrives into VBA ...sure everything is doable, but unless there's a decent parser (like there is for XML in VBA)...

Thanks for the input (jdraw - very useful, but unless there's a way for VBA to handle JSON, I fear it's going to be a slog staying with Access). As I say, I'm happy with access, now starting to be able to use it well for most of my repetitive business tasks, but my heart sinks when I look at...

thanks for that (& the new terms I can google!), so I guess most API developers are using an SQL back end & a front end based on C# .Net , Java etc - but my understanding is that C# .Net , Java are programming languages (with their own IDE), so when we speak of 'front end' (which I may be...

So I've used Access extensively in my one man business- it's a wonderful tool. I've recently discovered using APIS, which is helping me be quite efficient with repetitive tasks. However in this vein, I'm seeing that most APIS I want to use are going the way of REST/json ....which there seems to...

I'm always reticent (embarrassed!) to do so becuase I'm not a programmer - I'm a kludger & otehr will likely wince!), but since you ask, here's what I did... Dim objFSO As Scripting.FileSystemObject Dim objText As Scripting.TextStream Dim strFullPathNameAndExtension As String Dim...

I managed to crack it (quite convoluted ...but I learnt some new stuff along the way) Basically, open the text file, read in the first row, use Split() To parse the header row text into an array. Once the text is in an array, read it out again & use Dlookup to get the lookup value from a...

So I have a problem that I can't really figure out the best way to approach. Background: Amazon require sellers to upload product flatfile files to modify listed products in their catalogue ...these flatfiles are quite unwieldly to use, so I want to basically I want to replicate their resulting...