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

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

1 sách ebook về thư viện code mẫu VBA được biên soạn bởi Gitiho

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

Video

0h 00m giờ học

Article

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

Material

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

Exam questions

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

Nội dung khoá học

0 Chương . 2 bài giảng . 0h 00m giờ học

Mở rộng tất cả các phần

Mô tả khoá học

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

1/5

1 Đánh giá và nhận xét

  • 0%

  • 0%

  • 0%

  • 0%

  • 100%

Tran Thi Ngoc Han

Tran Thi Ngoc Han

code co ban, khong the ap dung vao cong viec ngay nhu gioi thieu.. Thieu hinh anh truc quan, neu la nguoi moi hoc, chua biet gi ve vba se kho hieu, kho hinh dung dan den viec kho ap dung ngay neu can.

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.3 điểm đánh giá

  • 758 đánh giá

  • 290,053 học viên

  • 99 khóa học

Học viên cũng mua

VBAG03 (Nâng cao) - Code mẫu và các chuyên đề ứng dụng VBA
43 bài giảng
5
165
499,000 đ
899,000 đ
VBAG03 (Nâng cao) - Code mẫu và các chuyên đề ứng dụng VBA
THVP02 - Sử dụng máy tính hiệu quả cho dân Văn phòng
73 bài giảng
0
83
399,000 đ
499,000 đ
THVP02 - Sử dụng máy tính hiệu quả cho dân Văn phòng
Làm chủ công cụ Microsoft Access từ A-Z
55 bài giảng
0
70
499,000 đ
799,000 đ
Làm chủ công cụ Microsoft Access từ A-Z
VBAG04 - Ứng dụng VBA trong công việc quản lý kho cửa hàng
151 bài giảng
0
51
499,000 đ
499,000 đ
VBAG04 - Ứng dụng VBA trong công việc quản lý kho cửa hàng
MOS Excel 2016
64 bài giảng
0
35
499,000 đ
699,000 đ
MOS Excel 2016
Quản trị cơ sở dữ liệu với Microsoft SQL Server
26 bài giảng
2
13
499,000 đ
799,000 đ
Quản trị cơ sở dữ liệu với Microsoft SQL Server
Chinh phục kỳ thi công chức, viên chức, thăng hạng - nâng ngạch môn Tin học
51 bài giảng
0
10
499,000 đ
799,000 đ
Chinh phục kỳ thi công chức, viên chức, thăng hạng - nâng ngạch môn Tin học
Kỹ năng sử dụng Trình duyệt Web hiệu quả cho công việc
6 bài giảng
0
7
99,000 đ
199,000 đ
Kỹ năng sử dụng Trình duyệt Web hiệu quả cho công việc
Kiến thức cơ bản về MacOS
9 bài giảng
0
5
299,000 đ
499,000 đ
Kiến thức cơ bản về MacOS
Sử dụng Windows 10 thành thạo cho công việc trong 2h
35 bài giảng
0
5
199,000 đ
299,000 đ
Sử dụng Windows 10 thành thạo cho công việc trong 2h

Hỏi đáp khóa học

0 thảo luận

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

25 thảo luận

Phung Minh Tuan

Phung Minh Tuan 15 Aug 2023

CHào anh/chị,

Mình chạy code mẫu Sub Insert_Picture_Autofit() nhưng bị lỗi như hình. Vui lòng hướng dẫn mình cách sửa lỗi này?

Cám ơn anh/chị,

 

CSKH Gitiho Việt Nam

CSKH Gitiho Việt Nam 25 Aug 2023

Dạ bạn thử sửa .ShapeRange.LockAspectRatio = msoFalseLeft => .ShapeRange.LockAspectRatio = msoFalse thôi xem sao ạ 

{"id":343891,"crm_contact_id":600266,"name":"L\u00ea Minh Thu\u1ef3 Ph\u01b0\u1ee3ng","email":"leephuong1402@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"2d735fdce1f4f7e7f12f3816e3a4b7f6","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-07-15T07:32:51.000000Z","updated_at":"2023-08-14T06:27:06.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":"0933906468","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":20437,"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":1,"email_invalid":0,"type_email_invalid":null,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_344\/le-phuong.png","link_profile":"https:\/\/gitiho.com\/u\/343891-le-minh-thuy-phuong","business_employers":[],"vip_account":null,"roles":[]}

Lê Minh Thuỳ Phượng 29 Aug 2023

Báo lỗi như zậy là sao ạ. Anh chị giúp em ạ. Em cám ơn

{"id":82548,"crm_contact_id":29934,"name":"CSKH Gitiho Vi\u1ec7t Nam","email":"hotro@gitiho.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2020-02-12 17:12:54","confirmation_code":"ccae872502b90d64fa68a5773858a513","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2020-01-30T15:32:47.000000Z","updated_at":"2023-09-18T12:57:58.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"public","avatar_path":"users\/1652762083.png","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"CSKH Gitiho Vi\u1ec7t Nam","address":"Gitiho Vi\u1ec7t Nam","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0774116285","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":8000,"google_id":"109213028097135238411","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":32,"email_invalid":0,"type_email_invalid":null,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1652762083.png","link_profile":"https:\/\/gitiho.com\/u\/82548-cskh-gitiho-viet-nam","business_employers":[{"id":2713,"biz_business_id":79,"statusHtml":"<span class=\"badge badge-secondary\"> Deactivated <\/span>","bizUser":"","had_subscription":0},{"id":2715,"biz_business_id":12,"statusHtml":"<span class=\"badge badge-secondary\"> Deactivated <\/span>","bizUser":"","had_subscription":0},{"id":2716,"biz_business_id":61,"statusHtml":"<span class=\"badge badge-secondary\"> Deactivated <\/span>","bizUser":"","had_subscription":0}],"vip_account":null,"roles":[{"id":10,"biz_business_id":0,"name":"CourseManager","display_name":"CourseManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":10,"model_type":"App\\Models\\User"}},{"id":11,"biz_business_id":0,"name":"Sale","display_name":"Sale","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":11,"model_type":"App\\Models\\User"}},{"id":12,"biz_business_id":0,"name":"SaleManager","display_name":"SaleManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":12,"model_type":"App\\Models\\User"}},{"id":14,"biz_business_id":0,"name":"UserManager","display_name":"UserManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":14,"model_type":"App\\Models\\User"}},{"id":17,"biz_business_id":0,"name":"partnerAffiliate","display_name":"partnerAffiliate","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":17,"model_type":"App\\Models\\User"}},{"id":26,"biz_business_id":0,"name":"Tr\u1ee3 gi\u1ea3ng","display_name":"Tr\u1ee3 gi\u1ea3ng","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":26,"model_type":"App\\Models\\User"}},{"id":27,"biz_business_id":0,"name":"Customer service","display_name":"Customer service","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":27,"model_type":"App\\Models\\User"}}]}

CSKH Gitiho Việt Nam 29 Aug 2023

Dạ chỗ đó anh/chị không để xuống dòng thử xem sao ạ 

{"id":343891,"crm_contact_id":600266,"name":"L\u00ea Minh Thu\u1ef3 Ph\u01b0\u1ee3ng","email":"leephuong1402@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"2d735fdce1f4f7e7f12f3816e3a4b7f6","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-07-15T07:32:51.000000Z","updated_at":"2023-08-14T06:27:06.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":"0933906468","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":20437,"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":1,"email_invalid":0,"type_email_invalid":null,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_344\/le-phuong.png","link_profile":"https:\/\/gitiho.com\/u\/343891-le-minh-thuy-phuong","business_employers":[],"vip_account":null,"roles":[]}

Lê Minh Thuỳ Phượng 30 Aug 2023

vẫn không được ạ

 

{"id":82548,"crm_contact_id":29934,"name":"CSKH Gitiho Vi\u1ec7t Nam","email":"hotro@gitiho.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2020-02-12 17:12:54","confirmation_code":"ccae872502b90d64fa68a5773858a513","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2020-01-30T15:32:47.000000Z","updated_at":"2023-09-18T12:57:58.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"public","avatar_path":"users\/1652762083.png","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"CSKH Gitiho Vi\u1ec7t Nam","address":"Gitiho Vi\u1ec7t Nam","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0774116285","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":8000,"google_id":"109213028097135238411","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":32,"email_invalid":0,"type_email_invalid":null,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1652762083.png","link_profile":"https:\/\/gitiho.com\/u\/82548-cskh-gitiho-viet-nam","business_employers":[{"id":2713,"biz_business_id":79,"statusHtml":"<span class=\"badge badge-secondary\"> Deactivated <\/span>","bizUser":"","had_subscription":0},{"id":2715,"biz_business_id":12,"statusHtml":"<span class=\"badge badge-secondary\"> Deactivated <\/span>","bizUser":"","had_subscription":0},{"id":2716,"biz_business_id":61,"statusHtml":"<span class=\"badge badge-secondary\"> Deactivated <\/span>","bizUser":"","had_subscription":0}],"vip_account":null,"roles":[{"id":10,"biz_business_id":0,"name":"CourseManager","display_name":"CourseManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":10,"model_type":"App\\Models\\User"}},{"id":11,"biz_business_id":0,"name":"Sale","display_name":"Sale","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":11,"model_type":"App\\Models\\User"}},{"id":12,"biz_business_id":0,"name":"SaleManager","display_name":"SaleManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":12,"model_type":"App\\Models\\User"}},{"id":14,"biz_business_id":0,"name":"UserManager","display_name":"UserManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":14,"model_type":"App\\Models\\User"}},{"id":17,"biz_business_id":0,"name":"partnerAffiliate","display_name":"partnerAffiliate","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":17,"model_type":"App\\Models\\User"}},{"id":26,"biz_business_id":0,"name":"Tr\u1ee3 gi\u1ea3ng","display_name":"Tr\u1ee3 gi\u1ea3ng","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":26,"model_type":"App\\Models\\User"}},{"id":27,"biz_business_id":0,"name":"Customer service","display_name":"Customer service","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":27,"model_type":"App\\Models\\User"}}]}

CSKH Gitiho Việt Nam 30 Aug 2023

Dạ hiện đang báo lỗi như thế nào ạ?

Phung Minh Tuan

Phung Minh Tuan 12 Aug 2023

Chào anh/chị,

Vui lòng xem giúp minh hình ảnh đính kèm, khi mình chạy macro Delete_All_Shapes() thi bị lỗi.

Vui lòng hướng dẫn cách khắc phục.

Xin cảm ơn.

 

CSKH Gitiho Việt Nam

CSKH Gitiho Việt Nam 15 Aug 2023

Chào anh/chị,

Câu lệnh Dim shp as Shape bị sai
Dim shp as Object nó là 1 object chứ ko khai báo cụ thể là shape ngay được
lúc vào vòng lặp for each thì object đó mới được hiểu là Shape

{"id":336253,"crm_contact_id":586609,"name":"Phung Minh Tuan","email":"tuan.phmt@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"311c1d9540c0b0891a17d2bac2bd98b7","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-06-18T11:22:40.000000Z","updated_at":"2023-08-09T07:55:00.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":"0988434887","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":25097,"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_invalid":0,"type_email_invalid":null,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_336\/phung-tuan.png","link_profile":"https:\/\/gitiho.com\/u\/336253-phung-minh-tuan","business_employers":[],"vip_account":null,"roles":[]}

Phung Minh Tuan 15 Aug 2023

Chào anh/chị,

 

Mình đã khai báo lại thành Object. Nhưng vẫn báo  lỗi.

Vui lòng xem lại giúp minh nhé?

{"id":336253,"crm_contact_id":586609,"name":"Phung Minh Tuan","email":"tuan.phmt@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"311c1d9540c0b0891a17d2bac2bd98b7","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-06-18T11:22:40.000000Z","updated_at":"2023-08-09T07:55:00.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":"0988434887","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":25097,"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_invalid":0,"type_email_invalid":null,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_336\/phung-tuan.png","link_profile":"https:\/\/gitiho.com\/u\/336253-phung-minh-tuan","business_employers":[],"vip_account":null,"roles":[]}

Phung Minh Tuan 15 Aug 2023

Minh gửi hinh minh hoa lỗi

{"id":82548,"crm_contact_id":29934,"name":"CSKH Gitiho Vi\u1ec7t Nam","email":"hotro@gitiho.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2020-02-12 17:12:54","confirmation_code":"ccae872502b90d64fa68a5773858a513","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2020-01-30T15:32:47.000000Z","updated_at":"2023-09-18T12:57:58.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"public","avatar_path":"users\/1652762083.png","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"CSKH Gitiho Vi\u1ec7t Nam","address":"Gitiho Vi\u1ec7t Nam","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0774116285","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":8000,"google_id":"109213028097135238411","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":32,"email_invalid":0,"type_email_invalid":null,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1652762083.png","link_profile":"https:\/\/gitiho.com\/u\/82548-cskh-gitiho-viet-nam","business_employers":[{"id":2713,"biz_business_id":79,"statusHtml":"<span class=\"badge badge-secondary\"> Deactivated <\/span>","bizUser":"","had_subscription":0},{"id":2715,"biz_business_id":12,"statusHtml":"<span class=\"badge badge-secondary\"> Deactivated <\/span>","bizUser":"","had_subscription":0},{"id":2716,"biz_business_id":61,"statusHtml":"<span class=\"badge badge-secondary\"> Deactivated <\/span>","bizUser":"","had_subscription":0}],"vip_account":null,"roles":[{"id":10,"biz_business_id":0,"name":"CourseManager","display_name":"CourseManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":10,"model_type":"App\\Models\\User"}},{"id":11,"biz_business_id":0,"name":"Sale","display_name":"Sale","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":11,"model_type":"App\\Models\\User"}},{"id":12,"biz_business_id":0,"name":"SaleManager","display_name":"SaleManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":12,"model_type":"App\\Models\\User"}},{"id":14,"biz_business_id":0,"name":"UserManager","display_name":"UserManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":14,"model_type":"App\\Models\\User"}},{"id":17,"biz_business_id":0,"name":"partnerAffiliate","display_name":"partnerAffiliate","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":17,"model_type":"App\\Models\\User"}},{"id":26,"biz_business_id":0,"name":"Tr\u1ee3 gi\u1ea3ng","display_name":"Tr\u1ee3 gi\u1ea3ng","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":26,"model_type":"App\\Models\\User"}},{"id":27,"biz_business_id":0,"name":"Customer service","display_name":"Customer service","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":27,"model_type":"App\\Models\\User"}}]}

CSKH Gitiho Việt Nam 15 Aug 2023

Chào anh/chị, 

Dòng này anh/chị thử sửa lại For Each shp In ActiveSheet.Shapes , thêm chữ S ở Shape xem sao 

{"id":336253,"crm_contact_id":586609,"name":"Phung Minh Tuan","email":"tuan.phmt@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"311c1d9540c0b0891a17d2bac2bd98b7","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-06-18T11:22:40.000000Z","updated_at":"2023-08-09T07:55:00.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":"0988434887","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":25097,"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_invalid":0,"type_email_invalid":null,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_336\/phung-tuan.png","link_profile":"https:\/\/gitiho.com\/u\/336253-phung-minh-tuan","business_employers":[],"vip_account":null,"roles":[]}

Phung Minh Tuan 15 Aug 2023

Chào anh/Chị, 

Cám ơn anh/chị. Đúng là thêm s và Shapes là OK rồi.

Cám ơn anh/chị.

{"id":82548,"crm_contact_id":29934,"name":"CSKH Gitiho Vi\u1ec7t Nam","email":"hotro@gitiho.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2020-02-12 17:12:54","confirmation_code":"ccae872502b90d64fa68a5773858a513","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2020-01-30T15:32:47.000000Z","updated_at":"2023-09-18T12:57:58.000000Z","deleted_at":null,"unit_name":null,"grade":0,"avatar_disk":"public","avatar_path":"users\/1652762083.png","gender":0,"birthday":null,"position":null,"achievement":null,"full_name":"CSKH Gitiho Vi\u1ec7t Nam","address":"Gitiho Vi\u1ec7t Nam","status_text":"","user_type":"","social_facebook":"","social_google":"","social_twitter":"","social_linkedin":"","cover_path":"","idvg_id":0,"facebook_id":0,"phone":"0774116285","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":8000,"google_id":"109213028097135238411","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":32,"email_invalid":0,"type_email_invalid":null,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/caches\/ua_small\/users\/1652762083.png","link_profile":"https:\/\/gitiho.com\/u\/82548-cskh-gitiho-viet-nam","business_employers":[{"id":2713,"biz_business_id":79,"statusHtml":"<span class=\"badge badge-secondary\"> Deactivated <\/span>","bizUser":"","had_subscription":0},{"id":2715,"biz_business_id":12,"statusHtml":"<span class=\"badge badge-secondary\"> Deactivated <\/span>","bizUser":"","had_subscription":0},{"id":2716,"biz_business_id":61,"statusHtml":"<span class=\"badge badge-secondary\"> Deactivated <\/span>","bizUser":"","had_subscription":0}],"vip_account":null,"roles":[{"id":10,"biz_business_id":0,"name":"CourseManager","display_name":"CourseManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":10,"model_type":"App\\Models\\User"}},{"id":11,"biz_business_id":0,"name":"Sale","display_name":"Sale","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":11,"model_type":"App\\Models\\User"}},{"id":12,"biz_business_id":0,"name":"SaleManager","display_name":"SaleManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":12,"model_type":"App\\Models\\User"}},{"id":14,"biz_business_id":0,"name":"UserManager","display_name":"UserManager","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":14,"model_type":"App\\Models\\User"}},{"id":17,"biz_business_id":0,"name":"partnerAffiliate","display_name":"partnerAffiliate","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":17,"model_type":"App\\Models\\User"}},{"id":26,"biz_business_id":0,"name":"Tr\u1ee3 gi\u1ea3ng","display_name":"Tr\u1ee3 gi\u1ea3ng","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":26,"model_type":"App\\Models\\User"}},{"id":27,"biz_business_id":0,"name":"Customer service","display_name":"Customer service","guard_name":"web","created_at":"2022-11-30T09:06:55.000000Z","updated_at":"2022-11-30T09:06:55.000000Z","is_default":0,"pivot":{"model_id":82548,"role_id":27,"model_type":"App\\Models\\User"}}]}

CSKH Gitiho Việt Nam 15 Aug 2023

Dạ không có gì, chúc anh/chi học tập hiệu quả

Nguyen Thi Hoa

Nguyen Thi Hoa 01 Aug 2023

Xin GV hướng dẫn cách tạo file trừ tồn kho theo ngày giúp ạ. Số lượng tồn kho bị trừ phải đi kèm với đơn giá nhập khao

CSKH Gitiho Việt Nam

CSKH Gitiho Việt Nam 15 Aug 2023

Chào anh/chị,
Việc tính giá xuất kho vốn là 1 cái rất phức tạp trong kế toán, thường excel chỉ tính theo giá trung bình thôi, ở đây tính theo ngày thì có thể có nhiều cách tính khác, như nhập trước xuất trước thì ko tính được, chỉ tính số lượng được thôi, chứ ko tính kèm theo giá tiền, nội dung này thì anh/chị xem cách dùng hàm sumifs trong tính nhập-xuất-tồn nhé ạ

Lê Minh Thuỳ Phượng

Lê Minh Thuỳ Phượng 08 Aug 2023


 

Phung Minh Tuan

Phung Minh Tuan 12 Aug 2023

Minh cũng bị lỗi tương tự. Phiền thầy/cô hướng dẫn lỗi này? Mình cám ơn.

{"id":343891,"crm_contact_id":600266,"name":"L\u00ea Minh Thu\u1ef3 Ph\u01b0\u1ee3ng","email":"leephuong1402@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":null,"confirmation_code":"2d735fdce1f4f7e7f12f3816e3a4b7f6","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-07-15T07:32:51.000000Z","updated_at":"2023-08-14T06:27:06.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":"0933906468","become_teacher":0,"primary_wallet":0,"secondary_wallet":0,"wallet_type":"","wallet_payment":"","loyalty_point":20437,"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":1,"email_invalid":0,"type_email_invalid":null,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_344\/le-phuong.png","link_profile":"https:\/\/gitiho.com\/u\/343891-le-minh-thuy-phuong","business_employers":[],"vip_account":null,"roles":[]}

Lê Minh Thuỳ Phượng 14 Aug 2023

Thầy/cô hướng dẫn giúp em ạ. Em cám ơn

 

Nguyen Thi Hoa

Nguyen Thi Hoa 01 Aug 2023

XIN HƯỚNG DẪN CODE ĐỂ TÁCH CÁC MÃ HÀNG THÀNH TỪ SHEET Ạ

Nguyen Thi Hoa

Nguyen Thi Hoa 01 Aug 2023

{"id":345072,"crm_contact_id":602649,"name":"Nguyen Thi Hoa","email":"hoanguyenbaolam@gmail.com","status":1,"refresh_login":0,"password_reset":1,"last_update_password":"2023-07-28 09:00:12","confirmation_code":"79f5ff29ad6dad360b30386038bbd1ac","confirmed":1,"session_id":null,"enable_api":0,"access_key":null,"created_at":"2023-07-20T12:03:29.000000Z","updated_at":"2023-08-13T03:05:53.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":21404,"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":1,"email_invalid":0,"type_email_invalid":null,"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,"login_mobile":0,"gitiho_user":1,"avatar":"https:\/\/gitiho.com\/images\/avatar\/folder_345\/nguyen-hoa.png","link_profile":"https:\/\/gitiho.com\/u\/345072-nguyen-thi-hoa","business_employers":[],"vip_account":null,"roles":[]}

Nguyen Thi Hoa 01 Aug 2023

CHO E XIN MÃ CODE NÀY VỚI Ạ. THANKS

69,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
Giấy phép mạng xã hội số: 588, cấp bởi Bộ thông tin và truyền thông
/