Skip to content

Instantly share code, notes, and snippets.

@itsN1X
Created February 25, 2020 03:20
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save itsN1X/5633d0977e003cc3c0d8ee1ea89b7fec to your computer and use it in GitHub Desktop.
Save itsN1X/5633d0977e003cc3c0d8ee1ea89b7fec to your computer and use it in GitHub Desktop.
How to extract URLs via MSE-VB, by using a new module.

CHY104 Wiki 14BME0133.github.io MEE2002L MEE2002 MEE215 MEE499_7975 7972_subdefault MEE4006 MEE4006L 7950_zDump 7932_ZDump MEE1032L MEE1032 14BME-index ALLS RES001 IT MEE499 MGT402 MEE218 stst133 MEE1004L MEE1004 MEE305 MEE306 VIT-list-API-frontend d3 MEE1005 PHY101L PHY101 MEE107 MEE102 CHY101 CHY102 EEE101 MEE203 sandbox MEE244 x133.ml MEE307 MEE243 MEE308 MAT104 MEE302 MAT205 MEE401 MEE207 PHY102L PHY102 HUM121 MEE498 EXC666 EXC458 MAT114L MEE202 MEE304 STS102 STS101 STS302 MEE241 MEE437 MEE432 MEE304L CSE219 CSE219L MEE243L CHY102L HUM101 EXC138 EXC129 EXC120 MEE303 MEE303L MEE301L MEE301 MEE217 MEE217L MEE214L STS301 STS202 STS201 MEE216 MEE216L MEE206 MEE206L MEE205L MEE205 MEE204 MAT115 ENG102L ENG102 EEE101L MEE103 CSE109L CSE109 MAT114 ITE101L ITE101 ENG101L ENG101 CHY101L MEE108 MEE214 MAT115L MAT201 ESP101 CSE418

QuuT, right?

This was done using a macro from ..lol, MSE-MVB

Such basic. Quick wow!

Visual Code:

Sub ExtractHL()
Dim HL As Hyperlink
For Each HL In ActiveSheet.Hyperlinks
HL.Range.Offset(0, 1).Value = HL.Address
Next
End Sub

Result:

[	CHY104	](	https://github.com/14BME0133/CHY104	)
[	Wiki	](	https://github.com/14BME0133/Wiki	)
[	14BME0133.github.io	](	https://github.com/14BME0133/14BME0133.github.io	)
[	MEE2002L	](	https://github.com/14BME0133/MEE2002L	)
[	MEE2002	](	https://github.com/14BME0133/MEE2002	)
[	MEE215	](	https://github.com/14BME0133/MEE215	)
[	MEE499_7975	](	https://github.com/14BME0133/MEE499_7975	)
[	7972_subdefault	](	https://github.com/14BME0133/7972_subdefault	)
[	MEE4006	](	https://github.com/14BME0133/MEE4006	)
[	MEE4006L	](	https://github.com/14BME0133/MEE4006L	)
[	7950_zDump	](	https://github.com/14BME0133/7950_zDump	)
[	7932_ZDump	](	https://github.com/14BME0133/7932_ZDump	)
[	MEE1032L	](	https://github.com/14BME0133/MEE1032L	)
[	MEE1032	](	https://github.com/14BME0133/MEE1032	)
[	14BME-index	](	https://github.com/14BME0133/14BME-index	)
[	ALLS	](	https://github.com/14BME0133/ALLS	)
[	RES001	](	https://github.com/14BME0133/RES001	)
[	IT	](	https://github.com/14BME0133/IT	)
[	MEE499	](	https://github.com/14BME0133/MEE499	)
[	MGT402	](	https://github.com/14BME0133/MGT402	)
[	MEE218	](	https://github.com/14BME0133/MEE218	)
[	stst133	](	https://github.com/14BME0133/stst133	)
[	MEE1004L	](	https://github.com/14BME0133/MEE1004L	)
[	MEE1004	](	https://github.com/14BME0133/MEE1004	)
[	MEE305	](	https://github.com/14BME0133/MEE305	)
[	MEE306	](	https://github.com/14BME0133/MEE306	)
[	VIT-list-API-frontend	](	https://github.com/14BME0133/VIT-list-API-frontend	)
[	d3	](	https://github.com/14BME0133/d3	)
[	MEE1005	](	https://github.com/14BME0133/MEE1005	)
[	PHY101L	](	https://github.com/14BME0133/PHY101L	)
[	PHY101	](	https://github.com/14BME0133/PHY101	)
[	MEE107	](	https://github.com/14BME0133/MEE107	)
[	MEE102	](	https://github.com/14BME0133/MEE102	)
[	CHY101	](	https://github.com/14BME0133/CHY101	)
[	CHY102	](	https://github.com/14BME0133/CHY102	)
[	EEE101	](	https://github.com/14BME0133/EEE101	)
[	MEE203	](	https://github.com/14BME0133/MEE203	)
[	sandbox	](	https://github.com/14BME0133/sandbox	)
[	MEE244	](	https://github.com/14BME0133/MEE244	)
[	x133.ml	](	https://github.com/14BME0133/x133.ml	)
[	MEE307	](	https://github.com/14BME0133/MEE307	)
[	MEE243	](	https://github.com/14BME0133/MEE243	)
[	MEE308	](	https://github.com/14BME0133/MEE308	)
[	MAT104	](	https://github.com/14BME0133/MAT104	)
[	MEE302	](	https://github.com/14BME0133/MEE302	)
[	MAT205	](	https://github.com/14BME0133/MAT205	)
[	MEE401	](	https://github.com/14BME0133/MEE401	)
[	MEE207	](	https://github.com/14BME0133/MEE207	)
[	PHY102L	](	https://github.com/14BME0133/PHY102L	)
[	PHY102	](	https://github.com/14BME0133/PHY102	)
[	HUM121	](	https://github.com/14BME0133/HUM121	)
[	MEE498	](	https://github.com/14BME0133/MEE498	)
[	EXC666	](	https://github.com/14BME0133/EXC666	)
[	EXC458	](	https://github.com/14BME0133/EXC458	)
[	MAT114L	](	https://github.com/14BME0133/MAT114L	)
[	MEE202	](	https://github.com/14BME0133/MEE202	)
[	MEE304	](	https://github.com/14BME0133/MEE304	)
[	STS102	](	https://github.com/14BME0133/STS102	)
[	STS101	](	https://github.com/14BME0133/STS101	)
[	STS302	](	https://github.com/14BME0133/STS302	)
[	MEE241	](	https://github.com/14BME0133/MEE241	)
[	MEE437	](	https://github.com/14BME0133/MEE437	)
[	MEE432	](	https://github.com/14BME0133/MEE432	)
[	MEE304L	](	https://github.com/14BME0133/MEE304L	)
[	CSE219	](	https://github.com/14BME0133/CSE219	)
[	CSE219L	](	https://github.com/14BME0133/CSE219L	)
[	MEE243L	](	https://github.com/14BME0133/MEE243L	)
[	CHY102L	](	https://github.com/14BME0133/CHY102L	)
[	HUM101	](	https://github.com/14BME0133/HUM101	)
[	EXC138	](	https://github.com/14BME0133/EXC138	)
[	EXC129	](	https://github.com/14BME0133/EXC129	)
[	EXC120	](	https://github.com/14BME0133/EXC120	)
[	MEE303	](	https://github.com/14BME0133/MEE303	)
[	MEE303L	](	https://github.com/14BME0133/MEE303L	)
[	MEE301L	](	https://github.com/14BME0133/MEE301L	)
[	MEE301	](	https://github.com/14BME0133/MEE301	)
[	MEE217	](	https://github.com/14BME0133/MEE217	)
[	MEE217L	](	https://github.com/14BME0133/MEE217L	)
[	MEE214L	](	https://github.com/14BME0133/MEE214L	)
[	STS301	](	https://github.com/14BME0133/STS301	)
[	STS202	](	https://github.com/14BME0133/STS202	)
[	STS201	](	https://github.com/14BME0133/STS201	)
[	MEE216	](	https://github.com/14BME0133/MEE216	)
[	MEE216L	](	https://github.com/14BME0133/MEE216L	)
[	MEE206	](	https://github.com/14BME0133/MEE206	)
[	MEE206L	](	https://github.com/14BME0133/MEE206L	)
[	MEE205L	](	https://github.com/14BME0133/MEE205L	)
[	MEE205	](	https://github.com/14BME0133/MEE205	)
[	MEE204	](	https://github.com/14BME0133/MEE204	)
[	MAT115	](	https://github.com/14BME0133/MAT115	)
[	ENG102L	](	https://github.com/14BME0133/ENG102L	)
[	ENG102	](	https://github.com/14BME0133/ENG102	)
[	EEE101L	](	https://github.com/14BME0133/EEE101L	)
[	MEE103	](	https://github.com/14BME0133/MEE103	)
[	CSE109L	](	https://github.com/14BME0133/CSE109L	)
[	CSE109	](	https://github.com/14BME0133/CSE109	)
[	MAT114	](	https://github.com/14BME0133/MAT114	)
[	ITE101L	](	https://github.com/14BME0133/ITE101L	)
[	ITE101	](	https://github.com/14BME0133/ITE101	)
[	ENG101L	](	https://github.com/14BME0133/ENG101L	)
[	ENG101	](	https://github.com/14BME0133/ENG101	)
[	CHY101L	](	https://github.com/14BME0133/CHY101L	)
[	MEE108	](	https://github.com/14BME0133/MEE108	)
[	MEE214	](	https://github.com/14BME0133/MEE214	)
[	MAT115L	](	https://github.com/14BME0133/MAT115L	)
[	MAT201	](	https://github.com/14BME0133/MAT201	)
[	ESP101	](	https://github.com/14BME0133/ESP101	)
[	CSE418 	](	https://github.com/14BME0133/CSE418	)
Contriibuted in the public domain by Nikhil itsN1X Pandita

</14 BME 0 133>

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment