Hi Lads,
I've the macro translating data from one sheet to another. The last 2 years it was working very good.
Last Friday I can only see the error: 91. Is there anybody can help with it? I think the links might be changed but I've no idea how to verify this.
I've checked with google but didn't find any solution yet.
File as attached with some data example - click the button "Create Data for ship file" and see the result in the sheet "Temp - Ship File".
Regards,
Rufles
No help Lads?
Hi Lads, it looks like nobody know how to fix this? Any alternative ideas instead?
There are some lasses here, too.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
I cannot speak to any specifics, but I recall others with various issues with Google related functions that were caused by recent changes to Google's terms of service. Google changed some things earlier this year (I don't know the details) that caused a lot of people's Google based functions to "break". As indicated, I don't know the details. Since you aren't getting any input from this site, I would suggest you pose this question to someone at Google who may be able to help you understand what that error 91 means and perhaps explain how the recent changes to their terms of service caused your working code to suddenly break.
Originally Posted by shg
The issue has affected some website APIs, such as Google Maps, which although still free for small usage, now requires the user to lodge credit card details so they can be charged for more heavy use. It may be something similar here.
Sorry girls ;-)
There are some lasses here, too.
The web page has changed significantly. The object you are trying to read doesn't exist anymore (result_box) or whatever it was.
Try this modified version... I assume it is slower but should work:
I should point out I did very little, most of the credit goes to QHarr on StackOverflow
You may want to disable .Visible = True... that will prevent the browser from popping up on the screen.
Please Login or Register to view this content.
Error checking may not work as desired anymore either... but I assume you can tweak that if needed.
Last edited by Arkadi; 12-12-2018 at 03:01 PM. Reason: Forgot to credit the source.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Thanks for getting me on track so I know what's the problem with it. I'll try to amend the code to see the missing object, but for now I don't know how to do it.
Hi Ruffles... if you replace your function with the one I posted, the translations will work again...
Thanks Arkadi, I wish to use the function you have posted but I can't. The one I'm using was dealing with diacratic marks too by Public Function BezDia.
Is there any chance you can implement the Function BezDia into yours?
Regards,
Rufles
Hi Ruffles...
Is it not as simple as replacing one line? (maybe I'm missing something)
to:Please Login or Register to view this content.
Please Login or Register to view this content.
Thanks Arkadi, I feel a little bit stupid right now. This is exactly what I was looking for...
Lol, no worries
If this solves the issue please remember to mark the thread as solved? Thanks!
Also, thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks