LinkBack URL
About LinkBacks
Hello everyone. Is is possible to make macro that can go down list of websites on excel file in Column A and determine if website has a blog and then in Column B script will write Yes or No ?
Hello everyone. Is is possible to make macro that can go down list of websites on excel file in Column A and determine if website has a blog and then in Column B script will write Yes or No ?
Last edited by wonderd; 06-04-2019 at 03:48 PM.
What's the algorithm for "determine if website has a blog" ?
(and are you really still using Excel 2003?)
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Excel 2003 is not an issue …
? It might be. If they're actually using a later Excel version which support Power Query, this may be a simpler solution. It kind of depends on the algorithm to determine if each website has a blog...Originally Posted by Marc L
I 1 000 % agree for the blog logic as I thought the same yesterday !
Excel 2003 does not have PowerQuerry but as I download Web data since years under this version, it's not an issue
but again I totally agree for this kind of stuff the better is to know on which Excel version(s) the code should run …
Last edited by Marc L; 06-05-2019 at 05:48 AM. Reason: typo …
Thanks for the replies. I am using excel 2010. I updated my profile.
I am not sure the logic that would needed to be used.
Last edited by wonderd; 06-05-2019 at 02:00 PM.
Okay. So what steps would you take to manually determine if a blog exists on a site?
I would see if the word "blog" was anywhere on the website.
On the webpage link it's easier …
Yes but I'm assuming not every website will have the same url structure for their blog.
can anyone help?
As you do not clarify what should be done so maybe some mind reader
as it depends on the samples you forgot to clearly explain and share in a workbook attachment …
The script will access any website listed in column A one by one and determine if the website has the word "blog" anywhere on the website. If the website has blog, then next to that website, in column B will be the word yes. If website does not have blog, script will wrote "No" in column B. Then move on to check the next website
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 provided the required cross-post link(s) here.
Read this to understand why we (and other sites like us) consider this to be important.
(Note: this requirement is not optional. No help to be offered until the link is provided.)
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.
The cross reference can be seen here https://www.mrexcel.com/forum/genera...ml#post5288578
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks