I have this macro with which I can search by Xpath if the HTML is simple
Now, if I want to use the same Xpath but with the source change to an URL, I get the error "DTD is prohibited".
Please Login or Register to view this content.
Why is happening this and how to fix it?
I can't use 3rd party tool like Selenium since I cannot use or installed exe files due to security policy in company.
Thanks in advance for any help
Please Login or Register to view this content.
Administrative Note:
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so. Cross-posts are allowed but you must provide a link to your posts on other sites.
Please see Forum Rule #7 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/
(Note: this requirement is not optional. No help to be offered until you provide a link or, for members with fewer than 10 posts, a comment telling us where else you have posted this query.)
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.
Hi AliGW, actually this question is a kind of different and in the other site after one day normally there is almost zero possibilities to get an answer. In that other quesion I didn´t get a solution anyway.
Last edited by AliGW; 05-16-2024 at 03:13 AM. Reason: Please don't quote unnecessarily - use the Quick Reply button instead.
Originally Posted by Severduf
You can overcome that error by setting the below property,
But, you will probably will get another error on a different line and this will continue ..... As i told you on the other side, it is not a good idea to work with this kind of code on HTML pages as there may be numerous errors in the HTML source such as missing end brackets and so on. But XML parsing requires the loaded XML file to be free of errors.Please Login or Register to view this content.
Hi Haluk, thanks for answer. After some research, I've tried that option yesterday and didn´t work either.
After adding that line I get the new error.
Additionally, in some sites mentioned that removing the string "<!DOCTYPE html>" from the html could work, but in my case doesn´t work.Please Login or Register to view this content.
Regards
Last edited by AliGW; 05-16-2024 at 03:13 AM. Reason: Please don't quote unnecessarily - use the Quick Reply button instead.
Well, it is not a surprise to me.....as I told you in my post #4 you will get a new error.
It is better for you to use some other techniques.
Thanks for your help
Last edited by AliGW; 05-16-2024 at 03:14 AM. Reason: Please don't quote unnecessarily - use the Quick Reply button instead.
Doesn't matter - you still need to abide by our rules. Thanks for the links - don't forget if you do this again to include them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks