Top doanh nghiệp đã đăng ký cho nhân viên

Bạn sẽ học được gì?

Các kiến thức về Ribbon Excel
Các công cụ để tạo Thẻ lệnh trên Ribbon
Tư duy xây dựng công cụ quản lý bằng Excel
Xây dựng hoàn thiện một Thẻ lệnh quản lý của riêng bạn

Khoá học này sẽ có:

Video

3h 39m giờ học

Article

0 bài viết chuyên môn

Material

2 tài liệu đính kèm

Exam questions

0 đề thi ghi nhớ kiến thức

Nội dung khoá học

5 Chương . 39 bài giảng . 3h 39m giờ học

1

Bắt đầu Khóa học

2 bài học thử
2

Phần A: Các kiến thức về tạo thẻ lệnh trong Ribbon

2 bài học thử
3

Phần B: Dự án thực tế - Tạo Thẻ lệnh Quản lý nhân sự

4

Phần C: Mở rộng - Thêm các kiến thức hữu ích cho công việc

5

Phần D: Thực chiến

2 bài học thử

Mô tả khoá học

Chúng ta thường quen thuộc với các tab mặc định trong Excel như File, Home, Insert, Page Layout ... các tab này có những chức năng mặc định mà Microsoft thiết kế. Nhưng bạn nghĩ sao nếu chúng ta có thể tạo ra các tab tương tự như vậy với các chức năng được tùy biến riêng theo công việc hằng ngày của chúng ta ? Điều đó sẽ hỗ trợ bạn rất nhiều trong quản lý công việc và bạn khi đó sẽ là một chuyên gia thực thụ.

Cùng tìm hiểu trong khóa học này về cách Xây dựng add-in, thẻ lệnh quản lý công việc trên Excel nhé

Giảng viên:

G-LEARNING Giảng viên

Trường đào tạo & phát triển kỹ năng ứng dụng tin học văn phòng

G-LEARNING
  • 4.6 điểm đánh giá

  • 433 đánh giá

  • 223,465 học viên

  • 83 khóa học

Đánh giá của học viên

5 điểm đánh giá . 1 lượt đánh giá

Huỳnh Cao Cường

Huỳnh Cao Cường

02:56 19/02/2021

Mình đã thiết kế được ribbon riêng cho file làm việc, mong sớm có lớp về VSTO (visual studio for Office bẳng ngôn ngữ VB.net). Việc thiết kế ribbon riêng cho phép mình làm công việc nhẹ nhàng và thuận tiện hơn nhiều so với việc dùng các ribbon mặc định của Office.

Thảo luận về bài học

74 thảo luận

nguyen van thao

nguyen van thao 09 Nov 2022

Thầy cho em hỏi là code làm sao khi mà dữ liệu chưa được lọc thì nút Xóa Lọc ẩn đi. Còn khi ta lọc dữ liệu và muốn xóa đi thì nó hiện lại giống như nút Clear trong tab Data vậy thầy?

Em gửi link https://drive.google.com/file/d/1cK-st8FDjIQOY1n06Q6QB9YiofMd870K/view?usp=sharing Thầy xem dùm em ạ.

Tuấn Ba

Tuấn Ba [Chuyên gia] 09 Nov 2022

Nghĩa là cùng 1 nút 2 mục đích khác nhau đúng không?

{"id":259496,"crm_contact_id":460757,"name":"nguyen van thao","email":"nguyenvanthao2002@yahoo.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2022-11-03 15:46:56","confirmation_code":"c7b097f39bf23970315843dcdc0b9ca9","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2022-11-03T07:37:38.000000Z","updated_at":"2022-11-22T02:15:42.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":2,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":64651,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"pending","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/coach.png","link_profile":"https:\/\/gitiho.com\/u\/259496-nguyen-van-thao","business_employers":[],"vip_account":null,"roles":[]}

nguyen van thao 09 Nov 2022

Nút đó cũng giống như nút Clear đó Thầy. Vì khi dữ liệu không lọc mà bấm nút đó nó sẽ báo lỗi ạ

Nguyễn Trọng Hào

Nguyễn Trọng Hào 26 Jul 2022

Nhìn giao diện của e ok chưa thầy

Tuấn Ba

Tuấn Ba [Chuyên gia] 27 Jul 2022

ok luôn bạn bạn bỏ luôn phần ở dưới đi cũng được hoặc để hình ảnh đó cho đẹp

{"id":110050,"crm_contact_id":135819,"name":"Nguy\u1ec5n Tr\u1ecdng H\u00e0o","email":"haont@binhminhcorp.com.vn","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2020-11-21 10:03:38","confirmation_code":"cc230ca1a06bb8c0b38c83920d155759","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2020-11-20T07:57:39.000000Z","updated_at":"2022-07-11T02:01:14.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"Nguy\u1ec5n Tr\u1ecdng H\u00e0o","address":"(GIAO CH\u00cdNH X\u00c1C 21\/11) U1 c\u01b0 x\u00e1 v\u0129nh h\u1ed9i, p8, q4, hcm","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0773917400","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":73288,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":8,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/doctor.png","link_profile":"https:\/\/gitiho.com\/u\/110050-nguyen-trong-hao","business_employers":[],"vip_account":null,"roles":[]}

Nguyễn Trọng Hào 27 Jul 2022

dạ thầy!!!

Nguyễn Trọng Hào

Nguyễn Trọng Hào 11 Jul 2022

Tuấn Ba

Tuấn Ba [Chuyên gia] 13 Jul 2022

Bạn cần gọi ra trong bài 29 bạn nhé.

{"id":110050,"crm_contact_id":135819,"name":"Nguy\u1ec5n Tr\u1ecdng H\u00e0o","email":"haont@binhminhcorp.com.vn","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2020-11-21 10:03:38","confirmation_code":"cc230ca1a06bb8c0b38c83920d155759","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2020-11-20T07:57:39.000000Z","updated_at":"2022-07-11T02:01:14.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"Nguy\u1ec5n Tr\u1ecdng H\u00e0o","address":"(GIAO CH\u00cdNH X\u00c1C 21\/11) U1 c\u01b0 x\u00e1 v\u0129nh h\u1ed9i, p8, q4, hcm","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0773917400","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":73288,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":8,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/doctor.png","link_profile":"https:\/\/gitiho.com\/u\/110050-nguyen-trong-hao","business_employers":[],"vip_account":null,"roles":[]}

Nguyễn Trọng Hào 13 Jul 2022

dạ nó lỗi thầy ơi!!!e kéo nó ra là báo lỗi

 

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2022-12-02T07:50:10.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":654006,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1811,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":41.46,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"ContentManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 13 Jul 2022

Bạn thử download file ở bài 39 về rồi kiểm tra trên máy bạn xem

Nguyễn Trọng Hào

Nguyễn Trọng Hào 11 Jul 2022

 

dính lỗi này khi tạo thầy ơi!

Nguyễn Trọng Hào

Nguyễn Trọng Hào 13 Jul 2022

không ai hỗ trợ mình vậy ạ

 

{"id":110050,"crm_contact_id":135819,"name":"Nguy\u1ec5n Tr\u1ecdng H\u00e0o","email":"haont@binhminhcorp.com.vn","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2020-11-21 10:03:38","confirmation_code":"cc230ca1a06bb8c0b38c83920d155759","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2020-11-20T07:57:39.000000Z","updated_at":"2022-07-11T02:01:14.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"Nguy\u1ec5n Tr\u1ecdng H\u00e0o","address":"(GIAO CH\u00cdNH X\u00c1C 21\/11) U1 c\u01b0 x\u00e1 v\u0129nh h\u1ed9i, p8, q4, hcm","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0773917400","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":73288,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":8,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/doctor.png","link_profile":"https:\/\/gitiho.com\/u\/110050-nguyen-trong-hao","business_employers":[],"vip_account":null,"roles":[]}

Nguyễn Trọng Hào 13 Jul 2022

mình kéo spbutton thì lỗi như trên

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2022-12-02T07:50:10.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":654006,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1811,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":41.46,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"ContentManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 13 Jul 2022

Bạn đang sử dụng phiên bản office nào nhỉ? 

Có thể bị lỗi buton đó trong bộ office

{"id":110050,"crm_contact_id":135819,"name":"Nguy\u1ec5n Tr\u1ecdng H\u00e0o","email":"haont@binhminhcorp.com.vn","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2020-11-21 10:03:38","confirmation_code":"cc230ca1a06bb8c0b38c83920d155759","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2020-11-20T07:57:39.000000Z","updated_at":"2022-07-11T02:01:14.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"Nguy\u1ec5n Tr\u1ecdng H\u00e0o","address":"(GIAO CH\u00cdNH X\u00c1C 21\/11) U1 c\u01b0 x\u00e1 v\u0129nh h\u1ed9i, p8, q4, hcm","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0773917400","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":73288,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":8,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/doctor.png","link_profile":"https:\/\/gitiho.com\/u\/110050-nguyen-trong-hao","business_employers":[],"vip_account":null,"roles":[]}

Nguyễn Trọng Hào 13 Jul 2022

vậy giờ e phải làm sao để tạo đc cái button đó ạ!

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2022-12-02T07:50:10.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":654006,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1811,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":41.46,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"ContentManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 13 Jul 2022

Bạn thử trên máy khác xem hoặc dowload ở bài 39 chạy code xem bị lỗi lkhoong nhé.

Nguyễn Trọng Hào

Nguyễn Trọng Hào 11 Jul 2022

Xin file kết quả đầu ra thầy Ba ơi

 

Tuấn Ba

Tuấn Ba [Chuyên gia] 13 Jul 2022

Chào bạn phần này chỉ có ribbon kết quả thôi bạn nhé. Còn cả file thì phải thực hành ở khoá xong bạn nhé.

Ngô Huy Cường

Ngô Huy Cường 05 Jun 2022

Giảng viên ơi , tại sao mình phải vào trang docs.microsoft......này để copy những nội dung theo video hướng dẫn . và mình tìm trong foler tài liệu khóa học cũng không thấy địa chỉ web này được liệt kê ( không nhẽ mình phải ngồi nhìn màn hình và đánh lại địa chỉ link đó để có thể làm theo hướng dẫn của video ) . Vấn đề cốt yếu mình muốn hỏi là sao mình học theo kiểu thấy video làm theo thế nào thì làm theo thế ấy thì sao gọi là việc học có thể tiếp thu kiến thức ạ . trong đoạn mã ở Office RibbonX Editor là có nguyên lý , thì theo cách nghĩ của mình là khi học cách làm sẽ được giới thiệu , giải thích nguyên lý , sự vận hành của đoạn mã đó trong công tác tạo riboons đúng không ạ.......

Tuấn Ba

Tuấn Ba [Chuyên gia] 06 Jun 2022

Chào bạn bạn vào lại giúp gitiho nhé các link của office ribbon x vẫn bình thường bạn nhé.

Ngô Huy Cường

Ngô Huy Cường 22 May 2022

Cho mình hỏi Giảng Viên là đường link để tài phần mềm Office Ribbonx Editor thì có thể tìm thấy ở đâu ạ......

Mong phản hồi của Giảng Viên . 

Tuấn Ba

Tuấn Ba [Chuyên gia] 23 May 2022

Chào bạn bạn download tại đây nhé

https://github.com/fernandreu/office-...

PHAN TUYẾT LINH

PHAN TUYẾT LINH 10 Feb 2022

Thầy cho e hỏi, nếu e muốn tạo 1 Button có sẵn của Excel tại Tab Review - Group Changes - Chỉ lấy button Protect Sheet thì e phải tạo CustomUI câu lệnh là gì ạ? Trong clip chỉ hướng dẫn lấy nguyên Group, nhưng e chỉ muốn lấy 1 button nào đó trong group đó thôi. (Vd: Group Changes - Tab Review thì câu lệnh là  <group idMso="GroupChangesExcel" /> ; vậy còn lấy 1 button trong đó viết sao thầy?)
Tuấn Ba

Tuấn Ba [Chuyên gia] 10 Feb 2022

Chào bạn phần này không được bạn nhé, excel chỉ hỗ tợ lấy các group thôi.

Nguyễn Ly

Nguyễn Ly 29 Nov 2021

Thầy ơi, mình không có file giống như: Kết quả đầu ra ạ?

Tuấn Ba

Tuấn Ba [Chuyên gia] 29 Nov 2021

Chào bạn kết quả của mình là ribbon đó bạn nhé

thevinhhv2509@gmail.com

thevinhhv2509@gmail.com 28 Sep 2021

Nhờ thầy gửi đường link tài liệu hướng dẫn về Ribon để học thêm ạ, vì trong file đính kèm không thấy. cảm ơn thầy !

Tuấn Ba

Tuấn Ba [Chuyên gia] 29 Sep 2021

Chào bạn toàn bộ tài liệu đều nằm ở đầu chương bạn tải về và kết hợp với video là làm được nhé.

{"id":158,"crm_contact_id":739,"name":"thevinhhv2509@gmail.com","email":"thevinhhv2509@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2018-05-11 14:26:44","confirmation_code":"9ebedb73e2e24cdffec2d930bf345431","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2017-05-10T05:01:57.000000Z","updated_at":"2022-12-02T13:28:41.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":null,"address":null,"status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"nh\u00e0 s\u1ed1 28, \u0110\u01b0\u1eddng 411, t\u1ed5 6, \u1ea5p 3 x\u00e3 Ph\u01b0\u1edbc V\u0129nh A,, huy\u1ec7n C\u1ee7 Chi, TPHCM","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":402987,"google_id":"106505575452936722187","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/graphic-designer.png","link_profile":"https:\/\/gitiho.com\/u\/158-thevinhhv2509-at-gmailcom","business_employers":[],"vip_account":null,"roles":[]}

thevinhhv2509@gmail.com 29 Sep 2021

Trong video thầy nói có gửi kèm đường link trang của microsoft hướng dẫn để đọc thêm về ribon, còn tài liệu đàu chướng mình đã tải nhưng không có link ạ.

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2022-12-02T07:50:10.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":654006,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1811,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":41.46,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"ContentManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 29 Sep 2021

Chào bạn bạn đọc tại đây nhé

trong office ribonx editer có mà bạn

Nguyễn Văn Bình

Nguyễn Văn Bình 08 Aug 2021

Chất lượng video này mờ quá Gitiho,

Tuấn Ba

Tuấn Ba [Chuyên gia] 08 Aug 2021

Cảm ơn bạn đã đưa ra ý kiến, gitiho sẽ báo bộ phận IT để kiểm tra

Trần Trường Hạnh

Trần Trường Hạnh 13 Jul 2021

ko thấy tài liệu kèm theo để tải Ribbons Visual Designer ah?

Trần Trường Hạnh

Trần Trường Hạnh 13 Jul 2021

chào Tuấn Ba,

Mình download về và giản nén ko ra các file như bài học, xin hổ trợ


{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2022-12-02T07:50:10.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":654006,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1811,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":41.46,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"ContentManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 13 Jul 2021

Chào bạn phần  Ribbons Visual Designer gitiho chỉ giới thiệu còn chủ yếu tạo ribon mình dùng office RibbonX Editor nhé,

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2022-12-02T07:50:10.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":654006,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1811,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":41.46,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"ContentManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 13 Jul 2021

Ribbons Visual Designer là addins bạn cài vào là sử dụng được nhé.
{"id":118876,"crm_contact_id":153753,"name":"Tr\u1ea7n Tr\u01b0\u1eddng H\u1ea1nh","email":"hanhpmpc@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2021-01-13 07:09:34","confirmation_code":"290b223847be150df8fa192a8fe382eb","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-01-12T01:52:36.000000Z","updated_at":"2022-11-27T16:12:29.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"Tr\u1ea7n Tr\u01b0\u1eddng H\u1ea1nh","address":"(nh\u1eadn 12\/1) Hotel Nikko Saigon\u00a0235 \u0110. Nguy\u1ec5n V\u0103n C\u1eeb, Ph\u01b0\u1eddng Nguy\u1ec5n C\u01b0 Trinh, Qu\u1eadn 1, Th\u00e0nh ph\u1ed1 H\u1ed3 Ch\u00ed Minh","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0908878687","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":99343,"google_id":"104400389484182161677","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":4,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/man.png","link_profile":"https:\/\/gitiho.com\/u\/118876-tran-truong-hanh","business_employers":[],"vip_account":null,"roles":[]}

Trần Trường Hạnh 15 Jul 2021

chuyên gia có thể kèm file "Visul Designer" theo bài học đính kèm để add in vào dc ko ah?

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2022-12-02T07:50:10.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":654006,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1811,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":41.46,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"ContentManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 15 Jul 2021

Chào bạn gitiho sẽ đẩy phần này lên bạn quay lại tầm 1h nữa nhé hoặc bạn có thể vào đây để download nhé

https://andypope.info/vba/ribbonedito...

Trần Trường Hạnh

Trần Trường Hạnh 13 Jul 2021

link này ko có âm thanh nha add, vui lòng hổ trợ

Tuấn Ba

Tuấn Ba [Chuyên gia] 13 Jul 2021

Chào bạn phần đâu giới thiệu không có âm thanh bạn nhé, bạn xem video khác sẽ có âm thanh nhé.

Huỳnh Cao Cường

Huỳnh Cao Cường 25 Feb 2021

Mình đã tạo xong cái tool chạy trên Office 365 máy nào cũng ok sao chạy trên máy Office 2013 nó báo lỗi này: system error &h80004005 (-214767259) là sao vậy thầy

Tuấn Ba

Tuấn Ba [Chuyên gia] 26 Feb 2021

Chắc phải xem code ạ

{"id":118319,"crm_contact_id":153260,"name":"Hu\u1ef3nh Cao C\u01b0\u1eddng","email":"alahaba1003@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2021-01-09 15:20:39","confirmation_code":"d746f3e55a124a3dd8f0a7606b2b7be3","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-01-08T06:50:58.000000Z","updated_at":"2022-06-20T02:47:05.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":"1982-06-18 00:00:00","position":null,"achievement":null,"full_name":"Hu\u1ef3nh Cao C\u01b0\u1eddng","address":"343D Lac Long Quan, P5, Q11 TpHCM","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0812744229","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"100835823991142364638","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/pastor.png","link_profile":"https:\/\/gitiho.com\/u\/118319-huynh-cao-cuong","business_employers":[],"vip_account":null,"roles":[]}

Huỳnh Cao Cường 27 Feb 2021

          Trong cai chuong trinh tao ribbon mình gõ cái code này  <tab id="Tab_free" label="Tính năng free" insertBeforeMso="TabHome" getVisible="chuong_trinh_kiem_tra">

còn trong vba mình gõ cai hàm chuong_trinh_kiem_tra là:

Sub GetVisible(control As IRibbonControl, ByRef returnedVal)

        Select Case control.ID

            Case "Tab_cong_cu":    returnedVal = False

            Case "Toan_6":    returnedVal = False

            Case "Toan_7":    returnedVal = False

            Case "Toan_8":    returnedVal = False

            Case "Toan_9":    returnedVal = False

        End Select

End Sub

De minh khoa cac Tab lại ạ

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2022-12-02T07:50:10.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":654006,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1811,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":41.46,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"ContentManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 01 Mar 2021

Chào bạn bạn có thể đẩy file lên được không?

Huỳnh Cao Cường

Huỳnh Cao Cường 24 Feb 2021

Thầy ơi có hàm nào bên VBA để mình khóa ribbon đã làm ko thầy

Tuấn Ba

Tuấn Ba [Chuyên gia] 25 Feb 2021

Chào bạn bạn có cần điều kiện để khoá không? còn bạn không để chức năng trong đó thì sẽ không cần khoá, hay nói cách đơn giản là bạn không bắt sự kiện on... thì ribon sẽ bị khoá chức năng đó.

{"id":118319,"crm_contact_id":153260,"name":"Hu\u1ef3nh Cao C\u01b0\u1eddng","email":"alahaba1003@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2021-01-09 15:20:39","confirmation_code":"d746f3e55a124a3dd8f0a7606b2b7be3","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-01-08T06:50:58.000000Z","updated_at":"2022-06-20T02:47:05.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":"1982-06-18 00:00:00","position":null,"achievement":null,"full_name":"Hu\u1ef3nh Cao C\u01b0\u1eddng","address":"343D Lac Long Quan, P5, Q11 TpHCM","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0812744229","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"100835823991142364638","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/pastor.png","link_profile":"https:\/\/gitiho.com\/u\/118319-huynh-cao-cuong","business_employers":[],"vip_account":null,"roles":[]}

Huỳnh Cao Cường 25 Feb 2021

Mình có điều kiện ví dụ cho dòng lệnh inputbox để nhập vào 1 câu nếu câu đó ko đúng mình quy định thì khóa ribbon.Thầy cho mình xin câu lệnh cụ thể được không vậy.

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2022-12-02T07:50:10.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":654006,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1811,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":41.46,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"ContentManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 25 Feb 2021

chào bạn bạn phải gắn ra 1 sheets rồi if điều kiện đó nếu đúng thì dẫn nút bấm hay sự kiện cho ribon không thì có thể chuyển nút sang trạng thái không có gì.

{"id":118319,"crm_contact_id":153260,"name":"Hu\u1ef3nh Cao C\u01b0\u1eddng","email":"alahaba1003@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2021-01-09 15:20:39","confirmation_code":"d746f3e55a124a3dd8f0a7606b2b7be3","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-01-08T06:50:58.000000Z","updated_at":"2022-06-20T02:47:05.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":"1982-06-18 00:00:00","position":null,"achievement":null,"full_name":"Hu\u1ef3nh Cao C\u01b0\u1eddng","address":"343D Lac Long Quan, P5, Q11 TpHCM","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0812744229","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"100835823991142364638","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/pastor.png","link_profile":"https:\/\/gitiho.com\/u\/118319-huynh-cao-cuong","business_employers":[],"vip_account":null,"roles":[]}

Huỳnh Cao Cường 25 Feb 2021

Mình muốn xin ví dụ 1 đoạn code để 1 ribbon ví dụ tên là ribbon1 chuyển sang trạng thái không có gì đó thầy.

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2022-12-02T07:50:10.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":654006,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1811,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":41.46,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"ContentManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 25 Feb 2021

Chào bạn đây là một dạng bạn nhé:

Sub FCC(control As IRibbonControl)
    If TH.Range("D1").Value = "X" Then
        MsgBoxUni CHUYENMA("Vui lofng ddawng nhaajp vowsi quyeenf nhaajp vaf moji quyefn")
    ElseIf TH.Range("D1").Value = "N" Then
         BCC.Activate
    Else
         BCC.Activate
    End If
     anview Range("a4:z4")
    Application.StatusBar = CHUYENMA("Bajn ddang lafm vieejc owr barng chaasm coong")
End Sub
{"id":118319,"crm_contact_id":153260,"name":"Hu\u1ef3nh Cao C\u01b0\u1eddng","email":"alahaba1003@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2021-01-09 15:20:39","confirmation_code":"d746f3e55a124a3dd8f0a7606b2b7be3","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-01-08T06:50:58.000000Z","updated_at":"2022-06-20T02:47:05.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":"1982-06-18 00:00:00","position":null,"achievement":null,"full_name":"Hu\u1ef3nh Cao C\u01b0\u1eddng","address":"343D Lac Long Quan, P5, Q11 TpHCM","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0812744229","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"100835823991142364638","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/pastor.png","link_profile":"https:\/\/gitiho.com\/u\/118319-huynh-cao-cuong","business_employers":[],"vip_account":null,"roles":[]}

Huỳnh Cao Cường 25 Feb 2021

sao cả 2 deu activate vậy thầy

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2022-12-02T07:50:10.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":654006,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1811,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":41.46,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"ContentManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 25 Feb 2021

chào bạn với D1 = "X" mình đưa ra thoong báo, còn các quyền khác mình vẫn cho vào.

{"id":118319,"crm_contact_id":153260,"name":"Hu\u1ef3nh Cao C\u01b0\u1eddng","email":"alahaba1003@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2021-01-09 15:20:39","confirmation_code":"d746f3e55a124a3dd8f0a7606b2b7be3","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-01-08T06:50:58.000000Z","updated_at":"2022-06-20T02:47:05.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":"1982-06-18 00:00:00","position":null,"achievement":null,"full_name":"Hu\u1ef3nh Cao C\u01b0\u1eddng","address":"343D Lac Long Quan, P5, Q11 TpHCM","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0812744229","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"100835823991142364638","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/pastor.png","link_profile":"https:\/\/gitiho.com\/u\/118319-huynh-cao-cuong","business_employers":[],"vip_account":null,"roles":[]}

Huỳnh Cao Cường 25 Feb 2021

BCC la ten ribbon hay ten id cua ribbon hay ten tag cua ribbon vay thay

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2022-12-02T07:50:10.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":654006,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1811,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":41.46,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"ContentManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 25 Feb 2021

BCC là tên một sheets bạn

{"id":118319,"crm_contact_id":153260,"name":"Hu\u1ef3nh Cao C\u01b0\u1eddng","email":"alahaba1003@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2021-01-09 15:20:39","confirmation_code":"d746f3e55a124a3dd8f0a7606b2b7be3","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-01-08T06:50:58.000000Z","updated_at":"2022-06-20T02:47:05.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":"1982-06-18 00:00:00","position":null,"achievement":null,"full_name":"Hu\u1ef3nh Cao C\u01b0\u1eddng","address":"343D Lac Long Quan, P5, Q11 TpHCM","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0812744229","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"100835823991142364638","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/pastor.png","link_profile":"https:\/\/gitiho.com\/u\/118319-huynh-cao-cuong","business_employers":[],"vip_account":null,"roles":[]}

Huỳnh Cao Cường 25 Feb 2021

Ví dụ mình có 1 ribbon id là ribbon1 tag là ribbon_tag. Nếu Ô A1.value = "F" thì actice ribbon1 còn không thì ẩn ribbon1 mình dùng code như thế nào vậy thầy

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2022-12-02T07:50:10.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":654006,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1811,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":41.46,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"ContentManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 25 Feb 2021

Chào bạn chỉ có thể để ribon đó và khong làm gì thôi bạn nhé.

{"id":118319,"crm_contact_id":153260,"name":"Hu\u1ef3nh Cao C\u01b0\u1eddng","email":"alahaba1003@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2021-01-09 15:20:39","confirmation_code":"d746f3e55a124a3dd8f0a7606b2b7be3","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-01-08T06:50:58.000000Z","updated_at":"2022-06-20T02:47:05.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":"1982-06-18 00:00:00","position":null,"achievement":null,"full_name":"Hu\u1ef3nh Cao C\u01b0\u1eddng","address":"343D Lac Long Quan, P5, Q11 TpHCM","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0812744229","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"100835823991142364638","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/pastor.png","link_profile":"https:\/\/gitiho.com\/u\/118319-huynh-cao-cuong","business_employers":[],"vip_account":null,"roles":[]}

Huỳnh Cao Cường 25 Feb 2021

sao khi mình gán địa chỉ là ổ C thì nó báo lỗi còn ổ D thì nó tạo binh thuong vay thay, co cach nao gán vô ổ C duoc ko thây

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2022-12-02T07:50:10.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":654006,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1811,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":41.46,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"ContentManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 25 Feb 2021

Chào bạn bạn thử check file trước nhé xem có file trong ổ c không?

Option Explicit
Sub CheckFileExists()
Dim strFileName As String
Dim strFileExists As String
    strFileName = "C:\text"
    strFileExists = Dir(strFileName)
   If strFileExists = "" Then
        MsgBox "The selected file doesn't exist"
    Else
        MsgBox "The selected file exists"
    End If
End Sub

{"id":118319,"crm_contact_id":153260,"name":"Hu\u1ef3nh Cao C\u01b0\u1eddng","email":"alahaba1003@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2021-01-09 15:20:39","confirmation_code":"d746f3e55a124a3dd8f0a7606b2b7be3","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-01-08T06:50:58.000000Z","updated_at":"2022-06-20T02:47:05.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":"1982-06-18 00:00:00","position":null,"achievement":null,"full_name":"Hu\u1ef3nh Cao C\u01b0\u1eddng","address":"343D Lac Long Quan, P5, Q11 TpHCM","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0812744229","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"100835823991142364638","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/pastor.png","link_profile":"https:\/\/gitiho.com\/u\/118319-huynh-cao-cuong","business_employers":[],"vip_account":null,"roles":[]}

Huỳnh Cao Cường 25 Feb 2021

chương trình này nó tạo file mới mà thầy

mà mình xin đoạn code đọc dữ liệu file txt để dán vô ô A1 luôn duoc không thầy

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2022-12-02T07:50:10.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":654006,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1811,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":41.46,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"ContentManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 25 Feb 2021

Public Const UTF_8_ENCODING = "UTF-8"
Sub readFileExample1()
    Dim fileName As String
    Dim content As String
    fileName = "C:\TuanBa\NewTextDocument.txt"
    content = readFile(fileName, UTF_8_ENCODING)
    Cells(1, "A").Value = content
End Sub
Function readFile(fileName As String, charSet As String) As String
    Dim objStream As Object
    Set objStream = CreateObject("ADODB.Stream")
     
    objStream.charSet = charSet
    objStream.Open
     
    objStream.LoadFromFile (fileName)
    readFile = objStream.ReadText()
     
    Set objStream = Nothing
End Function

{"id":118319,"crm_contact_id":153260,"name":"Hu\u1ef3nh Cao C\u01b0\u1eddng","email":"alahaba1003@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2021-01-09 15:20:39","confirmation_code":"d746f3e55a124a3dd8f0a7606b2b7be3","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-01-08T06:50:58.000000Z","updated_at":"2022-06-20T02:47:05.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":"1982-06-18 00:00:00","position":null,"achievement":null,"full_name":"Hu\u1ef3nh Cao C\u01b0\u1eddng","address":"343D Lac Long Quan, P5, Q11 TpHCM","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0812744229","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"100835823991142364638","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/pastor.png","link_profile":"https:\/\/gitiho.com\/u\/118319-huynh-cao-cuong","business_employers":[],"vip_account":null,"roles":[]}

Huỳnh Cao Cường 25 Feb 2021

Cam on thầy

{"id":74845,"crm_contact_id":53166,"name":"Tu\u1ea5n Ba","email":"laptrinhcchoexcel@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"b4a1dffcd4f5224a3e4df7e7ee0541d5","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2019-10-02T02:09:45.000000Z","updated_at":"2022-12-02T07:50:10.000000Z","deleted_at":null,"unit_name":"Gitiho","grade":0,"avatar_disk":"public","avatar_path":"users\/1637917341.jpg","gender":0,"birthday":"1992-03-19 00:00:00","position":"Ph\u00e1t tri\u1ec3n \u1ee9ng d\u1ee5ng C# cho Excel","achievement":"<p><br><\/p>","full_name":"L\u01b0\u01a1ng Tu\u00e2\u0301n Ba","address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","status_text":"<p>L\u00e0 T\u00e1c gi\u1ea3 c\u1ee7a Add- Ins Gitiho tools cho ph\u00e9p truy v\u1ea5n d\u1eef li\u1ec7u trong Excel v\u00e0 Access v\u00e0 tr\u1ea3 ra m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ed9ng.<\/p>","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":null,"become_teacher":1,"primary_wallet":654006,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":null,"github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":1811,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_number":"2022-03-19","contract_date":"2022-03-18T17:00:00.000000Z","contract_delegate":"L\u01b0\u01a1ng Tu\u1ea5n Ba","contract_address":"120 y\u00ean b\u00ecnh ph\u00fac, Ph\u00fac La, H\u00e0 \u0110\u00f4ng, H\u00e0 N\u1ed9i","contract_account_number":"19034644336010","contract_bank":"Techcombank","source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1637917341.jpg","link_profile":"https:\/\/gitiho.com\/teacher\/74845-tuan-ba","business_employers":[{"id":12,"biz_business_id":1,"statusHtml":"<span class=\"text-secondary font-weight-normal\"> Ng\u1eebng ho\u1ea1t \u0111\u1ed9ng <\/span>","avgCompleted":41.46,"bizUser":""}],"vip_account":null,"roles":[{"id":8,"name":"Teacher","display_name":"Teacher","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":8,"model_type":"App\\Models\\User"}},{"id":13,"name":"ContentManager","display_name":"ContentManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":13,"model_type":"App\\Models\\User"}},{"id":19,"name":"GitihoHumanResources","display_name":"GitihoHumanResources","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","pivot":{"model_id":74845,"role_id":19,"model_type":"App\\Models\\User"}}]}

Tuấn Ba [Chuyên gia] 26 Feb 2021

Cảm ơn bạn, chúc bạn học tốt

{"id":118319,"crm_contact_id":153260,"name":"Hu\u1ef3nh Cao C\u01b0\u1eddng","email":"alahaba1003@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2021-01-09 15:20:39","confirmation_code":"d746f3e55a124a3dd8f0a7606b2b7be3","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2021-01-08T06:50:58.000000Z","updated_at":"2022-06-20T02:47:05.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"","avatar_path":"","gender":0,"birthday":"1982-06-18 00:00:00","position":null,"achievement":null,"full_name":"Hu\u1ef3nh Cao C\u01b0\u1eddng","address":"343D Lac Long Quan, P5, Q11 TpHCM","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0812744229","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":0,"google_id":"100835823991142364638","github_id":null,"twitter_id":null,"linkedin_id":null,"bitbucket_id":null,"access_token_onedrive":"","system_status":"done","account_seeding":0,"path_cv":null,"enable_unsubcribe":0,"clap":0,"view":0,"email_unsubcriber":0,"email_bounce":0,"email_compliant":0,"contract_business_name":null,"contract_number":null,"contract_date":null,"contract_delegate":null,"contract_address":null,"contract_account_number":null,"contract_bank":null,"source":null,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/default\/gitiho\/avatar_random\/men\/pastor.png","link_profile":"https:\/\/gitiho.com\/u\/118319-huynh-cao-cuong","business_employers":[],"vip_account":null,"roles":[]}

Huỳnh Cao Cường 27 Feb 2021

mình muốn làm tính năng đó là nếu ô A1 = T thì ẩn Tab id ="Toan_9" thì mình làm như thế nào vậy thầy

Khoá học cùng chủ đề

EXG06 - Xây dựng add-in, thẻ lệnh quản lý công việc trên Excel
5

(1 đánh giá)

178 học viên
399,000đ
@ 2020 - Bản quyền của Công ty cổ phần công nghệ giáo dục Gitiho Việt Nam
Giấy chứng nhận Đăng ký doanh nghiệp số: 0109077145, cấp bởi Sở kế hoạch và đầu tư TP. Hà Nội
/