• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to check URL validity

Alt F11 calls VB environment …

As there are differents types of modules !
Standard / general modules, UserForm modules, class modules
and special class modules for workbook (ThisWorkbook) and
for worksheets as you can read everywhere !
So in the Projects window just open the module of the worksheet …

Hello.
If you refer to the routine I can not select it (as you can see in the photo).
If it's not the routine, you should explain how it works ...
See you soon
 

Attachments

  • 18835330_1478304015565796_1969536693_n.jpg
    18835330_1478304015565796_1969536693_n.jpg
    63 KB · Views: 7
Alt F11 calls VB environment …

As there are differents types of modules !
Standard / general modules, UserForm modules, class modules
and special class modules for workbook (ThisWorkbook) and
for worksheets as you can read everywhere !
So in the Projects window just open the module of the worksheet …
 

Hi Mark.
Do I need to click "foglio 1" or "questa_cartella" before entering your code?
I must insert it here? did I get it right?
See you soon
 

Attachments

  • 1.JPG
    1.JPG
    62.6 KB · Views: 6

Narayan changed my code in its attachment in previous post
so result could not be the same as any pro tool …
(Redirection result issue in row #14 …)

Do I need to click "foglio 1" or "questa_cartella"
before entering your code?
The one with same worksheet name ! (foglio1)
 
In this post we finally reached a solution to the problem. NARAYANK991 has followed the original post and has postulated its solution, while Marc L has followed the real redirect rules by excluding the re-routing hypothesis I had envisioned on line 14 of my first post.
There is someone who comes to a desired solution and who respects the rules. The important thing is to get to the solution.
Thanks to both of you, you saved me a lot of time (think a little bit that to get your result on 15000 url I'll have worked two weeks).
Thank you
 
You've taught me that the code also inserts in the pages as well as in the forms etc. I still do not understand the difference, but that's fine.
 
You've taught me that the code also inserts in the pages as well as in the forms etc. I still do not understand the difference, but that's fine.

n. 50

Alt F11 calls VB environment …

As there are differents types of modules !
Standard / general modules, UserForm modules, class modules
and special class modules for workbook (ThisWorkbook) and
for worksheets as you can read everywhere !
So in the Projects window just open the module of the worksheet …
Never argue with an idiot, he'll bring you down to his level - then beat you with experience …

Marc L, Yesterday at 10:56 AM Report
#50 Like Reply
 
I just explained types of modules …

Post #57 was just an answer to post #56
as I can't code intuition but just good results respecting Logic :
from your own rules within initial post, row #14 can't be a redirection
as the domain does not change !
So with the post #54 mod, you can get wrong results …
 
I did not know there was this other type of module :)
I have to combine them together
I would like to realize a web idea and I need to solve several problems. With macros I could achieve good results ..
 
Back
Top