{"id":11809,"date":"2025-01-15T05:14:32","date_gmt":"2025-01-15T05:14:32","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-chuyen-url-dang-van-ban-thanh-nhung-lien-ket-co-the-mo-truc-tiep-tu-excel\/"},"modified":"2025-01-15T05:14:32","modified_gmt":"2025-01-15T05:14:32","slug":"cach-chuyen-url-dang-van-ban-thanh-nhung-lien-ket-co-the-mo-truc-tiep-tu-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/cach-chuyen-url-dang-van-ban-thanh-nhung-lien-ket-co-the-mo-truc-tiep-tu-excel\/","title":{"rendered":"C\u00e1ch chuy\u1ec3n URL d\u1ea1ng v\u0103n b\u1ea3n th\u00e0nh nh\u1eefng li\u00ean k\u1ebft c\u00f3 th\u1ec3 m\u1edf tr\u1ef1c ti\u1ebfp t\u1eeb Excel"},"content":{"rendered":"
\n

Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch chuy\u1ec3n nh\u1eefng URL ch\u01b0a \u0111\u01b0\u1ee3c li\u00ean k\u1ebft th\u00e0nh c\u00e1c li\u00ean k\u1ebft c\u00f3 th\u1ec3 m\u1edf tr\u1ef1c ti\u1ebfp t\u1eeb Excel.<\/p>\n

\"\"<\/a>C\u00f3 v\u1ebb kh\u00f4ng c\u00f3 c\u00e1ch n\u00e0o h\u1eefu d\u1ee5ng h\u01a1n l\u00e0 d\u00f9ng m\u00e3 VBA<\/a><\/p>\n

1. Ch\u1ecdn v\u00f9ng URL d\u1ea1ng v\u0103n b\u1ea3n m\u00e0 b\u1ea1n mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i.<\/p>\n

2. Nh\u1ea5n ALT+F11<\/strong> \u0111\u1ec3 m\u1edf Microsoft Visual Basic for Applications<\/strong>.<\/p>\n

3. Nh\u1ea5n Insert<\/strong> > Module<\/strong>, v\u00e0 d\u00e1n \u0111o\u1ea1n m\u00e3 sau v\u00e0o c\u1eeda s\u1ed5 Module.<\/p>\n<\/p>\n

View the code on Gist<\/a>.<\/div>\n
<\/div>\n
\n
4. Nh\u1ea5n F5 \u0111\u1ec3 ch\u1ea1y m\u00e3, m\u1ed9t h\u1ed9p tho\u1ea1i xu\u1ea5t hi\u1ec7n \u0111\u1ec3 b\u1ea1n ch\u1ecdn v\u00f9ng mu\u1ed1n chuy\u1ec3n \u0111\u1ed5i, ch\u1ecdn r\u1ed3i nh\u1ea5n OK<\/strong><\/div>\n
\"\"<\/a><\/div>\n<\/div>\n
<\/div>\n
Nh\u01b0 v\u1eady l\u00e0 to\u00e0n b\u1ed9 \u0111\u1ecba ch\u1ec9 URL \u0111\u00e3 \u0111\u01b0\u1ee3c chuy\u1ec3n th\u00e0nh hyperlinks 1 c\u00e1ch \u0111\u01a1n gi\u1ea3n v\u00e0 nhanh ch\u00f3ng r\u1ed3i<\/div>\n
<\/div>\n<\/div>\n
\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch chuy\u1ec3n nh\u1eefng URL ch\u01b0a..<\/p>\n","protected":false},"author":1,"featured_media":11810,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11809","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11809","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=11809"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11809\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11810"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11809"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11809"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11809"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}