Recent content by peskywinnets

It was actually 6500+ ... if you include also deleting debug.print without an ' at the front! (all those debug.prints amounts to 8yrs of my coding - I'm not a programmer, but have somehow kludged together something that I run my ecommerce business on...nice to be rid of them, I'm pretty sure...

Thankfully, all my debug.print are one liners :-)

Thanks for the tips, "Use Pattern Matching' on a ''Replace' seems to have done it...

Subject says it all really. My coding sees a multitude of modules which are peppered with debug.print lines that are not required anymore, it would take me forever to go through each module manually...is there a slick way of deleting any/all lines starting with debug.print?

>> OK, that's HOW you would do it. But the far more important question is WHY you think it is necessary. It's necessary, because if the process breaks (MS Access doesn't run all the APIs I've set it to run), then I'm in big trouble., Basically, I use access to go fetch my ebay orders (using a...

Any ideas for a watchdog timer, to say monitor a folder for a file that access has created..... & then notify someone remotely if the file hasn't been generated in the past x minutes? (I'm think email notification, but open to any ideas!)

Actually, I got lucky, within about 30 mins of trying different permutations, this code actually works... Public Sub Parcel2Go_GetAccessToken() Set XMLHTTP = CreateObject("MSXML2.ServerXMLHTTP.6.0") ClientID = "aaabbbcccdddeeeff" ' this isn't my real ClientID :-) ClientSecret = "xxyyxzz" '...

I've got several APIs working in access, but the headers & string formation is always a challenge ...every time I'm faced with a new one, same issues...and no examples for VBA,

Does anyone have the 'chops' to be able to arrange the following short snippet of code into VBA... POST /auth/connect/token HTTP/1.1 Host: sandbox.parcel2go.com User-Agent: insomnia/5.14.6 Content-Type: application/x-www-form-urlencoded Accept: */* grant_type=client_credentials...

I appreciate the input ...I may be mis-intpreting how to use what you've suggested - the error is thrown up in the json module itself (not in the function where my code is) ....& I don't want to deploy anything in the JSON module I'll google a bit more, because I find it difficult to believe...

I'm trying to parse using the popular VBA JSON parser, but because a key doesn't exist, my code breaks with a Run-Time error 13 Type Mismatch. Here's my line of code... EbayTaxType = json("lineItems")(1)("ebayCollectAndRemitTaxes")(1)("taxType") ...I've done a google search, but I'm going...

Because I'm out my depth! I've just found a post where someone seems to have made a successful Amazon API call using Version 4 signing (which is where I came unstruck)... https://stackoverflow.com/questions/75663343/create-a-signed-aws-api-request-to-a-lambda-function-url-from-excel-vba ...so...

At the foot of this page are some examples in various languages to do with the signing ... https://docs.aws.amazon.com/IAM/latest/UserGuide/create-signed-request.html

With their old MWS API (XML based, which is now going end of life) I managed to get the signing/encoding working (albeit, it took me a while as there is scant information for using VBA for making API calls), with this new SP-API (I think the SP stands for selling partner...its REST/JSON type)...

I have the same problem...I coded up my own VBA/Access based solution for the old MWS API, but the signing aspect is excessively complicated for the new SP-API (with little information on the web how to accomplish this in VBA)...so I'm facing being cut-off from retrieving Amazon data via API...