Hi All,
I am building an application through Excel to update specific internal website information.
My question is, is there an easier way to identify and view the tags on a web page without having to right-click and "view source"?
Thanks
Hi All,
I am building an application through Excel to update specific internal website information.
My question is, is there an easier way to identify and view the tags on a web page without having to right-click and "view source"?
Thanks
Last edited by JRLats; 12-21-2009 at 06:27 PM.
Hello JRLats,
You can use VBA to grab the page source an place it in string. You can then do search and replace operations as needed. Here is VBA macro to grab the page source.
Example of calling the macroPlease Login or Register to view this content.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thank you Leith! This is a huge help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks