{"id":32926,"date":"2026-03-06T20:07:38","date_gmt":"2026-03-06T17:07:38","guid":{"rendered":"https:\/\/www.dztecs.com\/tech\/?p=32926"},"modified":"2026-03-06T20:07:38","modified_gmt":"2026-03-06T17:07:38","slug":"an-advanced-vba-guide-for-ms-excel-mastering-automation","status":"publish","type":"post","link":"https:\/\/www.dztecs.com\/tech\/an-advanced-vba-guide-for-ms-excel-mastering-automation\/","title":{"rendered":"\u062f\u0644\u064a\u0644 VBA \u0645\u062a\u0642\u062f\u0645 \u0644\u0640 MS Excel: \u0627\u062d\u062a\u0631\u0627\u0641 \u0627\u0644\u0623\u062a\u0645\u062a\u0629"},"content":{"rendered":"<div>\n<div>\n<div>\n<p>\u0625\u0630\u0627 \u0643\u0646\u062a \u0642\u062f \u0628\u062f\u0623\u062a \u0644\u0644\u062a\u0648 \u0641\u064a \u0627\u0633\u062a\u062e\u062f\u0627\u0645 VBA\u060c \u0641\u0633\u062a\u062d\u062a\u0627\u062c \u0625\u0644\u0649 \u0627\u0644\u0628\u062f\u0621 \u0628\u062f\u0631\u0627\u0633\u0629 <a href=\"https:\/\/www.dztecs.com\/tech\/best-free-people-search-websites\/\">\u062f\u0644\u064a\u0644 VBA \u0644\u0644\u0645\u0628\u062a\u062f\u0626\u064a\u0646<\/a>. \u0648\u0644\u0643\u0646 \u0625\u0630\u0627 \u0643\u0646\u062a \u062e\u0628\u064a\u0631\u064b\u0627 \u0645\u062a\u0645\u0631\u0633\u064b\u0627 \u0641\u064a VBA \u0648\u062a\u0628\u062d\u062b \u0639\u0646 \u0623\u0634\u064a\u0627\u0621 \u0623\u0643\u062b\u0631 \u062a\u0642\u062f\u0645\u064b\u0627 \u064a\u0645\u0643\u0646\u0643 \u0627\u0644\u0642\u064a\u0627\u0645 \u0628\u0647\u0627 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 VBA \u0641\u064a Excel\u060c \u0641\u0627\u0633\u062a\u0645\u0631 \u0641\u064a \u0627\u0644\u0642\u0631\u0627\u0621\u0629.<\/p>\n<div class=\"featured-image-container\" style=\"margin: 20px 0; text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-featured-og\" src=\"https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/excel-2.jpeg\" alt=\"\u062f\u0644\u064a\u0644 VBA \u0645\u062a\u0642\u062f\u0645 \u0644\u0640 MS Excel: \u0627\u062d\u062a\u0631\u0627\u0641 \u0627\u0644\u0623\u062a\u0645\u062a\u0629\" width=\"680\" height=\"454\" \/><\/div>\n<p>\u062a\u062a\u064a\u062d \u0644\u0643 \u0627\u0644\u0642\u062f\u0631\u0629 \u0639\u0644\u0649 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u062a\u0631\u0645\u064a\u0632 VBA \u0641\u064a Excel \u0639\u0627\u0644\u0645\u064b\u0627 \u0643\u0627\u0645\u0644\u0627\u064b \u0645\u0646 \u0627\u0644\u0623\u062a\u0645\u062a\u0629. \u064a\u0645\u0643\u0646\u0643 \u0623\u062a\u0645\u062a\u0629 \u0627\u0644\u0639\u0645\u0644\u064a\u0627\u062a \u0627\u0644\u062d\u0633\u0627\u0628\u064a\u0629 \u0641\u064a Excel\u060c \u0648\u0627\u0644\u0623\u0632\u0631\u0627\u0631\u060c \u0648\u062d\u062a\u0649 \u0625\u0631\u0633\u0627\u0644 \u0627\u0644\u0628\u0631\u064a\u062f \u0627\u0644\u0625\u0644\u0643\u062a\u0631\u0648\u0646\u064a. \u0647\u0646\u0627\u0643 \u0627\u0644\u0645\u0632\u064a\u062f \u0645\u0646 \u0627\u0644\u0627\u062d\u062a\u0645\u0627\u0644\u0627\u062a \u0644\u0623\u062a\u0645\u062a\u0629 \u0639\u0645\u0644\u0643 \u0627\u0644\u064a\u0648\u0645\u064a \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 VBA \u0623\u0643\u062b\u0631 \u0645\u0645\u0627 \u0642\u062f \u062a\u062f\u0631\u0643.<\/p>\n<h2><strong>\u062f\u0644\u064a\u0644 VBA \u0627\u0644\u0645\u062a\u0642\u062f\u0645 \u0644\u0640 Microsoft Excel<\/strong><\/h2>\n<p>\u0627\u0644\u0647\u062f\u0641 \u0627\u0644\u0631\u0626\u064a\u0633\u064a \u0645\u0646 \u0643\u062a\u0627\u0628\u0629 \u0643\u0648\u062f VBA \u0641\u064a Excel \u0647\u0648 \u0623\u0646\u0647 \u064a\u0645\u0643\u0646\u0643 \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0627\u0644\u0645\u0639\u0644\u0648\u0645\u0627\u062a \u0645\u0646 \u062c\u062f\u0648\u0644 \u0628\u064a\u0627\u0646\u0627\u062a\u060c \u0648\u0625\u062c\u0631\u0627\u0621 \u0645\u062c\u0645\u0648\u0639\u0629 \u0645\u062a\u0646\u0648\u0639\u0629 \u0645\u0646 \u0627\u0644\u0639\u0645\u0644\u064a\u0627\u062a \u0627\u0644\u062d\u0633\u0627\u0628\u064a\u0629 \u0639\u0644\u064a\u0647\u0627\u060c \u062b\u0645 \u0643\u062a\u0627\u0628\u0629 \u0627\u0644\u0646\u062a\u0627\u0626\u062c \u0645\u0631\u0629 \u0623\u062e\u0631\u0649 \u0625\u0644\u0649 \u062c\u062f\u0648\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a<\/p>\n<p>\u0641\u064a\u0645\u0627 \u064a\u0644\u064a \u0627\u0644\u0627\u0633\u062a\u062e\u062f\u0627\u0645\u0627\u062a \u0627\u0644\u0623\u0643\u062b\u0631 \u0634\u064a\u0648\u0639\u064b\u0627 \u0644\u0640 VBA \u0641\u064a Excel.<\/p>\n<ul>\n<li>\u0627\u0633\u062a\u064a\u0631\u0627\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u0625\u062c\u0631\u0627\u0621 \u0627\u0644\u0639\u0645\u0644\u064a\u0627\u062a \u0627\u0644\u062d\u0633\u0627\u0628\u064a\u0629<\/li>\n<li>\u062d\u0633\u0627\u0628 \u0627\u0644\u0646\u062a\u0627\u0626\u062c \u0645\u0646 \u0636\u063a\u0637 \u0627\u0644\u0645\u0633\u062a\u062e\u062f\u0645 \u0639\u0644\u0649 \u0632\u0631<\/li>\n<li>\u0625\u0631\u0633\u0627\u0644 \u0646\u062a\u0627\u0626\u062c \u0627\u0644\u0639\u0645\u0644\u064a\u0627\u062a \u0627\u0644\u062d\u0633\u0627\u0628\u064a\u0629 \u0628\u0627\u0644\u0628\u0631\u064a\u062f \u0627\u0644\u0625\u0644\u0643\u062a\u0631\u0648\u0646\u064a \u0625\u0644\u0649 \u0634\u062e\u0635 \u0645\u0627<\/li>\n<\/ul>\n<p>\u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0647\u0630\u0647 \u0627\u0644\u0623\u0645\u062b\u0644\u0629 \u0627\u0644\u062b\u0644\u0627\u062b\u0629\u060c \u064a\u062c\u0628 \u0623\u0646 \u062a\u0643\u0648\u0646 \u0642\u0627\u062f\u0631\u064b\u0627 \u0639\u0644\u0649 \u0643\u062a\u0627\u0628\u0629 \u0645\u062c\u0645\u0648\u0639\u0629 \u0645\u062a\u0646\u0648\u0639\u0629 \u0645\u0646 \u0623\u0643\u0648\u0627\u062f Excel VBA \u0627\u0644\u0645\u062a\u0642\u062f\u0645\u0629 \u0627\u0644\u062e\u0627\u0635\u0629 \u0628\u0643.<\/p>\n<h4><strong>\u0627\u0633\u062a\u064a\u0631\u0627\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u0625\u062c\u0631\u0627\u0621 \u0627\u0644\u0639\u0645\u0644\u064a\u0627\u062a \u0627\u0644\u062d\u0633\u0627\u0628\u064a\u0629<\/strong><\/h4>\n<p>\u0623\u062d\u062f \u0623\u0643\u062b\u0631 \u0627\u0644\u0623\u0634\u064a\u0627\u0621 \u0634\u064a\u0648\u0639\u064b\u0627 \u0627\u0644\u062a\u064a \u064a\u0633\u062a\u062e\u062f\u0645\u0647\u0627 \u0627\u0644\u0623\u0634\u062e\u0627\u0635 \u0641\u064a Excel \u0647\u0648 \u0625\u062c\u0631\u0627\u0621 \u0627\u0644\u0639\u0645\u0644\u064a\u0627\u062a \u0627\u0644\u062d\u0633\u0627\u0628\u064a\u0629 \u0639\u0644\u0649 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0645\u0648\u062c\u0648\u062f\u0629 \u062e\u0627\u0631\u062c Excel. \u0625\u0630\u0627 \u0643\u0646\u062a \u0644\u0627 \u062a\u0633\u062a\u062e\u062f\u0645 VBA\u060c \u0641\u0647\u0630\u0627 \u064a\u0639\u0646\u064a \u0623\u0646\u0647 \u064a\u062a\u0639\u064a\u0646 \u0639\u0644\u064a\u0643 \u0627\u0633\u062a\u064a\u0631\u0627\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u064a\u062f\u0648\u064a\u064b\u0627\u060c \u0648\u062a\u0634\u063a\u064a\u0644 \u0627\u0644\u0639\u0645\u0644\u064a\u0627\u062a \u0627\u0644\u062d\u0633\u0627\u0628\u064a\u0629 \u0648\u0625\u062e\u0631\u0627\u062c \u0647\u0630\u0647 \u0627\u0644\u0642\u064a\u0645 \u0625\u0644\u0649 \u0648\u0631\u0642\u0629 \u0623\u0648 \u062a\u0642\u0631\u064a\u0631 \u0622\u062e\u0631.<\/p>\n<p>\u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 VBA\u060c \u064a\u0645\u0643\u0646\u0643 \u0623\u062a\u0645\u062a\u0629 \u0627\u0644\u0639\u0645\u0644\u064a\u0629 \u0628\u0623\u0643\u0645\u0644\u0647\u0627. \u0639\u0644\u0649 \u0633\u0628\u064a\u0644 \u0627\u0644\u0645\u062b\u0627\u0644\u060c \u0625\u0630\u0627 \u0643\u0627\u0646 \u0644\u062f\u064a\u0643 \u0645\u0644\u0641 CSV \u062c\u062f\u064a\u062f \u064a\u062a\u0645 \u062a\u0646\u0632\u064a\u0644\u0647 \u0641\u064a \u062f\u0644\u064a\u0644 \u0639\u0644\u0649 \u062c\u0647\u0627\u0632 \u0627\u0644\u0643\u0645\u0628\u064a\u0648\u062a\u0631 \u0627\u0644\u062e\u0627\u0635 \u0628\u0643 \u0643\u0644 \u064a\u0648\u0645 \u0627\u062b\u0646\u064a\u0646\u060c \u0641\u064a\u0645\u0643\u0646\u0643 \u062a\u0643\u0648\u064a\u0646 \u0643\u0648\u062f VBA \u0627\u0644\u062e\u0627\u0635 \u0628\u0643 \u0644\u064a\u062a\u0645 \u062a\u0634\u063a\u064a\u0644\u0647 \u0639\u0646\u062f \u0641\u062a\u062d \u062c\u062f\u0648\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u062e\u0627\u0635 \u0628\u0643 \u0644\u0623\u0648\u0644 \u0645\u0631\u0629 \u0635\u0628\u0627\u062d \u064a\u0648\u0645 \u0627\u0644\u062b\u0644\u0627\u062b\u0627\u0621.<\/p>\n<p>\u0633\u064a\u062a\u0645 \u062a\u0634\u063a\u064a\u0644 \u0643\u0648\u062f \u0627\u0644\u0627\u0633\u062a\u064a\u0631\u0627\u062f \u0627\u0644\u062a\u0627\u0644\u064a \u0648\u0627\u0633\u062a\u064a\u0631\u0627\u062f \u0645\u0644\u0641 CSV \u0625\u0644\u0649 \u062c\u062f\u0648\u0644 \u0628\u064a\u0627\u0646\u0627\u062a Excel \u0627\u0644\u062e\u0627\u0635 \u0628\u0643.<\/p>\n<pre>Dim ws As Worksheet, strFile As String\r\n\r\nSet ws = ActiveWorkbook.Sheets(\"Sheet1\")\r\nCells.ClearContents\r\n\r\nstrFile = \u201cc:temppurchases.csv\u201d\r\n\r\nWith ws.QueryTables.Add(Connection:=\"TEXT;\" &amp; strFile, Destination:=ws.Range(\"A1\"))\r\n     .TextFileParseType = xlDelimited\r\n     .TextFileCommaDelimiter = True\r\n     .Refresh\r\nEnd With<\/pre>\n<p>\u0627\u0641\u062a\u062d \u0623\u062f\u0627\u0629 \u062a\u062d\u0631\u064a\u0631 Excel VBA \u0648\u062d\u062f\u062f \u0643\u0627\u0626\u0646 Sheet1. \u0645\u0646 \u0645\u0631\u0628\u0639\u0627\u062a \u0627\u0644\u0642\u0627\u0626\u0645\u0629 \u0627\u0644\u0645\u0646\u0633\u062f\u0644\u0629 \u0644\u0644\u0643\u0627\u0626\u0646 \u0648\u0627\u0644\u0637\u0631\u064a\u0642\u0629\u060c \u0627\u062e\u062a\u0631 <strong>Worksheet<\/strong> \u0648 <strong>Activate<\/strong>. \u0633\u064a\u0624\u062f\u064a \u0647\u0630\u0627 \u0625\u0644\u0649 \u062a\u0634\u063a\u064a\u0644 \u0627\u0644\u0643\u0648\u062f \u0641\u064a \u0643\u0644 \u0645\u0631\u0629 \u062a\u0641\u062a\u062d \u0641\u064a\u0647\u0627 \u062c\u062f\u0648\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a.<\/p>\n<p>\u0633\u064a\u0624\u062f\u064a \u0647\u0630\u0627 \u0625\u0644\u0649 \u0625\u0646\u0634\u0627\u0621 \u062f\u0627\u0644\u0629 <strong>Sub Worksheet_Activate()<\/strong>. \u0627\u0644\u0635\u0642 \u0627\u0644\u0643\u0648\u062f \u0623\u0639\u0644\u0627\u0647 \u0641\u064a \u0647\u0630\u0647 \u0627\u0644\u062f\u0627\u0644\u0629.<\/p>\n<div><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-32928\" src=\"https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/import-vba-function-1.jpg\" alt=\"\" width=\"680\" height=\"419\" srcset=\"https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/import-vba-function-1.jpg 680w, https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/import-vba-function-1-400x246.jpg 400w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><\/div>\n<p>\u064a\u0642\u0648\u0645 \u0647\u0630\u0627 \u0628\u062a\u0639\u064a\u064a\u0646 \u0648\u0631\u0642\u0629 \u0627\u0644\u0639\u0645\u0644 \u0627\u0644\u0646\u0634\u0637\u0629 \u0625\u0644\u0649 <strong>Sheet1<\/strong>\u060c \u0648\u0645\u0633\u062d \u0627\u0644\u0648\u0631\u0642\u0629\u060c \u0648\u0627\u0644\u0627\u062a\u0635\u0627\u0644 \u0628\u0627\u0644\u0645\u0644\u0641 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0645\u0633\u0627\u0631 \u0627\u0644\u0645\u0644\u0641 \u0627\u0644\u0630\u064a \u062d\u062f\u062f\u062a\u0647 \u0628\u0627\u0644\u0645\u062a\u063a\u064a\u0631 <strong>strFile<\/strong>\u060c \u062b\u0645 \u062a\u0642\u0648\u0645 \u062d\u0644\u0642\u0629 <strong>With<\/strong> \u0628\u0627\u0644\u062f\u0648\u0631\u0627\u0646 \u0639\u0628\u0631 \u0643\u0644 \u0633\u0637\u0631 \u0641\u064a \u0627\u0644\u0645\u0644\u0641 \u0648\u0648\u0636\u0639 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0641\u064a \u0627\u0644\u0648\u0631\u0642\u0629 \u0628\u062f\u0621\u064b\u0627 \u0645\u0646 \u0627\u0644\u062e\u0644\u064a\u0629 A1.<\/p>\n<p>\u0625\u0630\u0627 \u0642\u0645\u062a \u0628\u062a\u0634\u063a\u064a\u0644 \u0647\u0630\u0627 \u0627\u0644\u0643\u0648\u062f\u060c \u0641\u0633\u062a\u0631\u0649 \u0623\u0646 \u0628\u064a\u0627\u0646\u0627\u062a \u0645\u0644\u0641 CSV \u064a\u062a\u0645 \u0627\u0633\u062a\u064a\u0631\u0627\u062f\u0647\u0627 \u0625\u0644\u0649 \u062c\u062f\u0648\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0641\u0627\u0631\u063a \u0627\u0644\u062e\u0627\u0635 \u0628\u0643\u060c \u0641\u064a <strong>Sheet1<\/strong>.<\/p>\n<div><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-32929\" src=\"https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/data-imported-1.jpg\" alt=\"\" width=\"680\" height=\"383\" srcset=\"https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/data-imported-1.jpg 680w, https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/data-imported-1-400x225.jpg 400w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><\/div>\n<p>\u0627\u0644\u0627\u0633\u062a\u064a\u0631\u0627\u062f \u0647\u0648 \u0627\u0644\u062e\u0637\u0648\u0629 \u0627\u0644\u0623\u0648\u0644\u0649 \u0641\u0642\u0637. \u0628\u0639\u062f \u0630\u0644\u0643\u060c \u0633\u062a\u0631\u063a\u0628 \u0641\u064a \u0625\u0646\u0634\u0627\u0621 \u0631\u0623\u0633 \u062c\u062f\u064a\u062f \u0644\u0644\u0639\u0645\u0648\u062f \u0627\u0644\u0630\u064a \u0633\u064a\u062d\u062a\u0648\u064a \u0639\u0644\u0649 \u0646\u062a\u0627\u0626\u062c \u0627\u0644\u0639\u0645\u0644\u064a\u0627\u062a \u0627\u0644\u062d\u0633\u0627\u0628\u064a\u0629 \u0627\u0644\u062e\u0627\u0635\u0629 \u0628\u0643. \u0641\u064a \u0647\u0630\u0627 \u0627\u0644\u0645\u062b\u0627\u0644\u060c \u0644\u0646\u0641\u062a\u0631\u0636 \u0623\u0646\u0643 \u062a\u0631\u064a\u062f \u062d\u0633\u0627\u0628 \u0627\u0644\u0636\u0631\u0627\u0626\u0628 \u0627\u0644\u0645\u062f\u0641\u0648\u0639\u0629 \u0628\u0646\u0633\u0628\u0629 5\u066a \u0639\u0644\u0649 \u0628\u064a\u0639 \u0643\u0644 \u0639\u0646\u0635\u0631.<\/p>\n<p>\u062a\u0631\u062a\u064a\u0628 \u0627\u0644\u0625\u062c\u0631\u0627\u0621\u0627\u062a \u0627\u0644\u062a\u064a \u064a\u062c\u0628 \u0623\u0646 \u064a\u062a\u062e\u0630\u0647\u0627 \u0627\u0644\u0643\u0648\u062f \u0627\u0644\u062e\u0627\u0635 \u0628\u0643 \u0647\u0648:<\/p>\n<ol>\n<li>\u0625\u0646\u0634\u0627\u0621 \u0639\u0645\u0648\u062f \u0646\u062a\u0627\u0626\u062c \u062c\u062f\u064a\u062f \u064a\u0633\u0645\u0649 <strong>taxes<\/strong>.<\/li>\n<li>\u0627\u0644\u062a\u0643\u0631\u0627\u0631 \u0639\u0628\u0631 \u0639\u0645\u0648\u062f <strong>units sold<\/strong> \u0648\u062d\u0633\u0627\u0628 \u0636\u0631\u064a\u0628\u0629 \u0627\u0644\u0645\u0628\u064a\u0639\u0627\u062a.<\/li>\n<li>\u0643\u062a\u0627\u0628\u0629 \u0646\u062a\u0627\u0626\u062c \u0627\u0644\u0639\u0645\u0644\u064a\u0627\u062a \u0627\u0644\u062d\u0633\u0627\u0628\u064a\u0629 \u0641\u064a \u0627\u0644\u0635\u0641 \u0627\u0644\u0645\u0646\u0627\u0633\u0628 \u0641\u064a \u0627\u0644\u0648\u0631\u0642\u0629.<\/li>\n<\/ol>\n<p>\u0633\u064a\u062d\u0642\u0642 \u0627\u0644\u0643\u0648\u062f \u0627\u0644\u062a\u0627\u0644\u064a \u0643\u0644 \u0647\u0630\u0647 \u0627\u0644\u062e\u0637\u0648\u0627\u062a.<\/p>\n<pre>Dim LastRow As Long\r\nDim StartCell As Range\r\nDim rowCounter As Integer\r\nDim rng As Range, cell As Range\r\nDim fltTax As Double\r\n\r\nSet StartCell = Range(\"A1\")\r\n\r\n'Find Last Row and Column\r\nLastRow = ws.Cells(ws.Rows.Count, StartCell.Column).End(xlUp).Row\r\nSet rng = ws.Range(ws.Cells(2, 4), ws.Cells(LastRow, 4))\r\n\r\nrowCounter = 2\r\nCells(1, 5) = \"taxes\"\r\n\r\nFor Each cell In rng\r\n     fltTax = cell.Value * 0.05\r\n     Cells(rowCounter, 5) = fltTax\r\n     rowCounter = rowCounter + 1\r\nNext cell<\/pre>\n<p>\u064a\u062c\u062f \u0647\u0630\u0627 \u0627\u0644\u0643\u0648\u062f \u0627\u0644\u0635\u0641 \u0627\u0644\u0623\u062e\u064a\u0631 \u0641\u064a \u0648\u0631\u0642\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u062e\u0627\u0635\u0629 \u0628\u0643\u060c \u062b\u0645 \u064a\u0642\u0648\u0645 \u0628\u062a\u0639\u064a\u064a\u0646 \u0646\u0637\u0627\u0642 \u0627\u0644\u062e\u0644\u0627\u064a\u0627 (\u0627\u0644\u0639\u0645\u0648\u062f \u0627\u0644\u0630\u064a \u064a\u062d\u062a\u0648\u064a \u0639\u0644\u0649 \u0623\u0633\u0639\u0627\u0631 \u0627\u0644\u0645\u0628\u064a\u0639\u0627\u062a) \u0648\u0641\u0642\u064b\u0627 \u0644\u0644\u0635\u0641 \u0627\u0644\u0623\u0648\u0644 \u0648\u0627\u0644\u0623\u062e\u064a\u0631 \u0645\u0646 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a. \u062b\u0645 \u064a\u0642\u0648\u0645 \u0627\u0644\u0643\u0648\u062f \u0628\u0627\u0644\u062a\u0643\u0631\u0627\u0631 \u0639\u0628\u0631 \u0643\u0644 \u062e\u0644\u064a\u0629 \u0645\u0646 \u0647\u0630\u0647 \u0627\u0644\u062e\u0644\u0627\u064a\u0627\u060c \u0648\u0625\u062c\u0631\u0627\u0621 \u062d\u0633\u0627\u0628 \u0627\u0644\u0636\u0631\u064a\u0628\u0629 \u0648\u0643\u062a\u0627\u0628\u0629 \u0627\u0644\u0646\u062a\u0627\u0626\u062c \u0641\u064a \u0639\u0645\u0648\u062f\u0643 \u0627\u0644\u062c\u062f\u064a\u062f (\u0627\u0644\u0639\u0645\u0648\u062f 5).<\/p>\n<p>\u0627\u0644\u0635\u0642 \u0643\u0648\u062f VBA \u0623\u0639\u0644\u0627\u0647 \u0623\u0633\u0641\u0644 \u0627\u0644\u0643\u0648\u062f \u0627\u0644\u0633\u0627\u0628\u0642\u060c \u0648\u0642\u0645 \u0628\u062a\u0634\u063a\u064a\u0644 \u0627\u0644\u0628\u0631\u0646\u0627\u0645\u062c \u0627\u0644\u0646\u0635\u064a. \u0633\u062a\u0631\u0649 \u0627\u0644\u0646\u062a\u0627\u0626\u062c \u062a\u0638\u0647\u0631 \u0641\u064a \u0627\u0644\u0639\u0645\u0648\u062f E.<\/p>\n<div><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-32930\" src=\"https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/tax-results-1.jpg\" alt=\"\" width=\"680\" height=\"377\" srcset=\"https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/tax-results-1.jpg 680w, https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/tax-results-1-400x222.jpg 400w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><\/div>\n<p>\u0627\u0644\u0622\u0646\u060c \u0641\u064a \u0643\u0644 \u0645\u0631\u0629 \u062a\u0641\u062a\u062d \u0641\u064a\u0647\u0627 \u0648\u0631\u0642\u0629 \u0639\u0645\u0644 Excel \u0627\u0644\u062e\u0627\u0635\u0629 \u0628\u0643\u060c \u0633\u064a\u0642\u0648\u0645 \u0627\u0644\u0628\u0631\u0646\u0627\u0645\u062c \u062a\u0644\u0642\u0627\u0626\u064a\u064b\u0627 \u0628\u062c\u0644\u0628 \u0623\u062d\u062f\u062b \u0646\u0633\u062e\u0629 \u0645\u0646 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0645\u0646 \u0645\u0644\u0641 CSV. \u0628\u0639\u062f \u0630\u0644\u0643\u060c \u0633\u064a\u0642\u0648\u0645 \u0628\u0625\u062c\u0631\u0627\u0621 \u0627\u0644\u0639\u0645\u0644\u064a\u0627\u062a \u0627\u0644\u062d\u0633\u0627\u0628\u064a\u0629 \u0648\u0643\u062a\u0627\u0628\u0629 \u0627\u0644\u0646\u062a\u0627\u0626\u062c \u0641\u064a \u0627\u0644\u0648\u0631\u0642\u0629. \u0644\u0646 \u062a\u0636\u0637\u0631 \u0625\u0644\u0649 \u0641\u0639\u0644 \u0623\u064a \u0634\u064a\u0621 \u064a\u062f\u0648\u064a\u064b\u0627 \u0628\u0639\u062f \u0627\u0644\u0622\u0646!<\/p>\n<h4><strong>\u062d\u0633\u0627\u0628 \u0627\u0644\u0646\u062a\u0627\u0626\u062c \u0645\u0646 \u062e\u0644\u0627\u0644 \u0627\u0644\u0636\u063a\u0637 \u0639\u0644\u0649 \u0632\u0631<\/strong><\/h4>\n<p>\u0625\u0630\u0627 \u0643\u0646\u062a \u062a\u0641\u0636\u0644 \u0627\u0644\u062a\u062d\u0643\u0645 \u0627\u0644\u0645\u0628\u0627\u0634\u0631 \u0641\u064a \u0648\u0642\u062a \u062a\u0634\u063a\u064a\u0644 \u0627\u0644\u0639\u0645\u0644\u064a\u0627\u062a \u0627\u0644\u062d\u0633\u0627\u0628\u064a\u0629\u060c \u0628\u062f\u0644\u0627\u064b \u0645\u0646 \u062a\u0634\u063a\u064a\u0644\u0647\u0627 \u062a\u0644\u0642\u0627\u0626\u064a\u064b\u0627 \u0639\u0646\u062f \u0641\u062a\u062d \u0627\u0644\u0648\u0631\u0642\u0629\u060c \u064a\u0645\u0643\u0646\u0643 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0632\u0631 \u062a\u062d\u0643\u0645 \u0628\u062f\u0644\u0627\u064b \u0645\u0646 \u0630\u0644\u0643.<\/p>\n<p>\u062a\u0639\u062a\u0628\u0631 \u0623\u0632\u0631\u0627\u0631 \u0627\u0644\u062a\u062d\u0643\u0645 \u0645\u0641\u064a\u062f\u0629 \u0625\u0630\u0627 \u0643\u0646\u062a \u062a\u0631\u064a\u062f \u0627\u0644\u062a\u062d\u0643\u0645 \u0641\u064a \u0627\u0644\u0639\u0645\u0644\u064a\u0627\u062a \u0627\u0644\u062d\u0633\u0627\u0628\u064a\u0629 \u0627\u0644\u0645\u0633\u062a\u062e\u062f\u0645\u0629. \u0639\u0644\u0649 \u0633\u0628\u064a\u0644 \u0627\u0644\u0645\u062b\u0627\u0644\u060c \u0641\u064a \u0646\u0641\u0633 \u0627\u0644\u062d\u0627\u0644\u0629 \u0627\u0644\u0645\u0630\u0643\u0648\u0631\u0629 \u0623\u0639\u0644\u0627\u0647\u060c \u0645\u0627\u0630\u0627 \u0644\u0648 \u0643\u0646\u062a \u062a\u0631\u064a\u062f \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0645\u0639\u062f\u0644 \u0636\u0631\u064a\u0628\u0629 \u0628\u0646\u0633\u0628\u0629 5\u066a \u0644\u0645\u0646\u0637\u0642\u0629 \u0645\u0627\u060c \u0648\u0645\u0639\u062f\u0644 \u0636\u0631\u064a\u0628\u0629 \u0628\u0646\u0633\u0628\u0629 7\u066a \u0644\u0645\u0646\u0637\u0642\u0629 \u0623\u062e\u0631\u0649\u061f<\/p>\n<p>\u064a\u0645\u0643\u0646\u0643 \u0627\u0644\u0633\u0645\u0627\u062d \u0628\u062a\u0634\u063a\u064a\u0644 \u0646\u0641\u0633 \u0643\u0648\u062f \u0627\u0633\u062a\u064a\u0631\u0627\u062f CSV \u062a\u0644\u0642\u0627\u0626\u064a\u064b\u0627\u060c \u0648\u0644\u0643\u0646 \u0627\u062a\u0631\u0643 \u0643\u0648\u062f \u062d\u0633\u0627\u0628 \u0627\u0644\u0636\u0631\u064a\u0628\u0629 \u0644\u064a\u062a\u0645 \u062a\u0634\u063a\u064a\u0644\u0647 \u0639\u0646\u062f \u0627\u0644\u0636\u063a\u0637 \u0639\u0644\u0649 \u0627\u0644\u0632\u0631 \u0627\u0644\u0645\u0646\u0627\u0633\u0628.<\/p>\n<p>\u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0646\u0641\u0633 \u062c\u062f\u0648\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0645\u0630\u0643\u0648\u0631 \u0623\u0639\u0644\u0627\u0647\u060c \u062d\u062f\u062f \u0639\u0644\u0627\u0645\u0629 \u0627\u0644\u062a\u0628\u0648\u064a\u0628 <strong>Developer<\/strong>\u060c \u0648\u062d\u062f\u062f <strong>Insert<\/strong> \u0645\u0646 \u0645\u062c\u0645\u0648\u0639\u0629 <strong>Controls<\/strong> \u0641\u064a \u0627\u0644\u0634\u0631\u064a\u0637. \u062d\u062f\u062f \u0639\u0646\u0635\u0631 \u062a\u062d\u0643\u0645 <strong>push button<\/strong> ActiveX \u0645\u0646 \u0627\u0644\u0642\u0627\u0626\u0645\u0629 \u0627\u0644\u0645\u0646\u0633\u062f\u0644\u0629.<\/p>\n<div><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-32931\" src=\"https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/select-pushbutton-1.jpg\" alt=\"\" width=\"680\" height=\"417\" srcset=\"https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/select-pushbutton-1.jpg 680w, https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/select-pushbutton-1-400x245.jpg 400w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><\/div>\n<p>\u0627\u0631\u0633\u0645 \u0632\u0631 \u0627\u0644\u0636\u063a\u0637 \u0639\u0644\u0649 \u0623\u064a \u062c\u0632\u0621 \u0645\u0646 \u0627\u0644\u0648\u0631\u0642\u0629 \u0628\u0639\u064a\u062f\u064b\u0627 \u0639\u0646 \u0627\u0644\u0645\u0643\u0627\u0646 \u0627\u0644\u0630\u064a \u0633\u062a\u0630\u0647\u0628 \u0625\u0644\u064a\u0647 \u0623\u064a \u0628\u064a\u0627\u0646\u0627\u062a.<\/p>\n<div><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-32932\" src=\"https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/select-pushbutton2-1.jpg\" alt=\"\" width=\"680\" height=\"382\" srcset=\"https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/select-pushbutton2-1.jpg 680w, https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/select-pushbutton2-1-400x225.jpg 400w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><\/div>\n<p>\u0627\u0646\u0642\u0631 \u0628\u0632\u0631 \u0627\u0644\u0645\u0627\u0648\u0633 \u0627\u0644\u0623\u064a\u0645\u0646 \u0641\u0648\u0642 \u0632\u0631 \u0627\u0644\u0636\u063a\u0637\u060c \u0648\u062d\u062f\u062f <strong>Properties<\/strong>. \u0641\u064a \u0646\u0627\u0641\u0630\u0629 \u0627\u0644\u062e\u0635\u0627\u0626\u0635\u060c \u0642\u0645 \u0628\u062a\u063a\u064a\u064a\u0631 Caption \u0625\u0644\u0649 \u0645\u0627 \u062a\u0631\u064a\u062f \u0639\u0631\u0636\u0647 \u0644\u0644\u0645\u0633\u062a\u062e\u062f\u0645. \u0641\u064a \u0647\u0630\u0647 \u0627\u0644\u062d\u0627\u0644\u0629\u060c \u0642\u062f \u064a\u0643\u0648\u0646 <strong>Calculate 5% Tax<\/strong>.<\/p>\n<div><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-32933\" src=\"https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/select-pushbutton3-1.jpg\" alt=\"\" width=\"680\" height=\"455\" srcset=\"https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/select-pushbutton3-1.jpg 680w, https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/select-pushbutton3-1-400x268.jpg 400w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><\/div>\n<p>\u0633\u062a\u0631\u0649 \u0647\u0630\u0627 \u0627\u0644\u0646\u0635 \u0645\u0646\u0639\u0643\u0633\u064b\u0627 \u0639\u0644\u0649 \u0627\u0644\u0632\u0631 \u0646\u0641\u0633\u0647. \u0623\u063a\u0644\u0642 \u0646\u0627\u0641\u0630\u0629 <strong>\u0627\u0644\u062e\u0635\u0627\u0626\u0635<\/strong>\u060c \u0648\u0627\u0646\u0642\u0631 \u0646\u0642\u0631\u064b\u0627 \u0645\u0632\u062f\u0648\u062c\u064b\u0627 \u0639\u0644\u0649 \u0627\u0644\u0632\u0631 \u0646\u0641\u0633\u0647. \u0633\u064a\u0624\u062f\u064a \u0647\u0630\u0627 \u0625\u0644\u0649 \u0641\u062a\u062d \u0646\u0627\u0641\u0630\u0629 \u0645\u062d\u0631\u0631 \u0627\u0644\u062a\u0639\u0644\u064a\u0645\u0627\u062a \u0627\u0644\u0628\u0631\u0645\u062c\u064a\u0629\u060c \u0648\u0633\u064a\u0643\u0648\u0646 \u0627\u0644\u0645\u0624\u0634\u0631 \u062f\u0627\u062e\u0644 \u0627\u0644\u062f\u0627\u0644\u0629 \u0627\u0644\u062a\u064a \u0633\u064a\u062a\u0645 \u062a\u0634\u063a\u064a\u0644\u0647\u0627 \u0639\u0646\u062f\u0645\u0627 \u064a\u0636\u063a\u0637 \u0627\u0644\u0645\u0633\u062a\u062e\u062f\u0645 \u0639\u0644\u0649 \u0627\u0644\u0632\u0631.<\/p>\n<p>\u0627\u0644\u0635\u0642 \u0643\u0648\u062f \u062d\u0633\u0627\u0628 \u0627\u0644\u0636\u0631\u064a\u0628\u0629 \u0645\u0646 \u0627\u0644\u0642\u0633\u0645 \u0623\u0639\u0644\u0627\u0647 \u0641\u064a \u0647\u0630\u0647 \u0627\u0644\u062f\u0627\u0644\u0629\u060c \u0645\u0639 \u0627\u0644\u0625\u0628\u0642\u0627\u0621 \u0639\u0644\u0649 \u0645\u064f\u0636\u0627\u0639\u0650\u0641 \u0645\u0639\u062f\u0644 \u0627\u0644\u0636\u0631\u064a\u0628\u0629 \u0639\u0646\u062f 0.05. \u062a\u0630\u0643\u0631 \u062a\u0636\u0645\u064a\u0646 \u0627\u0644\u0633\u0637\u0631\u064a\u0646 \u0627\u0644\u062a\u0627\u0644\u064a\u064a\u0646 \u0644\u062a\u062d\u062f\u064a\u062f \u0627\u0644\u0648\u0631\u0642\u0629 \u0627\u0644\u0646\u0634\u0637\u0629.<\/p>\n<pre>Dim ws As Worksheet, strFile As String\r\n\r\nSet ws = ActiveWorkbook.Sheets(\"Sheet1\")<\/pre>\n<p>\u0627\u0644\u0622\u0646\u060c \u0643\u0631\u0631 \u0627\u0644\u0639\u0645\u0644\u064a\u0629 \u0645\u0631\u0629 \u0623\u062e\u0631\u0649\u060c \u0648\u0623\u0646\u0634\u0626 \u0632\u0631\u064b\u0627 \u062b\u0627\u0646\u064a\u064b\u0627. \u0627\u062c\u0639\u0644 \u0627\u0644\u062a\u0633\u0645\u064a\u0629 <strong>\u062d\u0633\u0627\u0628 \u0636\u0631\u064a\u0628\u0629 7%<\/strong>.<\/p>\n<div><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-32934\" src=\"https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/creating-second-pushbutton-1.jpg\" alt=\"\" width=\"680\" height=\"417\" srcset=\"https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/creating-second-pushbutton-1.jpg 680w, https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/creating-second-pushbutton-1-400x245.jpg 400w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><\/div>\n<p>\u0627\u0646\u0642\u0631 \u0646\u0642\u0631\u064b\u0627 \u0645\u0632\u062f\u0648\u062c\u064b\u0627 \u0641\u0648\u0642 \u0647\u0630\u0627 \u0627\u0644\u0632\u0631 \u0648\u0627\u0644\u0635\u0642 \u0646\u0641\u0633 \u0627\u0644\u0643\u0648\u062f\u060c \u0648\u0644\u0643\u0646 \u0627\u062c\u0639\u0644 \u0645\u064f\u0636\u0627\u0639\u0650\u0641 \u0627\u0644\u0636\u0631\u064a\u0628\u0629 0.07.<\/p>\n<p>\u0627\u0644\u0622\u0646\u060c \u0628\u0646\u0627\u0621\u064b \u0639\u0644\u0649 \u0627\u0644\u0632\u0631 \u0627\u0644\u0630\u064a \u062a\u0636\u063a\u0637\u0647\u060c \u0633\u064a\u062a\u0645 \u062d\u0633\u0627\u0628 \u0639\u0645\u0648\u062f \u0627\u0644\u0636\u0631\u0627\u0626\u0628 \u0648\u0641\u0642\u064b\u0627 \u0644\u0630\u0644\u0643.<\/p>\n<div><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-32935\" src=\"https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/pushbutton-code-1.jpg\" alt=\"\" width=\"680\" height=\"423\" srcset=\"https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/pushbutton-code-1.jpg 680w, https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/pushbutton-code-1-400x249.jpg 400w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><\/div>\n<p>\u0628\u0645\u062c\u0631\u062f \u0627\u0644\u0627\u0646\u062a\u0647\u0627\u0621\u060c \u0633\u064a\u0643\u0648\u0646 \u0644\u062f\u064a\u0643 \u0643\u0644\u0627 \u0627\u0644\u0632\u0631\u064a\u0646 \u0639\u0644\u0649 \u0648\u0631\u0642\u062a\u0643. \u0633\u064a\u0642\u0648\u0645 \u0643\u0644 \u0645\u0646\u0647\u0645\u0627 \u0628\u0628\u062f\u0621 \u062d\u0633\u0627\u0628 \u0636\u0631\u064a\u0628\u064a \u0645\u062e\u062a\u0644\u0641 \u0648\u0633\u064a\u0643\u062a\u0628 \u0646\u062a\u0627\u0626\u062c \u0645\u062e\u062a\u0644\u0641\u0629 \u0641\u064a \u0639\u0645\u0648\u062f \u0627\u0644\u0646\u062a\u0627\u0626\u062c.<\/p>\n<p>\u0644\u0627\u062e\u062a\u0628\u0627\u0631 \u0630\u0644\u0643\u060c \u062d\u062f\u062f \u0642\u0627\u0626\u0645\u0629 <strong>\u0627\u0644\u0645\u0637\u0648\u0631<\/strong>\u060c \u0648\u062d\u062f\u062f <strong>\u0648\u0636\u0639 \u0627\u0644\u062a\u0635\u0645\u064a\u0645<\/strong> \u0645\u0646 \u0645\u062c\u0645\u0648\u0639\u0629 \u0639\u0646\u0627\u0635\u0631 \u0627\u0644\u062a\u062d\u0643\u0645 \u0641\u064a \u0627\u0644\u0634\u0631\u064a\u0637 \u0644\u062a\u0639\u0637\u064a\u0644 <strong>\u0648\u0636\u0639 \u0627\u0644\u062a\u0635\u0645\u064a\u0645<\/strong>. \u0633\u064a\u0624\u062f\u064a \u0647\u0630\u0627 \u0625\u0644\u0649 \u062a\u0646\u0634\u064a\u0637 \u0627\u0644\u0623\u0632\u0631\u0627\u0631.<\/p>\n<p>\u062d\u0627\u0648\u0644 \u062a\u062d\u062f\u064a\u062f \u0643\u0644 \u0632\u0631 \u0644\u0645\u0639\u0631\u0641\u0629 \u0643\u064a\u0641 \u064a\u062a\u063a\u064a\u0631 \u0639\u0645\u0648\u062f \u0646\u062a\u0627\u0626\u062c &#8220;\u0627\u0644\u0636\u0631\u0627\u0626\u0628&#8221;.<\/p>\n<h4><strong>\u0625\u0631\u0633\u0627\u0644 \u0646\u062a\u0627\u0626\u062c \u0627\u0644\u062d\u0633\u0627\u0628 \u0628\u0627\u0644\u0628\u0631\u064a\u062f \u0627\u0644\u0625\u0644\u0643\u062a\u0631\u0648\u0646\u064a \u0625\u0644\u0649 \u0634\u062e\u0635 \u0645\u0627<\/strong><\/h4>\n<p>\u0645\u0627\u0630\u0627 \u0644\u0648 \u0643\u0646\u062a \u062a\u0631\u064a\u062f \u0625\u0631\u0633\u0627\u0644 \u0627\u0644\u0646\u062a\u0627\u0626\u062c \u0627\u0644\u0645\u0648\u062c\u0648\u062f\u0629 \u0641\u064a \u062c\u062f\u0648\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0625\u0644\u0649 \u0634\u062e\u0635 \u0645\u0627 \u0639\u0628\u0631 \u0627\u0644\u0628\u0631\u064a\u062f \u0627\u0644\u0625\u0644\u0643\u062a\u0631\u0648\u0646\u064a\u061f<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-32936\" src=\"https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/enabling-cdo-reference-1.jpg\" alt=\"\" width=\"680\" height=\"417\" srcset=\"https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/enabling-cdo-reference-1.jpg 680w, https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/enabling-cdo-reference-1-400x245.jpg 400w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><\/p>\n<p>\u064a\u0645\u0643\u0646\u0643 \u0625\u0646\u0634\u0627\u0621 \u0632\u0631 \u0622\u062e\u0631 \u064a\u0633\u0645\u0649 <strong>Email Sheet to Boss<\/strong> \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0646\u0641\u0633 \u0627\u0644\u0625\u062c\u0631\u0627\u0621 \u0627\u0644\u0645\u0630\u0643\u0648\u0631 \u0623\u0639\u0644\u0627\u0647. \u0633\u064a\u062a\u0636\u0645\u0646 \u0631\u0645\u0632 \u0647\u0630\u0627 \u0627\u0644\u0632\u0631 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0643\u0627\u0626\u0646 Excel CDO \u0644\u062a\u0643\u0648\u064a\u0646 \u0625\u0639\u062f\u0627\u062f\u0627\u062a \u0627\u0644\u0628\u0631\u064a\u062f \u0627\u0644\u0625\u0644\u0643\u062a\u0631\u0648\u0646\u064a SMTP\u060c \u0648\u0625\u0631\u0633\u0627\u0644 \u0627\u0644\u0646\u062a\u0627\u0626\u062c \u0628\u0627\u0644\u0628\u0631\u064a\u062f \u0627\u0644\u0625\u0644\u0643\u062a\u0631\u0648\u0646\u064a \u0628\u062a\u0646\u0633\u064a\u0642 \u0633\u0647\u0644 \u0627\u0644\u0642\u0631\u0627\u0621\u0629 \u0644\u0644\u0645\u0633\u062a\u062e\u062f\u0645.<\/p>\n<p>\u0644\u062a\u0645\u0643\u064a\u0646 \u0647\u0630\u0647 \u0627\u0644\u0645\u064a\u0632\u0629\u060c \u062a\u062d\u062a\u0627\u062c \u0625\u0644\u0649 \u062a\u062d\u062f\u064a\u062f <strong>Tools and References<\/strong>. \u0642\u0645 \u0628\u0627\u0644\u062a\u0645\u0631\u064a\u0631 \u0644\u0623\u0633\u0641\u0644 \u0625\u0644\u0649 <strong>Microsoft CDO for Windows 2000 Library<\/strong>\u060c \u0648\u0642\u0645 \u0628\u062a\u0645\u0643\u064a\u0646\u0647\u060c \u0648\u062d\u062f\u062f <strong>OK<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-32937\" src=\"https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/image-bffd033229d1f6dd0a264b5f6774a24a-1.jpg\" alt=\"\" width=\"680\" height=\"417\" srcset=\"https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/image-bffd033229d1f6dd0a264b5f6774a24a-1.jpg 680w, https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/image-bffd033229d1f6dd0a264b5f6774a24a-1-400x245.jpg 400w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><\/p>\n<p>\u0647\u0646\u0627\u0643 \u062b\u0644\u0627\u062b\u0629 \u0623\u0642\u0633\u0627\u0645 \u0631\u0626\u064a\u0633\u064a\u0629 \u0644\u0644\u062a\u0639\u0644\u064a\u0645\u0627\u062a \u0627\u0644\u0628\u0631\u0645\u062c\u064a\u0629 \u0627\u0644\u062a\u064a \u062a\u062d\u062a\u0627\u062c \u0625\u0644\u0649 \u0625\u0646\u0634\u0627\u0626\u0647\u0627 \u0644\u0625\u0631\u0633\u0627\u0644 \u0628\u0631\u064a\u062f \u0625\u0644\u0643\u062a\u0631\u0648\u0646\u064a \u0648\u062a\u0636\u0645\u064a\u0646 \u0646\u062a\u0627\u0626\u062c \u062c\u062f\u0648\u0644 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a.<\/p>\n<p>\u0627\u0644\u0623\u0648\u0644 \u0647\u0648 \u0625\u0639\u062f\u0627\u062f \u0645\u062a\u063a\u064a\u0631\u0627\u062a \u0644\u0644\u0627\u062d\u062a\u0641\u0627\u0638 \u0628\u0627\u0644\u0645\u0648\u0636\u0648\u0639 \u0648\u0639\u0646\u0627\u0648\u064a\u0646 &#8220;\u0625\u0644\u0649&#8221; \u0648 &#8220;\u0645\u0646&#8221; \u0648\u0646\u0635 \u0627\u0644\u0628\u0631\u064a\u062f \u0627\u0644\u0625\u0644\u0643\u062a\u0631\u0648\u0646\u064a.<\/p>\n<pre>Dim CDO_Mail As Object\r\nDim CDO_Config As Object\r\nDim SMTP_Config As Variant\r\nDim strSubject As String\r\nDim strFrom As String\r\nDim strTo As String\r\nDim strCc As String\r\nDim strBcc As String\r\nDim strBody As String\r\nDim LastRow As Long\r\nDim StartCell As Range\r\nDim rowCounter As Integer\r\nDim rng As Range, cell As Range\r\nDim fltTax As Double<\/pre>\n<pre>Set ws = ActiveWorkbook.Sheets(\"Sheet1\")\r\nstrSubject = \"Taxes Paid This Quarter\"\r\nstrFrom = \"MyEmail@gmail.com\"\r\nstrTo = \"BossEmail@gmail.com\"\r\nstrCc = \"\"\r\nstrBcc = \"\"\r\nstrBody = \"The following is the breakdown of taxes paid on sales this quarter.\"<\/pre>\n<p>\u0628\u0627\u0644\u0637\u0628\u0639\u060c \u064a\u062c\u0628 \u0623\u0646 \u064a\u0643\u0648\u0646 \u0627\u0644\u0646\u0635 \u062f\u064a\u0646\u0627\u0645\u064a\u0643\u064a\u064b\u0627 \u0627\u0639\u062a\u0645\u0627\u062f\u064b\u0627 \u0639\u0644\u0649 \u0627\u0644\u0646\u062a\u0627\u0626\u062c \u0627\u0644\u0645\u0648\u062c\u0648\u062f\u0629 \u0641\u064a \u0627\u0644\u0648\u0631\u0642\u0629\u060c \u0644\u0630\u0644\u0643 \u0633\u062a\u062d\u062a\u0627\u062c \u0647\u0646\u0627 \u0625\u0644\u0649 \u0625\u0636\u0627\u0641\u0629 \u062d\u0644\u0642\u0629 \u062a\u0645\u0631 \u0639\u0628\u0631 \u0627\u0644\u0646\u0637\u0627\u0642 \u0648\u062a\u0633\u062a\u062e\u0631\u062c \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u062a\u0643\u062a\u0628 \u0633\u0637\u0631\u064b\u0627 \u0641\u064a \u0643\u0644 \u0645\u0631\u0629 \u0641\u064a \u0627\u0644\u0646\u0635.<\/p>\n<pre>Set StartCell = Range(\"A1\")\r\n\r\n'Find Last Row and Column\r\nLastRow = ws.Cells(ws.Rows.Count, StartCell.Column).End(xlUp).Row\r\nSet rng = ws.Range(ws.Cells(2, 4), ws.Cells(LastRow, 4))\r\n\r\nrowCounter = 2\r\nstrBody = strBody &amp; vbCrLf\r\n\r\nFor Each cell In rng\r\n     strBody = strBody &amp; vbCrLf\r\n     strBody = strBody &amp; \"We sold \" &amp; Cells(rowCounter, 3).Value &amp; \" of \" &amp; Cells(rowCounter, 1).Value _\r\n     &amp; \" for \" &amp; Cells(rowCounter, 4).Value &amp; \" and paid taxes of \" &amp; Cells(rowCounter, 5).Value &amp; \".\"\r\n     rowCounter = rowCounter + 1\r\nNext cell<\/pre>\n<p>\u064a\u062a\u0636\u0645\u0646 \u0627\u0644\u0642\u0633\u0645 \u0627\u0644\u062a\u0627\u0644\u064a \u0625\u0639\u062f\u0627\u062f \u0625\u0639\u062f\u0627\u062f\u0627\u062a SMTP \u0628\u062d\u064a\u062b \u064a\u0645\u0643\u0646\u0643 \u0625\u0631\u0633\u0627\u0644 \u0628\u0631\u064a\u062f \u0625\u0644\u0643\u062a\u0631\u0648\u0646\u064a \u0645\u0646 \u062e\u0644\u0627\u0644 \u062e\u0627\u062f\u0645 SMTP \u0627\u0644\u062e\u0627\u0635 \u0628\u0643. \u0625\u0630\u0627 \u0643\u0646\u062a \u062a\u0633\u062a\u062e\u062f\u0645 Gmail\u060c \u0641\u0639\u0627\u062f\u0629\u064b \u0645\u0627 \u064a\u0643\u0648\u0646 \u0647\u0630\u0627 \u0647\u0648 \u0639\u0646\u0648\u0627\u0646 \u0628\u0631\u064a\u062f\u0643 \u0627\u0644\u0625\u0644\u0643\u062a\u0631\u0648\u0646\u064a \u0641\u064a Gmail \u0648\u0643\u0644\u0645\u0629 \u0645\u0631\u0648\u0631 Gmail \u0648\u062e\u0627\u062f\u0645 Gmail SMTP \u200f(smtp.gmail.com).<\/p>\n<pre>Set CDO_Mail = CreateObject(\"CDO.Message\") \r\nOn Error GoTo Error_Handling\r\nSet CDO_Config = CreateObject(\"CDO.Configuration\")\r\nCDO_Config.Load -1\r\nSet SMTP_Config = CDO_Config.Fields\r\n\r\nWith SMTP_Config\r\n.Item(\"http:\/\/schemas.microsoft.com\/cdo\/configuration\/sendusing\") = 2\r\n.Item(\"http:\/\/schemas.microsoft.com\/cdo\/configuration\/smtpserver\") = \"smtp.gmail.com\"\r\n.Item(\"http:\/\/schemas.microsoft.com\/cdo\/configuration\/smtpauthenticate\") = 1\r\n.Item(\"http:\/\/schemas.microsoft.com\/cdo\/configuration\/sendusername\") = \"email@website.com\"\r\n.Item(\"http:\/\/schemas.microsoft.com\/cdo\/configuration\/sendpassword\") = \"password\"\r\n.Item(\"http:\/\/schemas.microsoft.com\/cdo\/configuration\/smtpserverport\") = 465\r\n.Item(\"http:\/\/schemas.microsoft.com\/cdo\/configuration\/smtpusessl\") = True\r\n\u00a0.Update\r\nEnd With\r\n\r\nWith CDO_Mail\r\n     Set .Configuration = CDO_Config\r\nEnd With<\/pre>\n<p>\u0627\u0633\u062a\u0628\u062f\u0644 <a href=\"mailto:email@website.com\">email@website.com<\/a> \u0648\u0643\u0644\u0645\u0629 \u0627\u0644\u0645\u0631\u0648\u0631 \u0628\u062a\u0641\u0627\u0635\u064a\u0644 \u062d\u0633\u0627\u0628\u0643 \u0627\u0644\u062e\u0627\u0635.<\/p>\n<p>\u0623\u062e\u064a\u0631\u064b\u0627\u060c \u0644\u0628\u062f\u0621 \u0625\u0631\u0633\u0627\u0644 \u0627\u0644\u0628\u0631\u064a\u062f \u0627\u0644\u0625\u0644\u0643\u062a\u0631\u0648\u0646\u064a\u060c \u0623\u062f\u062e\u0644 \u0627\u0644\u0643\u0648\u062f \u0627\u0644\u062a\u0627\u0644\u064a.<\/p>\n<pre>CDO_Mail.Subject = strSubject\r\nCDO_Mail.From = strFrom\r\nCDO_Mail.To = strTo\r\nCDO_Mail.TextBody = strBody\r\nCDO_Mail.CC = strCc\r\nCDO_Mail.BCC = strBcc\r\nCDO_Mail.Send\r\n\r\nError_Handling:\r\nIf Err.Description &lt;&gt; \"\" Then MsgBox Err.Description<\/pre>\n<p><strong>\u0645\u0644\u0627\u062d\u0638\u0629<\/strong>: \u0625\u0630\u0627 \u0631\u0623\u064a\u062a \u062e\u0637\u0623 \u0641\u064a \u0627\u0644\u0646\u0642\u0644 \u0639\u0646\u062f \u0645\u062d\u0627\u0648\u0644\u0629 \u062a\u0634\u063a\u064a\u0644 \u0647\u0630\u0627 \u0627\u0644\u0643\u0648\u062f\u060c \u0641\u0645\u0646 \u0627\u0644\u0645\u062d\u062a\u0645\u0644 \u0623\u0646 \u064a\u0643\u0648\u0646 \u062d\u0633\u0627\u0628\u0643 \u0641\u064a Google \u064a\u0645\u0646\u0639 \u062a\u0634\u063a\u064a\u0644 &#8220;\u0627\u0644\u062a\u0637\u0628\u064a\u0642\u0627\u062a \u0627\u0644\u0623\u0642\u0644 \u0623\u0645\u0627\u0646\u064b\u0627&#8221;. \u0633\u062a\u062d\u062a\u0627\u062c \u0625\u0644\u0649 \u0632\u064a\u0627\u0631\u0629 <a href=\"https:\/\/myaccount.google.com\/lesssecureapps\" target=\"_blank\" rel=\"noopener noreferrer\">\u0635\u0641\u062d\u0629 \u0625\u0639\u062f\u0627\u062f\u0627\u062a \u0627\u0644\u062a\u0637\u0628\u064a\u0642\u0627\u062a \u0627\u0644\u0623\u0642\u0644 \u0623\u0645\u0627\u0646\u064b\u0627<\/a> \u0648\u062a\u0634\u063a\u064a\u0644 \u0647\u0630\u0627 \u0627\u0644\u062e\u064a\u0627\u0631.<\/p>\n<p>\u0628\u0639\u062f \u062a\u0645\u0643\u064a\u0646 \u0630\u0644\u0643\u060c \u0633\u064a\u062a\u0645 \u0625\u0631\u0633\u0627\u0644 \u0628\u0631\u064a\u062f\u0643 \u0627\u0644\u0625\u0644\u0643\u062a\u0631\u0648\u0646\u064a. \u0647\u0630\u0627 \u0645\u0627 \u064a\u0628\u062f\u0648 \u0639\u0644\u064a\u0647 \u0627\u0644\u0623\u0645\u0631 \u0628\u0627\u0644\u0646\u0633\u0628\u0629 \u0644\u0644\u0634\u062e\u0635 \u0627\u0644\u0630\u064a \u064a\u062a\u0644\u0642\u0649 \u0628\u0631\u064a\u062f\u0643 \u0627\u0644\u0625\u0644\u0643\u062a\u0631\u0648\u0646\u064a \u0627\u0644\u0630\u064a \u062a\u0645 \u0625\u0646\u0634\u0627\u0624\u0647 \u062a\u0644\u0642\u0627\u0626\u064a\u064b\u0627.<\/p>\n<div><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-32938\" src=\"https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/results-email-1.jpg\" alt=\"\" width=\"680\" height=\"333\" srcset=\"https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/results-email-1.jpg 680w, https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/results-email-1-400x196.jpg 400w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><\/div>\n<p>\u0643\u0645\u0627 \u062a\u0631\u0649\u060c \u0647\u0646\u0627\u0643 \u0627\u0644\u0643\u062b\u064a\u0631 \u0645\u0645\u0627 \u064a\u0645\u0643\u0646\u0643 \u0623\u062a\u0645\u062a\u062a\u0647 \u0641\u0639\u0644\u064a\u064b\u0627 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 Excel VBA. \u062d\u0627\u0648\u0644 \u0627\u0644\u0644\u0639\u0628 \u0628\u0645\u0642\u062a\u0637\u0641\u0627\u062a \u0627\u0644\u062a\u0639\u0644\u064a\u0645\u0627\u062a \u0627\u0644\u0628\u0631\u0645\u062c\u064a\u0629 \u0627\u0644\u062a\u064a \u062a\u0639\u0644\u0645\u062a\u0647\u0627 \u0641\u064a \u0647\u0630\u0647 \u0627\u0644\u0645\u0642\u0627\u0644\u0629 \u0648\u0623\u0646\u0634\u0626 \u0639\u0645\u0644\u064a\u0627\u062a \u0623\u062a\u0645\u062a\u0629 VBA \u0641\u0631\u064a\u062f\u0629 \u062e\u0627\u0635\u0629 \u0628\u0643.<\/p>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u0625\u0630\u0627 \u0643\u0646\u062a \u0642\u062f \u0628\u062f\u0623\u062a \u0644\u0644\u062a\u0648 \u0641\u064a \u0627\u0633\u062a\u062e\u062f\u0627\u0645 VBA\u060c \u0641\u0633\u062a\u062d\u062a\u0627\u062c \u0625\u0644\u0649 \u0627\u0644\u0628\u062f\u0621 \u0628\u062f\u0631\u0627\u0633\u0629 \u062f\u0644\u064a\u0644 VBA \u0644\u0644\u0645\u0628\u062a\u062f\u0626\u064a\u0646. \u0648\u0644\u0643\u0646 \u0625\u0630\u0627 \u0643\u0646\u062a \u062e\u0628\u064a\u0631\u064b\u0627 \u0645\u062a\u0645\u0631\u0633\u064b\u0627 \u0641\u064a VBA \u0648\u062a\u0628\u062d\u062b \u0639\u0646 \u0623\u0634\u064a\u0627\u0621 \u0623\u0643\u062b\u0631 \u062a\u0642\u062f\u0645\u064b\u0627 \u064a\u0645\u0643\u0646\u0643 \u0627\u0644\u0642\u064a\u0627\u0645 \u0628\u0647\u0627 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 VBA \u0641\u064a Excel\u060c \u0641\u0627\u0633\u062a\u0645\u0631 \u0641\u064a \u0627\u0644\u0642\u0631\u0627\u0621\u0629. \u062a\u062a\u064a\u062d \u0644\u0643 \u0627\u0644\u0642\u062f\u0631\u0629 \u0639\u0644\u0649 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u062a\u0631\u0645\u064a\u0632 VBA \u0641\u064a Excel \u0639\u0627\u0644\u0645\u064b\u0627 \u0643\u0627\u0645\u0644\u0627\u064b \u0645\u0646 \u0627\u0644\u0623\u062a\u0645\u062a\u0629. \u064a\u0645\u0643\u0646\u0643 \u0623\u062a\u0645\u062a\u0629 \u0627\u0644\u0639\u0645\u0644\u064a\u0627\u062a \u0627\u0644\u062d\u0633\u0627\u0628\u064a\u0629 \u0641\u064a [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":32939,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[71],"class_list":["post-32926","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tech","tag-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u062f\u0644\u064a\u0644 VBA \u0645\u062a\u0642\u062f\u0645 \u0644\u0640 MS Excel: \u0627\u062d\u062a\u0631\u0627\u0641 \u0627\u0644\u0623\u062a\u0645\u062a\u0629<\/title>\n<meta name=\"description\" content=\"\u0625\u0630\u0627 \u0643\u0646\u062a \u0642\u062f \u0628\u062f\u0623\u062a \u0644\u0644\u062a\u0648 \u0641\u064a \u0627\u0633\u062a\u062e\u062f\u0627\u0645 VBA\u060c \u0641\u0633\u062a\u062d\u062a\u0627\u062c \u0625\u0644\u0649 \u0627\u0644\u0628\u062f\u0621 \u0628\u062f\u0631\u0627\u0633\u0629 \u062f\u0644\u064a\u0644 VBA \u0644\u0644\u0645\u0628\u062a\u062f\u0626\u064a\u0646. \u0648\u0644\u0643\u0646 \u0625\u0630\u0627 \u0643\u0646\u062a \u062e\u0628\u064a\u0631\u064b\u0627 \u0645\u062a\u0645\u0631\u0633\u064b\u0627 \u0641\u064a VBA \u0648\u062a\u0628\u062d\u062b \u0639\u0646 \u0623\u0634\u064a\u0627\u0621 \u0623\u0643\u062b\u0631 \u062a\u0642\u062f\u0645\u064b\u0627 \u064a\u0645\u0643\u0646\u0643\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dztecs.com\/tech\/an-advanced-vba-guide-for-ms-excel-mastering-automation\/\" \/>\n<meta property=\"og:locale\" content=\"ar_AR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u062f\u0644\u064a\u0644 VBA \u0645\u062a\u0642\u062f\u0645 \u0644\u0640 MS Excel: \u0627\u062d\u062a\u0631\u0627\u0641 \u0627\u0644\u0623\u062a\u0645\u062a\u0629\" \/>\n<meta property=\"og:description\" content=\"\u0625\u0630\u0627 \u0643\u0646\u062a \u0642\u062f \u0628\u062f\u0623\u062a \u0644\u0644\u062a\u0648 \u0641\u064a \u0627\u0633\u062a\u062e\u062f\u0627\u0645 VBA\u060c \u0641\u0633\u062a\u062d\u062a\u0627\u062c \u0625\u0644\u0649 \u0627\u0644\u0628\u062f\u0621 \u0628\u062f\u0631\u0627\u0633\u0629 \u062f\u0644\u064a\u0644 VBA \u0644\u0644\u0645\u0628\u062a\u062f\u0626\u064a\u0646. \u0648\u0644\u0643\u0646 \u0625\u0630\u0627 \u0643\u0646\u062a \u062e\u0628\u064a\u0631\u064b\u0627 \u0645\u062a\u0645\u0631\u0633\u064b\u0627 \u0641\u064a VBA \u0648\u062a\u0628\u062d\u062b \u0639\u0646 \u0623\u0634\u064a\u0627\u0621 \u0623\u0643\u062b\u0631 \u062a\u0642\u062f\u0645\u064b\u0627 \u064a\u0645\u0643\u0646\u0643\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dztecs.com\/tech\/an-advanced-vba-guide-for-ms-excel-mastering-automation\/\" \/>\n<meta property=\"og:site_name\" content=\"DzTecnium - Tech\" \/>\n<meta property=\"article:published_time\" content=\"2026-03-06T17:07:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/excel-2.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"680\" \/>\n\t<meta property=\"og:image:height\" content=\"454\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Merwan Redha\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dztecs.com\\\/tech\\\/an-advanced-vba-guide-for-ms-excel-mastering-automation\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dztecs.com\\\/tech\\\/an-advanced-vba-guide-for-ms-excel-mastering-automation\\\/\"},\"author\":{\"name\":\"Merwan Redha\",\"@id\":\"https:\\\/\\\/www.dztecs.com\\\/tech\\\/#\\\/schema\\\/person\\\/59a97dbd6d9c9caf88143cdf518d435b\"},\"headline\":\"\u062f\u0644\u064a\u0644 VBA \u0645\u062a\u0642\u062f\u0645 \u0644\u0640 MS Excel: \u0627\u062d\u062a\u0631\u0627\u0641 \u0627\u0644\u0623\u062a\u0645\u062a\u0629\",\"datePublished\":\"2026-03-06T17:07:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dztecs.com\\\/tech\\\/an-advanced-vba-guide-for-ms-excel-mastering-automation\\\/\"},\"wordCount\":94,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dztecs.com\\\/tech\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dztecs.com\\\/tech\\\/an-advanced-vba-guide-for-ms-excel-mastering-automation\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dztecs.com\\\/tech\\\/wp-content\\\/uploads\\\/sites\\\/10\\\/2026\\\/03\\\/excel-2.jpeg\",\"keywords\":[\"Excel\"],\"articleSection\":[\"\u062a\u0642\u0646\u064a\u0629\"],\"inLanguage\":\"ar\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dztecs.com\\\/tech\\\/an-advanced-vba-guide-for-ms-excel-mastering-automation\\\/\",\"url\":\"https:\\\/\\\/www.dztecs.com\\\/tech\\\/an-advanced-vba-guide-for-ms-excel-mastering-automation\\\/\",\"name\":\"\u062f\u0644\u064a\u0644 VBA \u0645\u062a\u0642\u062f\u0645 \u0644\u0640 MS Excel: \u0627\u062d\u062a\u0631\u0627\u0641 \u0627\u0644\u0623\u062a\u0645\u062a\u0629\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dztecs.com\\\/tech\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dztecs.com\\\/tech\\\/an-advanced-vba-guide-for-ms-excel-mastering-automation\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dztecs.com\\\/tech\\\/an-advanced-vba-guide-for-ms-excel-mastering-automation\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dztecs.com\\\/tech\\\/wp-content\\\/uploads\\\/sites\\\/10\\\/2026\\\/03\\\/excel-2.jpeg\",\"datePublished\":\"2026-03-06T17:07:38+00:00\",\"description\":\"\u0625\u0630\u0627 \u0643\u0646\u062a \u0642\u062f \u0628\u062f\u0623\u062a \u0644\u0644\u062a\u0648 \u0641\u064a \u0627\u0633\u062a\u062e\u062f\u0627\u0645 VBA\u060c \u0641\u0633\u062a\u062d\u062a\u0627\u062c \u0625\u0644\u0649 \u0627\u0644\u0628\u062f\u0621 \u0628\u062f\u0631\u0627\u0633\u0629 \u062f\u0644\u064a\u0644 VBA \u0644\u0644\u0645\u0628\u062a\u062f\u0626\u064a\u0646. \u0648\u0644\u0643\u0646 \u0625\u0630\u0627 \u0643\u0646\u062a \u062e\u0628\u064a\u0631\u064b\u0627 \u0645\u062a\u0645\u0631\u0633\u064b\u0627 \u0641\u064a VBA \u0648\u062a\u0628\u062d\u062b \u0639\u0646 \u0623\u0634\u064a\u0627\u0621 \u0623\u0643\u062b\u0631 \u062a\u0642\u062f\u0645\u064b\u0627 \u064a\u0645\u0643\u0646\u0643\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dztecs.com\\\/tech\\\/an-advanced-vba-guide-for-ms-excel-mastering-automation\\\/#breadcrumb\"},\"inLanguage\":\"ar\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dztecs.com\\\/tech\\\/an-advanced-vba-guide-for-ms-excel-mastering-automation\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ar\",\"@id\":\"https:\\\/\\\/www.dztecs.com\\\/tech\\\/an-advanced-vba-guide-for-ms-excel-mastering-automation\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dztecs.com\\\/tech\\\/wp-content\\\/uploads\\\/sites\\\/10\\\/2026\\\/03\\\/excel-2.jpeg\",\"contentUrl\":\"https:\\\/\\\/www.dztecs.com\\\/tech\\\/wp-content\\\/uploads\\\/sites\\\/10\\\/2026\\\/03\\\/excel-2.jpeg\",\"width\":680,\"height\":454},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dztecs.com\\\/tech\\\/an-advanced-vba-guide-for-ms-excel-mastering-automation\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0627\u0644\u0631\u0626\u064a\u0633\u064a\u0629\",\"item\":\"https:\\\/\\\/www.dztecs.com\\\/tech\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u062f\u0644\u064a\u0644 VBA \u0645\u062a\u0642\u062f\u0645 \u0644\u0640 MS Excel: \u0627\u062d\u062a\u0631\u0627\u0641 \u0627\u0644\u0623\u062a\u0645\u062a\u0629\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dztecs.com\\\/tech\\\/#website\",\"url\":\"https:\\\/\\\/www.dztecs.com\\\/tech\\\/\",\"name\":\"DzTecnium\",\"description\":\"\u0623\u062d\u062f\u062b \u0627\u0644\u0627\u0628\u062a\u0643\u0627\u0631\u0627\u062a \u0648\u0627\u0644\u0623\u062e\u0628\u0627\u0631 \u0627\u0644\u0639\u0645\u064a\u0642\u0629 \u0644\u0646\u064f\u0628\u0642\u064a\u0643 \u062f\u0627\u0626\u0645\u064b\u0627 \u0641\u064a \u0642\u0644\u0628 \u0639\u0627\u0644\u0645 \u0627\u0644\u062a\u0643\u0646\u0648\u0644\u0648\u062c\u064a\u0627\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dztecs.com\\\/tech\\\/#organization\"},\"alternateName\":\"DzT\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dztecs.com\\\/tech\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ar\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dztecs.com\\\/tech\\\/#organization\",\"name\":\"DzTecnium\",\"alternateName\":\"DzT\",\"url\":\"https:\\\/\\\/www.dztecs.com\\\/tech\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ar\",\"@id\":\"https:\\\/\\\/www.dztecs.com\\\/tech\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"DzTecnium\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dztecs.com\\\/tech\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dztecs.com\\\/tech\\\/#\\\/schema\\\/person\\\/59a97dbd6d9c9caf88143cdf518d435b\",\"name\":\"Merwan Redha\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ar\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0a82f61bfa1524addeafcec656a281240151801382761444468f50033fcb0af3?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0a82f61bfa1524addeafcec656a281240151801382761444468f50033fcb0af3?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0a82f61bfa1524addeafcec656a281240151801382761444468f50033fcb0af3?s=96&d=mm&r=g\",\"caption\":\"Merwan Redha\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u062f\u0644\u064a\u0644 VBA \u0645\u062a\u0642\u062f\u0645 \u0644\u0640 MS Excel: \u0627\u062d\u062a\u0631\u0627\u0641 \u0627\u0644\u0623\u062a\u0645\u062a\u0629","description":"\u0625\u0630\u0627 \u0643\u0646\u062a \u0642\u062f \u0628\u062f\u0623\u062a \u0644\u0644\u062a\u0648 \u0641\u064a \u0627\u0633\u062a\u062e\u062f\u0627\u0645 VBA\u060c \u0641\u0633\u062a\u062d\u062a\u0627\u062c \u0625\u0644\u0649 \u0627\u0644\u0628\u062f\u0621 \u0628\u062f\u0631\u0627\u0633\u0629 \u062f\u0644\u064a\u0644 VBA \u0644\u0644\u0645\u0628\u062a\u062f\u0626\u064a\u0646. \u0648\u0644\u0643\u0646 \u0625\u0630\u0627 \u0643\u0646\u062a \u062e\u0628\u064a\u0631\u064b\u0627 \u0645\u062a\u0645\u0631\u0633\u064b\u0627 \u0641\u064a VBA \u0648\u062a\u0628\u062d\u062b \u0639\u0646 \u0623\u0634\u064a\u0627\u0621 \u0623\u0643\u062b\u0631 \u062a\u0642\u062f\u0645\u064b\u0627 \u064a\u0645\u0643\u0646\u0643","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dztecs.com\/tech\/an-advanced-vba-guide-for-ms-excel-mastering-automation\/","og_locale":"ar_AR","og_type":"article","og_title":"\u062f\u0644\u064a\u0644 VBA \u0645\u062a\u0642\u062f\u0645 \u0644\u0640 MS Excel: \u0627\u062d\u062a\u0631\u0627\u0641 \u0627\u0644\u0623\u062a\u0645\u062a\u0629","og_description":"\u0625\u0630\u0627 \u0643\u0646\u062a \u0642\u062f \u0628\u062f\u0623\u062a \u0644\u0644\u062a\u0648 \u0641\u064a \u0627\u0633\u062a\u062e\u062f\u0627\u0645 VBA\u060c \u0641\u0633\u062a\u062d\u062a\u0627\u062c \u0625\u0644\u0649 \u0627\u0644\u0628\u062f\u0621 \u0628\u062f\u0631\u0627\u0633\u0629 \u062f\u0644\u064a\u0644 VBA \u0644\u0644\u0645\u0628\u062a\u062f\u0626\u064a\u0646. \u0648\u0644\u0643\u0646 \u0625\u0630\u0627 \u0643\u0646\u062a \u062e\u0628\u064a\u0631\u064b\u0627 \u0645\u062a\u0645\u0631\u0633\u064b\u0627 \u0641\u064a VBA \u0648\u062a\u0628\u062d\u062b \u0639\u0646 \u0623\u0634\u064a\u0627\u0621 \u0623\u0643\u062b\u0631 \u062a\u0642\u062f\u0645\u064b\u0627 \u064a\u0645\u0643\u0646\u0643","og_url":"https:\/\/www.dztecs.com\/tech\/an-advanced-vba-guide-for-ms-excel-mastering-automation\/","og_site_name":"DzTecnium - Tech","article_published_time":"2026-03-06T17:07:38+00:00","og_image":[{"width":680,"height":454,"url":"https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/excel-2.jpeg","type":"image\/jpeg"}],"author":"Merwan Redha","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dztecs.com\/tech\/an-advanced-vba-guide-for-ms-excel-mastering-automation\/#article","isPartOf":{"@id":"https:\/\/www.dztecs.com\/tech\/an-advanced-vba-guide-for-ms-excel-mastering-automation\/"},"author":{"name":"Merwan Redha","@id":"https:\/\/www.dztecs.com\/tech\/#\/schema\/person\/59a97dbd6d9c9caf88143cdf518d435b"},"headline":"\u062f\u0644\u064a\u0644 VBA \u0645\u062a\u0642\u062f\u0645 \u0644\u0640 MS Excel: \u0627\u062d\u062a\u0631\u0627\u0641 \u0627\u0644\u0623\u062a\u0645\u062a\u0629","datePublished":"2026-03-06T17:07:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dztecs.com\/tech\/an-advanced-vba-guide-for-ms-excel-mastering-automation\/"},"wordCount":94,"publisher":{"@id":"https:\/\/www.dztecs.com\/tech\/#organization"},"image":{"@id":"https:\/\/www.dztecs.com\/tech\/an-advanced-vba-guide-for-ms-excel-mastering-automation\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/excel-2.jpeg","keywords":["Excel"],"articleSection":["\u062a\u0642\u0646\u064a\u0629"],"inLanguage":"ar"},{"@type":"WebPage","@id":"https:\/\/www.dztecs.com\/tech\/an-advanced-vba-guide-for-ms-excel-mastering-automation\/","url":"https:\/\/www.dztecs.com\/tech\/an-advanced-vba-guide-for-ms-excel-mastering-automation\/","name":"\u062f\u0644\u064a\u0644 VBA \u0645\u062a\u0642\u062f\u0645 \u0644\u0640 MS Excel: \u0627\u062d\u062a\u0631\u0627\u0641 \u0627\u0644\u0623\u062a\u0645\u062a\u0629","isPartOf":{"@id":"https:\/\/www.dztecs.com\/tech\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dztecs.com\/tech\/an-advanced-vba-guide-for-ms-excel-mastering-automation\/#primaryimage"},"image":{"@id":"https:\/\/www.dztecs.com\/tech\/an-advanced-vba-guide-for-ms-excel-mastering-automation\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/excel-2.jpeg","datePublished":"2026-03-06T17:07:38+00:00","description":"\u0625\u0630\u0627 \u0643\u0646\u062a \u0642\u062f \u0628\u062f\u0623\u062a \u0644\u0644\u062a\u0648 \u0641\u064a \u0627\u0633\u062a\u062e\u062f\u0627\u0645 VBA\u060c \u0641\u0633\u062a\u062d\u062a\u0627\u062c \u0625\u0644\u0649 \u0627\u0644\u0628\u062f\u0621 \u0628\u062f\u0631\u0627\u0633\u0629 \u062f\u0644\u064a\u0644 VBA \u0644\u0644\u0645\u0628\u062a\u062f\u0626\u064a\u0646. \u0648\u0644\u0643\u0646 \u0625\u0630\u0627 \u0643\u0646\u062a \u062e\u0628\u064a\u0631\u064b\u0627 \u0645\u062a\u0645\u0631\u0633\u064b\u0627 \u0641\u064a VBA \u0648\u062a\u0628\u062d\u062b \u0639\u0646 \u0623\u0634\u064a\u0627\u0621 \u0623\u0643\u062b\u0631 \u062a\u0642\u062f\u0645\u064b\u0627 \u064a\u0645\u0643\u0646\u0643","breadcrumb":{"@id":"https:\/\/www.dztecs.com\/tech\/an-advanced-vba-guide-for-ms-excel-mastering-automation\/#breadcrumb"},"inLanguage":"ar","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dztecs.com\/tech\/an-advanced-vba-guide-for-ms-excel-mastering-automation\/"]}]},{"@type":"ImageObject","inLanguage":"ar","@id":"https:\/\/www.dztecs.com\/tech\/an-advanced-vba-guide-for-ms-excel-mastering-automation\/#primaryimage","url":"https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/excel-2.jpeg","contentUrl":"https:\/\/www.dztecs.com\/tech\/wp-content\/uploads\/sites\/10\/2026\/03\/excel-2.jpeg","width":680,"height":454},{"@type":"BreadcrumbList","@id":"https:\/\/www.dztecs.com\/tech\/an-advanced-vba-guide-for-ms-excel-mastering-automation\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0627\u0644\u0631\u0626\u064a\u0633\u064a\u0629","item":"https:\/\/www.dztecs.com\/tech\/"},{"@type":"ListItem","position":2,"name":"\u062f\u0644\u064a\u0644 VBA \u0645\u062a\u0642\u062f\u0645 \u0644\u0640 MS Excel: \u0627\u062d\u062a\u0631\u0627\u0641 \u0627\u0644\u0623\u062a\u0645\u062a\u0629"}]},{"@type":"WebSite","@id":"https:\/\/www.dztecs.com\/tech\/#website","url":"https:\/\/www.dztecs.com\/tech\/","name":"DzTecnium","description":"\u0623\u062d\u062f\u062b \u0627\u0644\u0627\u0628\u062a\u0643\u0627\u0631\u0627\u062a \u0648\u0627\u0644\u0623\u062e\u0628\u0627\u0631 \u0627\u0644\u0639\u0645\u064a\u0642\u0629 \u0644\u0646\u064f\u0628\u0642\u064a\u0643 \u062f\u0627\u0626\u0645\u064b\u0627 \u0641\u064a \u0642\u0644\u0628 \u0639\u0627\u0644\u0645 \u0627\u0644\u062a\u0643\u0646\u0648\u0644\u0648\u062c\u064a\u0627","publisher":{"@id":"https:\/\/www.dztecs.com\/tech\/#organization"},"alternateName":"DzT","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dztecs.com\/tech\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ar"},{"@type":"Organization","@id":"https:\/\/www.dztecs.com\/tech\/#organization","name":"DzTecnium","alternateName":"DzT","url":"https:\/\/www.dztecs.com\/tech\/","logo":{"@type":"ImageObject","inLanguage":"ar","@id":"https:\/\/www.dztecs.com\/tech\/#\/schema\/logo\/image\/","url":"","contentUrl":"","caption":"DzTecnium"},"image":{"@id":"https:\/\/www.dztecs.com\/tech\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.dztecs.com\/tech\/#\/schema\/person\/59a97dbd6d9c9caf88143cdf518d435b","name":"Merwan Redha","image":{"@type":"ImageObject","inLanguage":"ar","@id":"https:\/\/secure.gravatar.com\/avatar\/0a82f61bfa1524addeafcec656a281240151801382761444468f50033fcb0af3?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0a82f61bfa1524addeafcec656a281240151801382761444468f50033fcb0af3?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0a82f61bfa1524addeafcec656a281240151801382761444468f50033fcb0af3?s=96&d=mm&r=g","caption":"Merwan Redha"}}]}},"_links":{"self":[{"href":"https:\/\/www.dztecs.com\/tech\/wp-json\/wp\/v2\/posts\/32926","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dztecs.com\/tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dztecs.com\/tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dztecs.com\/tech\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dztecs.com\/tech\/wp-json\/wp\/v2\/comments?post=32926"}],"version-history":[{"count":0,"href":"https:\/\/www.dztecs.com\/tech\/wp-json\/wp\/v2\/posts\/32926\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dztecs.com\/tech\/wp-json\/wp\/v2\/media\/32939"}],"wp:attachment":[{"href":"https:\/\/www.dztecs.com\/tech\/wp-json\/wp\/v2\/media?parent=32926"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dztecs.com\/tech\/wp-json\/wp\/v2\/categories?post=32926"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dztecs.com\/tech\/wp-json\/wp\/v2\/tags?post=32926"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}