ื”ืจืคืชืงืื•ืชื™ื” ืฉืœ ืชื•ื›ื ืช ื–ื“ื•ื ื™ืช ื—ืžืงืžืงื”, ื—ืœืง V: ืืคื™ืœื• ื™ื•ืชืจ ืกืงืจื™ืคื˜ื™ื ืฉืœ DDE ื•-COM

ื”ืจืคืชืงืื•ืชื™ื” ืฉืœ ืชื•ื›ื ืช ื–ื“ื•ื ื™ืช ื—ืžืงืžืงื”, ื—ืœืง V: ืืคื™ืœื• ื™ื•ืชืจ ืกืงืจื™ืคื˜ื™ื ืฉืœ DDE ื•-COM

ืžืืžืจ ื–ื” ื”ื•ื ื—ืœืง ืžืกื“ืจืช ืชื•ื›ื ื•ืช ื–ื“ื•ื ื™ื•ืช ืœืœื ืงื‘ืฆื™ื. ื›ืœ ืฉืืจ ื—ืœืงื™ ื”ืกื“ืจื”:

ื‘ืกื“ืจืช ืžืืžืจื™ื ื–ื• ืื ื• ื‘ื•ื—ื ื™ื ืฉื™ื˜ื•ืช ืชืงื™ืคื” ื”ื“ื•ืจืฉื•ืช ืžืืžืฅ ืžื™ื ื™ืžืœื™ ืžืฆื“ ื”ืืงืจื™ื. ื‘ืขื‘ืจ ัั‚ะฐั‚ัŒะต ื›ื™ืกื™ื ื• ืฉืืคืฉืจ ืœื”ื›ื ื™ืก ืืช ื”ืงื•ื“ ืขืฆืžื• ืœืžื˜ืขืŸ ื”ืฉื“ื” ื”ืื•ื˜ื•ืžื˜ื™ ืฉืœ DDE ื‘-Microsoft Word. ืขืœ ื™ื“ื™ ืคืชื™ื—ืช ืžืกืžืš ื›ื–ื” ื”ืžืฆื•ืจืฃ ืœืžื™ื™ืœ ืคื™ืฉื™ื ื’, ืžืฉืชืžืฉ ืœื ื ื–ื”ืจ ื™ืืคืฉืจ ืœืชื•ืงืฃ ืœื”ืฉื™ื’ ื“ืจื™ืกืช ืจื’ืœ ื‘ืžื—ืฉื‘ ืฉืœื•. ืขื ื–ืืช, ื‘ืกื•ืฃ 2017, Microsoft ืกึธื’ื•ึผืจ ืคืจืฆื” ื–ื• ืœื”ืชืงืคื•ืช ืขืœ DDE.
ื”ืชื™ืงื•ืŸ ืžื•ืกื™ืฃ ืขืจืš ืจื™ืฉื•ื ืฉืžื ื˜ืจืœ ืคื•ื ืงืฆื™ื•ืช DDE ื‘ืžื™ืœื”. ืื ืืชื” ืขื“ื™ื™ืŸ ื–ืงื•ืง ืœืคื•ื ืงืฆื™ื•ื ืœื™ื•ืช ื–ื•, ืชื•ื›ืœ ืœื”ื—ื–ื™ืจ ืืคืฉืจื•ืช ื–ื• ืขืœ ื™ื“ื™ ื”ืคืขืœืช ื™ื›ื•ืœื•ืช ื”-DDE ื”ื™ืฉื ื•ืช.

ืขื ื–ืืช, ื”ืชื™ืงื•ืŸ ื”ืžืงื•ืจื™ ื›ื™ืกื” ืจืง ืืช Microsoft Word. ื”ืื ืคื’ื™ืขื•ื™ื•ืช DDE ืืœื• ืงื™ื™ืžื•ืช ื‘ืžื•ืฆืจื™ื ืื—ืจื™ื ืฉืœ Microsoft Office ืฉื™ื›ื•ืœื™ื ืœื”ื™ื•ืช ืžื ื•ืฆืœื™ื ื’ื ื‘ื”ืชืงืคื•ืช ืœืœื ืงื•ื“? ื›ืŸ ื‘ื˜ื—. ืœื“ื•ื’ืžื”, ืืชื” ื™ื›ื•ืœ ืœืžืฆื•ื ืื•ืชื ื’ื ื‘ืืงืกืœ.

ืœื™ืœ ื”ื—ื™ื™ื DDE

ืื ื™ ื–ื•ื›ืจ ืฉื‘ืคืขื ื”ืงื•ื“ืžืช ืขืฆืจืชื™ ื‘ืชื™ืื•ืจ ืฉืœ ืกืงืจื™ืคื˜ื™ื ืฉืœ COM. ืื ื™ ืžื‘ื˜ื™ื— ืฉืื’ื™ืข ืืœื™ื”ื ื‘ื”ืžืฉืš ื”ืžืืžืจ ื”ื–ื”.

ื‘ื™ื ืชื™ื™ื, ื‘ื•ืื• ื ืกืชื›ืœ ืขืœ ืฆื“ ืจืข ื ื•ืกืฃ ืฉืœ DDE ื‘ื’ืจืกืช ื”ืืงืกืœ. ืžืžืฉ ื›ืžื• ื‘-Word, ื—ืœืงื ืชื›ื•ื ื•ืช ื ืกืชืจื•ืช ืฉืœ DDE ื‘ืืงืกืœ ืžืืคืฉืจื™ื ืœืš ืœื‘ืฆืข ืงื•ื“ ืœืœื ืžืืžืฅ ืจื‘. ื›ืžืฉืชืžืฉ ื•ื•ืจื“ ืฉื’ื“ืœ, ื”ื›ืจืชื™ ืืช ื”ืฉื“ื•ืช, ืื‘ืœ ื‘ื›ืœืœ ืœื ืืช ื”ืคื•ื ืงืฆื™ื•ืช ื‘-DDE.

ื ื“ื”ืžืชื™ ืœื’ืœื•ืช ืฉื‘ืืงืกืœ ืื ื™ ื™ื›ื•ืœ ืœืงืจื•ื ืœืžืขื˜ืคืช ืžืชื ื›ืคื™ ืฉืžื•ืฆื’ ืœื”ืœืŸ:

ื”ืจืคืชืงืื•ืชื™ื” ืฉืœ ืชื•ื›ื ืช ื–ื“ื•ื ื™ืช ื—ืžืงืžืงื”, ื—ืœืง V: ืืคื™ืœื• ื™ื•ืชืจ ืกืงืจื™ืคื˜ื™ื ืฉืœ DDE ื•-COM

ื”ื™ื“ืขืชื ืฉื–ื” ืืคืฉืจื™? ืื™ืฉื™ืช, ืื ื™ ืœื

ื”ื™ื›ื•ืœืช ื”ื–ื• ืœื”ืฉื™ืง ืžืขื˜ืคืช ืฉืœ Windows ื”ื™ื ื‘ืื“ื™ื‘ื•ืช DDE. ืืชื” ื™ื›ื•ืœ ืœื—ืฉื•ื‘ ืขืœ ื”ืจื‘ื” ื“ื‘ืจื™ื ืื—ืจื™ื
ื™ื™ืฉื•ืžื™ื ืฉืืชื” ื™ื›ื•ืœ ืœื”ืชื—ื‘ืจ ืืœื™ื”ื ื‘ืืžืฆืขื•ืช ืคื•ื ืงืฆื™ื•ืช ื”-DDE ื”ืžื•ื‘ื ื•ืช ืฉืœ Excel.
ืืชื” ื—ื•ืฉื‘ ืขืœ ืื•ืชื• ื”ื“ื‘ืจ ืฉืื ื™ ื—ื•ืฉื‘?

ืชืŸ ืœืคืงื•ื“ื” ื‘ืชื•ืš ื”ืชื ืฉืœื ื• ืœื”ืชื—ื™ืœ ืกืฉืŸ PowerShell ืฉืื—ืจ ื›ืš ืžื•ืจื™ื“ ื•ืžื‘ืฆืข ืืช ื”ืงื™ืฉื•ืจ - ื–ื” ืงื‘ืœืช ื”ืคื ื™ื, ืฉื›ื‘ืจ ื”ืฉืชืžืฉื ื• ื‘ื• ื‘ืขื‘ืจ. ืจืื” ืœืžื˜ื”:

ื”ืจืคืชืงืื•ืชื™ื” ืฉืœ ืชื•ื›ื ืช ื–ื“ื•ื ื™ืช ื—ืžืงืžืงื”, ื—ืœืง V: ืืคื™ืœื• ื™ื•ืชืจ ืกืงืจื™ืคื˜ื™ื ืฉืœ DDE ื•-COM

ืคืฉื•ื˜ ื”ื“ื‘ืง ืžืขื˜ PowerShell ื›ื“ื™ ืœื˜ืขื•ืŸ ื•ืœื”ืคืขื™ืœ ืงื•ื“ ืžืจื—ื•ืง ื‘- Excel

ืื‘ืœ ื™ืฉ ืžืœื›ื•ื“: ืขืœื™ืš ืœื”ื–ื™ืŸ ื‘ืžืคื•ืจืฉ ืืช ื”ื ืชื•ื ื™ื ื”ืืœื” ืœืชื ื›ื“ื™ ืฉื”ื ื•ืกื—ื” ื”ื–ื• ืชืขื‘ื•ื“ ื‘ืืงืกืœ. ื›ื™ืฆื“ ื”ืืงืจ ื™ื›ื•ืœ ืœื‘ืฆืข ืคืงื•ื“ืช DDE ื–ื• ืžืจื—ื•ืง? ื”ืขื•ื‘ื“ื” ื”ื™ื ืฉื›ืืฉืจ ื˜ื‘ืœืช ืืงืกืœ ืคืชื•ื—ื”, ืืงืกืœ ื™ื ืกื” ืœืขื“ื›ืŸ ืืช ื›ืœ ื”ืงื™ืฉื•ืจื™ื ื‘-DDE. ืœื”ื’ื“ืจื•ืช ืžืจื›ื– ื”ืืžื•ืŸ ื”ื™ื™ืชื” ืžื–ืžืŸ ืืช ื”ื™ื›ื•ืœืช ืœื”ืฉื‘ื™ืช ื–ืืช ืื• ืœื”ื–ื”ื™ืจ ื‘ืขืช ืขื“ื›ื•ืŸ ืงื™ืฉื•ืจื™ื ืœืžืงื•ืจื•ืช ื ืชื•ื ื™ื ื—ื™ืฆื•ื ื™ื™ื.

ื”ืจืคืชืงืื•ืชื™ื” ืฉืœ ืชื•ื›ื ืช ื–ื“ื•ื ื™ืช ื—ืžืงืžืงื”, ื—ืœืง V: ืืคื™ืœื• ื™ื•ืชืจ ืกืงืจื™ืคื˜ื™ื ืฉืœ DDE ื•-COM

ืืคื™ืœื• ืœืœื ื”ืชื™ืงื•ื ื™ื ื”ืื—ืจื•ื ื™ื, ืืชื” ื™ื›ื•ืœ ืœื‘ื˜ืœ ืืช ืขื“ื›ื•ืŸ ืงื™ืฉื•ืจื™ื ืื•ื˜ื•ืžื˜ื™ ื‘-DDE

ืžื™ืงืจื•ืกื•ืคื˜ ื‘ืžืงื•ืจ ืขืฆืžื” ื™ืขืฅ ื—ื‘ืจื•ืช ื‘-2017 ืฆืจื™ื›ื•ืช ืœื”ืฉื‘ื™ืช ืขื“ื›ื•ื ื™ ืงื™ืฉื•ืจ ืื•ื˜ื•ืžื˜ื™ื™ื ื›ื“ื™ ืœืžื ื•ืข ืคื’ื™ืขื•ื™ื•ืช DDE ื‘-Word ื•ื‘-Excel. ื‘ื™ื ื•ืืจ 2018, ืžื™ืงืจื•ืกื•ืคื˜ ืคืจืกืžื” ืชื™ืงื•ื ื™ื ืขื‘ื•ืจ Excel 2007, 2010 ื•-2013 ื”ืžืฉื‘ื™ืชื™ื ืืช DDE ื›ื‘ืจื™ืจืช ืžื—ื“ืœ. ื–ึถื” ืžืืžืจ Computerworld ืžืชืืจ ืืช ื›ืœ ื”ืคืจื˜ื™ื ืฉืœ ื”ืชื™ืงื•ืŸ.

ื•ื‘ื›ืŸ, ืžื” ืœื’ื‘ื™ ื™ื•ืžื ื™ ืื™ืจื•ืขื™ื?

ืžื™ืงืจื•ืกื•ืคื˜ ื‘ื›ืœ ื–ืืช ื ื˜ืฉื” ืืช DDE ืขื‘ื•ืจ MS Word ื•-Excel, ื•ื‘ื›ืš ื–ื™ื”ืชื” ืกื•ืฃ ืกื•ืฃ ืฉ-DDE ื“ื•ืžื” ื™ื•ืชืจ ืœื‘ืื’ ืžืืฉืจ ืœืคื•ื ืงืฆื™ื•ื ืœื™ื•ืช. ืื ืžืกื™ื‘ื” ื›ืœืฉื”ื™ ืขื“ื™ื™ืŸ ืœื ื”ืชืงื ืช ืืช ื”ืชื™ืงื•ื ื™ื ื”ืœืœื•, ืืชื” ืขื“ื™ื™ืŸ ื™ื›ื•ืœ ืœื”ืคื—ื™ืช ืืช ื”ืกื™ื›ื•ืŸ ืœื”ืชืงืคืช DDE ืขืœ ื™ื“ื™ ื”ืฉื‘ืชืช ืขื“ื›ื•ื ื™ ืงื™ืฉื•ืจื™ื ืื•ื˜ื•ืžื˜ื™ื™ื ื•ื”ืคืขืœืช ื”ื’ื“ืจื•ืช ื”ืžื‘ืงืฉื•ืช ืžื”ืžืฉืชืžืฉื™ื ืœืขื“ื›ืŸ ืงื™ืฉื•ืจื™ื ื‘ืขืช ืคืชื™ื—ืช ืžืกืžื›ื™ื ื•ื’ื™ืœื™ื•ื ื•ืช ืืœืงื˜ืจื•ื ื™ื™ื.

ืขื›ืฉื™ื• ืฉืืœืช ืžื™ืœื™ื•ืŸ ื”ื“ื•ืœืจ: ืื ืืชื” ืงื•ืจื‘ืŸ ืœื”ืชืงืคื” ื”ื–ื•, ื”ืื ื”ืคืขืœื•ืช PowerShell ืฉื”ื•ืฉืงื• ืžืฉื“ื•ืช Word ืื• ืžืชืื™ Excel ื™ื•ืคื™ืขื• ื‘ื™ื•ืžืŸ?

ื”ืจืคืชืงืื•ืชื™ื” ืฉืœ ืชื•ื›ื ืช ื–ื“ื•ื ื™ืช ื—ืžืงืžืงื”, ื—ืœืง V: ืืคื™ืœื• ื™ื•ืชืจ ืกืงืจื™ืคื˜ื™ื ืฉืœ DDE ื•-COM

ืฉืืœื”: ื”ืื ื”ืคืขืœื•ืช PowerShell ืžื•ืคืขืœื•ืช ื“ืจืš DDE ื ืจืฉืžื•ืช? ืชืฉื•ื‘ื”: ื›ืŸ

ื›ืืฉืจ ืืชื” ืžืคืขื™ืœ ื”ืคืขืœื•ืช PowerShell ื™ืฉื™ืจื•ืช ืžืชื Excel ื•ืœื ื›ืžืืงืจื•, Windows ื™ืจืฉื•ื ืื™ืจื•ืขื™ื ืืœื” (ืจืื” ืœืขื™ืœ). ื™ื—ื“ ืขื ื–ืืช, ืื ื™ ืœื ื™ื›ื•ืœ ืœื˜ืขื•ืŸ ืฉื™ื”ื™ื” ืงืœ ืœืฆื•ื•ืช ื”ืื‘ื˜ื—ื” ืœืื—ืจ ืžื›ืŸ ืœื—ื‘ืจ ืืช ื›ืœ ื”ื ืงื•ื“ื•ืช ื‘ื™ืŸ ื”ืคื’ื™ืฉื” ืฉืœ PowerShell, ืžืกืžืš ื”ืืงืกืœ ื•ื”ื•ื“ืขืช ื”ืื™ืžื™ื™ืœ ื•ืœื”ื‘ื™ืŸ ื”ื™ื›ืŸ ื”ื—ืœื” ื”ืžืชืงืคื”. ืื—ื–ื•ืจ ืœื–ื” ื‘ืžืืžืจ ื”ืื—ืจื•ืŸ ื‘ืกื“ืจื” ื”ื‘ืœืชื™ ื ื’ืžืจืช ืฉืœื™ ืขืœ ื”ืชื•ื›ื ื” ื”ื–ื“ื•ื ื™ืช ื”ื—ืžืงืžืงื”.

ืื™ืš ื”-COM ืฉืœื ื•?

ื‘ืงื•ื“ื ัั‚ะฐั‚ัŒะต ื ื’ืขืชื™ ื‘ื ื•ืฉื ืฉืœ ืกืงืจื™ืคื˜ื™ื ืฉืœ COM. ื”ื ื ื•ื—ื™ื ื‘ืคื ื™ ืขืฆืžื. ื˜ื›ื ื•ืœื•ื’ื™ื”, ื”ืžืืคืฉืจ ืœืš ืœื”ืขื‘ื™ืจ ืงื•ื“, ืœืžืฉืœ JScript, ืคืฉื•ื˜ ื›ืื•ื‘ื™ื™ืงื˜ COM. ืื‘ืœ ืื– ื”ืชื’ืœื• ื”ืกืงืจื™ืคื˜ื™ื ืขืœ ื™ื“ื™ ื”ืืงืจื™ื, ื•ื–ื” ืื™ืคืฉืจ ืœื”ื ืœื”ืฉื™ื’ ื“ืจื™ืกืช ืจื’ืœ ืขืœ โ€‹โ€‹ื”ืžื—ืฉื‘ ืฉืœ ื”ืงื•ืจื‘ืŸ ืœืœื ืฉื™ืžื•ืฉ ื‘ื›ืœื™ื ืžื™ื•ืชืจื™ื. ื–ึถื” ื•ื™ื“ืื• ืž-Derbycon ืžื“ื’ื™ื ื›ืœื™ Windows ืžื•ื‘ื ื™ื ื›ืžื• regsrv32 ื•-rundll32 ืฉืžืงื‘ืœื™ื ืกืงืจื™ืคื˜ื™ื ืžืจื•ื—ืงื™ื ื›ื˜ื™ืขื•ื ื™ื, ื•ื”ืืงืจื™ื ื‘ืขืฆื ืžื‘ืฆืขื™ื ืืช ื”ืชืงืคืชื ืœืœื ืขื–ืจืช ืชื•ื›ื ื•ืช ื–ื“ื•ื ื™ื•ืช. ื›ืคื™ ืฉื”ืจืื™ืชื™ ื‘ืคืขื ื”ืงื•ื“ืžืช, ืืชื” ื™ื›ื•ืœ ืœื”ืจื™ืฅ ื‘ืงืœื•ืช ืคืงื•ื“ื•ืช PowerShell ื‘ืืžืฆืขื•ืช scriptlet JScript.

ื”ืชื‘ืจืจ ืฉืื—ื“ ืžืื•ื“ ื—ื›ื ื”ื—ื•ืงืจ ืžืฆื ื“ืจืš ืœื”ืคืขื™ืœ scriptlet COM ะฒ ืžืกืžืš ืืงืกืœ. ื”ื•ื ื’ื™ืœื” ืฉื›ืืฉืจ ื ื™ืกื” ืœื”ื›ื ื™ืก ืงื™ืฉื•ืจ ืœืžืกืžืš ืื• ืชืžื•ื ื” ืœืชื, ื”ื•ื›ื ืกื” ืœืชื•ื›ื• ื—ื‘ื™ืœื” ืžืกื•ื™ืžืช. ื•ื—ื‘ื™ืœื” ื–ื• ืžืงื‘ืœืช ื‘ืฉืงื˜ scriptlet ืžืจื•ื—ืง ื›ืงืœื˜ (ืจืื” ืœื”ืœืŸ).

ื”ืจืคืชืงืื•ืชื™ื” ืฉืœ ืชื•ื›ื ืช ื–ื“ื•ื ื™ืช ื—ืžืงืžืงื”, ื—ืœืง V: ืืคื™ืœื• ื™ื•ืชืจ ืกืงืจื™ืคื˜ื™ื ืฉืœ DDE ื•-COM

ื‘ึผื•ึผื! ืฉื™ื˜ื” ื—ืžืงื ื™ืช ื•ืฉืงื˜ื” ื ื•ืกืคืช ืœื”ืฉื™ืง ืžืขื˜ืคืช ื‘ืืžืฆืขื•ืช ืกืงืจื™ืคื˜ื™ื ืฉืœ COM

ืœืื—ืจ ื‘ื“ื™ืงืช ืงื•ื“ ื‘ืจืžื” ื ืžื•ื›ื”, ื”ื—ื•ืงืจ ื’ื™ืœื” ืžื” ื–ื” ื‘ืืžืช ื—ืจืง ื‘ืชื•ื›ื ืช ื”ื—ื‘ื™ืœื”. ื–ื” ืœื ื ื•ืขื“ ืœื”ืจื™ืฅ ืกืงืจื™ืคื˜ื™ื ืฉืœ COM, ืืœื ืจืง ืœืงืฉืจ ืœืงื‘ืฆื™ื. ืื ื™ ืœื ื‘ื˜ื•ื— ืื ื™ืฉ ื›ื‘ืจ ืชื™ืงื•ืŸ ืœืคื’ื™ืขื•ืช ื”ื–ื•. ื‘ืžื—ืงืจ ืฉืœื™ ื‘ืืžืฆืขื•ืช Amazon WorkSpaces ืขื Office 2010 ืžื•ืชืงืŸ ืžืจืืฉ, ื”ืฆืœื—ืชื™ ืœืฉื—ื–ืจ ืืช ื”ืชื•ืฆืื•ืช. ืขื ื–ืืช, ื›ืฉื ื™ืกื™ืชื™ ืฉื•ื‘ ืงืฆืช ืžืื•ื—ืจ ื™ื•ืชืจ, ื–ื” ืœื ืขื‘ื“.

ืื ื™ ืžืื•ื“ ืžืงื•ื•ื” ืฉืกื™ืคืจืชื™ ืœื›ื ื”ืจื‘ื” ื“ื‘ืจื™ื ืžืขื ื™ื™ื ื™ื ื•ื‘ืžืงื‘ื™ืœ ื”ืจืื™ืชื™ ืฉื”ืืงืจื™ื ื™ื›ื•ืœื™ื ืœื—ื“ื•ืจ ืœื—ื‘ืจื” ืฉืœื›ื ื‘ืฆื•ืจื” ื“ื•ืžื” ื›ื–ื• ืื• ืื—ืจืช. ื’ื ืื ืชืชืงื™ืŸ ืืช ื›ืœ ื”ืชื™ืงื•ื ื™ื ื”ืื—ืจื•ื ื™ื ืฉืœ ืžื™ืงืจื•ืกื•ืคื˜, ืœื”ืืงืจื™ื ื™ืฉ ื›ืœื™ื ืจื‘ื™ื ืœื”ืฉื™ื’ ื“ืจื™ืกืช ืจื’ืœ ื‘ืžืขืจื›ืช ืฉืœืš, ื”ื—ืœ ืžืคืงื•ื“ื•ืช ื”ืžืืงืจื• ืฉืœ VBA ืฉื”ืชื—ืœืชื™ ืื™ืชื ืืช ื”ืกื“ืจื” ื”ื–ื• ื•ืขื“ ืœืžื˜ืขื ื™ื ื–ื“ื•ื ื™ื™ื ื‘ื•ื•ืจื“ ืื• ืืงืกืœ.

ื‘ืžืืžืจ ื”ืื—ืจื•ืŸ (ืื ื™ ืžื‘ื˜ื™ื—) ื‘ืกืื’ื” ื”ื–ื•, ืื“ื‘ืจ ืขืœ ืื™ืš ืœืกืคืง ื”ื’ื ื” ื—ื›ืžื”.

ืžืงื•ืจ: www.habr.com

ื”ื•ืกืคืช ืชื’ื•ื‘ื”