{"id":4393,"date":"2024-12-05T01:07:42","date_gmt":"2024-12-05T01:07:42","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/05\/tra-cuu-doanh-nghiep-bo-tron-tren-excel-voi-addins-hocexcelonline\/"},"modified":"2024-12-05T01:07:42","modified_gmt":"2024-12-05T01:07:42","slug":"tra-cuu-doanh-nghiep-bo-tron-tren-excel-voi-addins-hocexcelonline","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/05\/tra-cuu-doanh-nghiep-bo-tron-tren-excel-voi-addins-hocexcelonline\/","title":{"rendered":"Tra c\u1ee9u doanh nghi\u1ec7p b\u1ecf tr\u1ed1n tr\u00ean Excel v\u1edbi Addins HocExcelOnline"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p>Ti\u1ebfp t\u1ee5c v\u1edbi lo\u1ea1t h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng add ins HocExcelOnline.<\/p>\n<p>H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Heosql h\u00e0m trong add ins HocExcelOnline\u00a0 \u0111\u1ec3 s\u1eed d\u1ee5ng l\u1ecdc v\u00e0 t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n.<\/p>\n<p>\u0110\u1ea7u ti\u00ean \u0111\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c c\u00e1c b\u1ea1n xem l\u1ea1i video h\u01b0\u1edbng d\u1eabn c\u00e0i \u0111\u1eb7t add ins<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cai-dat-add-ins-hocexcelonline.html\"> t\u1ea1i \u0111\u00e2y<\/a><\/p>\n<p>Sau khi c\u00e0i \u0111\u1eb7t add ins c\u00e1c b\u1ea1n m\u1edf file Excel v\u00e0 file th\u1ef1c h\u00e0nh m\u00ecnh \u0111\u1ec3 trong \u0111\u01b0\u1eddng d\u1eabn \u0111\u00ednh k\u00e8m <a href=\"https:\/\/mega.nz\/#!o99CjSAZ!mfq_wiyqGEs-yjGuYIdd8KqDJD1WyNsGT6oHePu5vag\">sau \u0111\u00e2y<\/a><\/p>\n<p>C\u00e1c b\u1ea1n gi\u1ea3i n\u00e9n file ra &gt;&gt; l\u01b0u \u00fd l\u00e0 file \u0111\u1ec3 trong \u0111\u01b0\u1eddng d\u1eabn kh\u00f4ng \u0111\u1ea5u nh\u00e9 c\u00e1i n\u00e0y \u0111\u1ec3 tr\u00e1nh l\u1ed7i x\u1ea3y ra. Trong file n\u00e9n s\u1ebd c\u00f3 hai file 1 l\u00e0 file access(file d\u1eef li\u1ec7u doanh nghi\u1ec7p b\u1ecf tr\u1ed1n \u0111\u1ebfn ng\u00e0y 30\/11\/2018), 1 file excel l\u00e0 m\u00ecnh \u0111\u00e3 vi\u1ebft s\u1eb5n c\u00f4ng th\u1ee9c ch\u1ea1y c\u00f9ng v\u1edbi add ins HocExcelOnline.<\/p>\n<p>Ch\u00fang ta v\u00e0o b\u1eaft \u0111\u1ea7u x\u00e2y d\u1ef1ng c\u00f4ng th\u1ee9c v\u1edbi h\u00e0m Heosql nh\u00e9.<\/p>\n<ul style=\"list-style-type: disc\">\n<li>H\u00e0m Heosql c\u00f3 4 \u0111\u1ed1i s\u1ed1 truy\u1ec1n v\u00e0o.\n<ul>\n<li>1 c\u00e2u truy v\u1ea5n( c\u00e1i n\u00e0y l\u00e0 c\u00e2u l\u1ec7nh sql c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o trong kh\u00f3a <a href=\"https:\/\/www.hocexcel.online\/course\/preview\/vba201-lap-trinh-vba-nang-cao-trong-excel\">VBA201 -L\u1eadp tr\u00ecnh VBA n\u00e2ng cao trong Excel<\/a>)<\/li>\n<li>2 C\u00e1c t\u00f9y ch\u1ecdn trong h\u00e0m<\/li>\n<li>3 \u0110\u01b0\u1eddng d\u1eabn c\u1ee7a h\u00e0m<\/li>\n<li>4 M\u1eadt Kh\u1ea9u (* L\u01b0u \u00fd ch\u1ec9 d\u00e0nh cho file Access c\u00f3 s\u1eed d\u1ee5ng m\u1eadt kh\u1ea9u)<\/li>\n<\/ul>\n<\/li>\n<li>X\u00e2y d\u1ef1ng c\u00e2u truy v\u1ea5n sql \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u g\u1ea7n \u0111\u00fang ta s\u1eed d\u1ee5ng t\u1eeb kh\u00f3a like k\u1ebft h\u1ee3p t\u1eeb kh\u00f3a %% \u0111\u1ec3 l\u1ecdc t\u1ea1i \u00f4 A1 ta vi\u1ebft h\u00e0m sau:<\/li>\n<\/ul>\n<blockquote>\n<p><strong>=\u201dSELECT TOP \u201c&amp;Heorange($B$3,3)&amp;\u201d TENCHICUC, MSTCHICUCQL, MASOTHUEDN, TENDN, IDCSH, NGAYBATDAU, NGAYKETTHUC, THONGTIN, LUUTRU FROM DATA WHERE TENCHICUC LIKE \u201c&amp;Heorange($B$4)&amp;\u201d or MSTCHICUCQL LIKE \u201c&amp;Heorange($B$4)&amp;\u201d or MASOTHUEDN LIKE \u201c&amp;Heorange($B$4)&amp;\u201d Or TENDN LIKE \u201c&amp;Heorange($B$4)&amp;\u201d\u201d<\/strong>)<\/p>\n<\/blockquote>\n<p>T\u1ea1i \u00f4 B2 c\u00e1c b\u1ea1n g\u00f5 h\u00e0m sau v\u00e0o \u0111\u1ec3 l\u1ea5y \u0111\u01b0\u1eddng d\u1eabn file d\u1eef li\u1ec7u \u0111\u00e2y l\u00e0 file Access khi l\u1ea5y \u0111\u01b0\u1ee3c \u0111\u01b0\u1eddng d\u1eabn c\u00e1c b\u1ea1n copy &gt;&gt;&gt; pates(V) d\u00e1n gi\u00e1 tr\u1ecb \u0111\u1ec3 cho n\u00f3 kh\u00f4ng b\u1ecb thay \u0111\u1ed5i.<\/p>\n<blockquote>\n<p style=\"text-align: center\"><strong>=Heoduongdan()<\/strong><\/p>\n<\/blockquote>\n<p>T\u1ea1i \u00f4 B3 c\u00e1c b\u1ea1n g\u00f5 v\u00e0o s\u1ed1 d\u00f2ng k\u1ebft qu\u1ea3 mu\u1ed1n tr\u1ea3 n\u1ebfu t\u00ecm g\u1ea7n \u0111\u00fang.<\/p>\n<div class=\"code-block code-block-3\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-354.gif\" title=\"ex101_92019-nho-354\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-154.gif\" title=\"vba101_92019-nho-154\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-354.gif\" title=\"ex101_92019-nho-354\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>T\u1ea1i \u00f4 B4 c\u00e1c b\u1ea1n g\u00f5 t\u1eeb kh\u00f3a t\u00ecm ki\u1ebfm. nh\u01b0 h\u00ecnh \u1ea3nh sau.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-29470\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2019-08-16_103554-2.png\" width=\"1893\" height=\"466\" title=\"2019-08-16_103554-2\"><\/p>\n<p>T\u1ea1i d\u00f2ng t\u1eeb B5 : K5 c\u00e1c b\u1ea1n thi\u1ebft k\u1ebf ti\u00eau \u0111\u1ec1 nh\u01b0 trong h\u00ecnh<\/p>\n<p>t\u1ea1i \u00f4 B6 c\u00e1c b\u1ea1n g\u00f5 c\u00f4ng th\u1ee9c sau:<\/p>\n<blockquote>\n<p style=\"text-align: center\"><strong>=Heosql($A$1,\u201dSTT = Y, CHEN = Y\u201d,$B$2)<\/strong><\/p>\n<\/blockquote>\n<p>V\u1eady l\u00e0 xong gi\u1edd c\u00e1c b\u1ea1n quay l\u1ea1i xem th\u00e0nh qu\u1ea3 c\u1ee7a c\u00e1c b\u1ea1n thay \u0111\u1ed5i \u00f4 B3 ho\u1eb7c B4 r\u1ed3i xem k\u1ebft qu\u1ea3 \u1edf d\u01b0\u1edbi.<\/p>\n<p>Th\u1eadt \u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng n\u00e0o ch\u1ec9 v\u1edbi v\u00e0i b\u01b0\u1edbc nh\u1ecf c\u00e1c b\u1ea1n \u0111\u00e3 t\u1ef1 t\u1ea1o cho m\u00ecnh h\u00e0m l\u1ecdc v\u1edbi nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n v\u1edbi Add ins HocExcelOnline<\/p>\n<p>B\u1ea1n c\u00f3 th\u1ec3 t\u1ef1 t\u1ea1o ra ph\u1ea7n l\u1ecdc kh\u00e1c khi k\u1ebft h\u1ee3p v\u1edbi Addins HocExcelOnline<\/p>\n<p>N\u1ebfu c\u00f3 v\u01b0\u1edbng m\u1eafc b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ec3 l\u1ea1i cmt b\u00ean d\u01b0\u1edbi cho H\u1ecdc Excel Online.<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-354.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4394,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4393","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4393","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=4393"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4393\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4394"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4393"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4393"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4393"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}