
ChatGPTã«çäŸå ±åçšã®ãã¯ãŒãã€ã³ãã¹ã©ã€ããäœã£ãŠããããã
0. ã¯ããã«
â» æ²å ±
2023/10 AIã®æ¥ã
ã®é²åããæ¬èšäºã¯å®å
šã«æä»£é
ãã«ãªããŸããã
â ææ°ã®æ
å ±ãšãªããŸã
ChatGPT (AI) ã®æ®åã§æ§ã ãªææ³ã§çºè¡šçšã®ã¹ã©ã€ãäœæã®èªååãéçºãããŠããŸããçäŸå ±åã®ãã¬ãŒã³çšã¹ã©ã€ãã¯ã©ã®åŠäŒã§ããããçšåºŠã®ã決ãŸã£ãåããããŸãã ãã®ãããªãã¬ãŒã³ããŒã·ã§ã³ã§ã¯ChatGPTã®åšåãçºæ®ããããšæããŸãã以åtwitterã§ã¯ãŒããã¡ã€ã«ãããã¯ãã®ã¹ã©ã€ããåèªååã§äœæããæ¹æ³ã玹ä»ããŸããããã®ææ³èªäœã¯å€ãããååšãããã®ã§ããã, ChatGPTã«ãã£ãŠæ€æ»å€ã®è¡šäœæã®èªååãªã©å人ã®ãã¬ãŒã³ã«ã«ã¹ã¿ãã€ãºããããšãã§ããããã«ãªããŸããããã®èŸºãã¯æ¬¡æMS office copilotã§ãåºæ¥ãªãèæ¥ãšå人çã«æããŸãã®ã§ä»å玹ä»ãããŠããã ããŸãã
ç æŽèŠçŽwordâ çäŸå ±åppt
â ããpony (@pony_pon471) April 20, 2023
AIæèŒã®æ¬¡æofficeã¯ç°¡åãªèšèããèªåã§ã¹ã©ã€ãäœæãããã§ãããããŸã§ã¯VBAãçšããåèªåã§ã¹ã©ã€ãäœæå¹çåã#ChatGPT #ãã¯ãŒãã€ã³ã#çäŸå ±å pic.twitter.com/fstfGevfrr
1. æºå
ç æŽèŠçŽword ãã¡ã€ã«ãã çäŸå ±å power pointãã¡ã€ã«ãäœæããŸãã

ç æŽèŠçŽã®æºå
ããã¹ãããŒã¿ (word file) ãæºåããŸãã

title ã確å®èšºæåã, ã䞻蚎ã, ãçŸç æŽãã»ã»ã»ç æŽèŠçŽã®åœ¢åŒãšããŠäœæãããããã¹ããã¡ã€ã«ãæºåããŸãã
æ£è ããã¹ãããŒã¿ãããç æŽèŠçŽãã®åœ¢åŒã«ããæ¹æ³ã以äžã«ç޹ä»ããŠããŸãã
2. äœæ
ç
æŽèŠçŽãããšã«ãã¯ãŒãã€ã³ãã¹ã©ã€ããäœã£ãŠãããŸããææ³ãšããŠä»¥äžã®2éãã§æ€èšŒããŸãã
2.1 Wordã§ã¢ãŠãã©ã€ã³ã¬ãã«ãèšå®ããã¯ãŒãã€ã³ããžå±é
2.1.1 ã¢ãŠãã©ã€ã³ã¬ãã«ã®èšå® (Word)
title (åã¹ã©ã€ãã®èŠåºã) ãã¢ãŠãã©ã€ã³ã¬ãã«1
åã¹ã©ã€ãã®å
容 ãã¢ãŠãã©ã€ã³ã¬ãã«2 ã«èšå®ããŸãã


ã¢ãŠãã©ã€ã³ã¬ãã«1 title (èŠåºã) ã¯ãã¯ãŒãã€ã³ãã®ã¹ã©ã€ãã®èŠåºãã«å¯Ÿå¿ããŠãã, titleã«èšå®ãããããŒã¯ãŒãã®æ°ããã¯ãŒãã€ã³ãã¹ã©ã€ãã®ææ°ã«å¯Ÿå¿ããŸãã

ä»å㯠ã䞻蚎ããå ¥é¢æçŸçããæ€æ»æèŠããªã©ãã¢ãŠãã©ã€ã³ã¬ãã«1ã«èšå®ã, ãã®ããŒã¯ãŒããåã¹ã©ã€ãã®äžçªäžã®titleã«ãªãããã«ããŠããŸãã

åã¹ã©ã€ãã®å
容 (æ¬æ) ã¢ãŠãã©ã€ã³ã¬ãã«2ã¯ãã¯ãŒãã€ã³ãã®åã¹ã©ã€ãæ¬æã«å¯Ÿå¿ããŠããŸãã

ãã¡ããæåã§Wordã®è¡šç€ºâã¢ãŠãã©ã€ã³ããç¹å®ã®åèªãã¢ãŠãã©ã€ã³ã¬ãã«1ã«èšå®ããæ¹æ³ããããŸãã
çäŸå ±åã®ãããªæ±ºãŸã£ã圢åŒã§æ¯åã¹ã©ã€ããäœæããå Žåã¯ä»¥äžã®æ¹æ³ã§ãã³ãã¬ãŒããäœæããŠããã°äœææéãå€§å¹ ã«ççž®ã§ããŸãã
2.1.2 ãã¯ãŒãã€ã³ãã§ã¢ãŠãã©ã€ã³ããã€ã³ããŒã
ãã¯ãŒãã€ã³ããèµ·åâæ¿å
¥âæ°ããã¹ã©ã€ãâã¢ãŠãã©ã€ã³ããã¹ã©ã€ã
å
ã»ã©äœæããã¯ãŒããã¡ã€ã«ãéžã³ãŸãã


ãã¯ãŒãã€ã³ãã«ç æŽèŠçŽã®ã¹ã©ã€ããå±éãããŸããã
2.1.3 衚ã®äœæ
æ€æ»å€ã®æååãå«ãŸããããã¹ãããã¯ã¹ãã¯ãªãã¯ã, ãã¯ããå®è¡ããŸãã

nè¡Ã2åã®æ€æ»é ç®ãå«ã衚ãåºæ¥ãŸããã

2.1.4 ã°ã©ãã®äœæÂ
å ¥é¢åŸçµéãªã©ã®è€éãªã°ã©ã (ç¹ã«2軞) ã¯, çŸæç¹ã§ChatGPT (AI) ã§äœæã¯å°é£ãšèããŠããŸããsampleã³ãŒãããäœæããææ³ãä»åæ¡çšããŠããŸãã


äžå¿, èªå??ã§ã°ã©ãäœæã§ããŸããã
2.1 ChatGPTã§ãã¯ãŒãã€ã³ãVBAãäœæ
ãã¡ããå€ãããããææ³ã§ã¢ãŠãã©ã€ã³ã¬ãã«ãèšå®ããããšãªãçŽæ¥åºåã§ã, æäœã簡䟿ã§ãããã¡ãã®æ¹ãäž»æµã§ããããã
Act as a VBA programmer. Write me VBA code to create PowerPoint slides about the sports
drink and hydration beverage category. think like a senior CPG brand manager and market
researcher. use your knowledge and create at least 10 slides.GPT-4ã§ãããã«ã€ããŠãã¯ãŒãã€ã³ããã®ã¹ã©ã€ããäœæããVBAã³ãŒããäœã£ãŠããã ãããšããã³ããã, ãããpower point VBAã§å®è¡ããã ãã§ãã
ãã ãâ»ããã³ããã®æåæ°ã1000æåãè¶
ããããããããšã©ãŒãé »åºãããããªæ°ãããã®ã§é·æã®å Žåã¯åå²ããŠããã³ãããããããªãããã§ãã
ä»å, ã«ã«ãåæãšããã³ãããåãããŠ1000æå以å
ã§äœæãããã®ã§æ€èšŒããŸããã
â»S1, S2ãªã©ã®ã¹ã©ã€ãã®è¡šèšã¯æåã§è¿œèšããŸããã
以äžChatGPT4ã«ããã³ããããŸãã
以äžã®æç« ããã¯ãŒãã€ã³ãã¹ã©ã€ãVBAã®åœ¢åŒã«å€æŽããŠãã ãããã¹ã©ã€ãææ°ã¯7æã§ãã
以äžã«åã¹ã©ã€ãã®æ¬æãæç€ºããŸãã
æ¬æïŒ
S1. Title ç
é¢å¥è
ã確å®èšºæåãïŒ#1(ãã³ããŠã€ã«ã¹ææç)ã#2(ç³å°¿ç
)ã#3(é«è¡å§)ïŒ
S2. ã䞻蚎ãåœé çãåŒåžèŠãçºç±ãåŠæ æ
ãçŸç
æŽãç³å°¿ç
ãšé«è¡å§çãæ±ãã52æ³ã®ç·æ§ãè¡æ¶²æ€æ»ã§çœè¡çæ°äžæãææããããã£ããç·åç
é¢ãž
ç·æ¥ç޹ä»ãããã8æ12æ¥ããã£ããç·åç
é¢ãžã®å
¥é¢ãšãªã£ãã
S3. ãæ¢åŸæŽãç³å°¿ç
ãé«è¡å§
ã瀟äŒç掻æŽãã¢ã¬ã«ã®ãŒæŽïŒãªããå«ç
æŽïŒ10ã20æ¬/æ¥ã飲é
æŽïŒãŠã€ã¹ããŒãã¯ã€ã³ãé©éã
ãè·æ¥ïŒã¬ã¹ãã©ã³ãããŒãžã£ãŒ
ãå®¶ææŽãç¶ïŒè³åäžã§æ»äº¡
S4. ãå
¥é¢æçŸçã身é·ãšäœéã¯èšèŒããªãããäžæãäœæž©38.5âïŒèæ100/åïŒæŽãè¡å§150/95mmHgïŒ
ããåŒåžæ°22/åãçŒçŒçµèã«è²§è¡ãçŒççµèã«é»çžã¯ãªããèžéšïŒèºé³ã«ç°åžžã¯ãªããå¿é³ã«ç°åžžã¯ãªãã
ãè
¹éšïŒå¹³åŠïŒè»ã§å§çã¯ãªããèã»èŸãè§Šç¥ããªããåè¢ïŒäžè
¿æµ®è
«ãèªããªããç®ç¹ã¯ãªãã
ãªã³ãç¯ã®è
«è¹ãåœé çºèµ€ãèªããã
ãæ€æ»æèŠãå°¿æèŠïŒãªããè¡æ¶²æèŠïŒèµ€è¡ç 4.2äž/ÎŒLãHbãªããHtãªããçœè¡ç 9,000/ÎŒL
ïŒNEãªããLY 20ïŒ
ãMONOãªããEOSãªãïŒãè¡å°æ¿ãªããPTãªããAPTTãªããè¡æŒ¿ãã£ããªãã²ã³ãªãã
è¡æž
FDPãªããè¡æ¶²çååŠæèŠïŒTPãªããAlbãªãããã§ãªãã³ãªããAST 48 U/LãALT 38 U/LãLDãªãã
BUNãªããCr 1.3 mg/dLãå
ç«è¡æž
åŠæèŠïŒCRP 25 mg/dLããªãŠããã€ãå åé°æ§ãMPO-ANCA ïŒãªãã
PR3-ANCA ïŒãªããææ žæäœé°æ§ã
S5. ããããã¬ã ãªã¹ããïŒ#1. ãã³ããŠã€ã«ã¹ææçã#2. ç³å°¿ç
ã#3. é«è¡å§ïŒ
ãéé¢æåŠæ¹ã
ã¢ã ããžãã³ 5 mg 1Tãå1ãæé£åŸ, ã¡ããã«ãã³ 500 mg 1Tãå2ãæã»å€é£åŸ,
ãã£ããããŒãïŒãµãŒã¢ã³å³ïŒ 1猶/æ¥
S6. ãå
¥é¢åŸçµéãšèå¯ã
ãã«ãã®çç¶ãåŸã
ã«æ¹åãå§ããçµéã¯æ¬¡ã®éãã§ãããåœåã®æ žé
žå¢å¹
æ³æ€æ»ã§ãã³ããŠã€ã«ã¹ã«
é°æ§ãšå€æããããçç¶æ¹åãããã¡ãããã ãã¢ãžã¹ããã€ã·ã³ãã¬ã ãã·ãã«ãã¹ããã€ããã«ã¹çæ³ã«
ãåå¿ãªãã
S7. ãç·åèå¯ã
å»ççã¯åºç€çŸæ£ãšææçã®é¢é£æ§ãç ç©¶ãããã«ãã®äºäŸã§ã¯é£äºã®å€æŽãç
ç¶ã«åœ±é¿ãäžããããšã
ããã£ãããŸãããã¯ã¿ãŒãã£ã³ãœã³ã¯éŒ»èãèšºææ³ã®æ¹åã詊ã¿ãææãªã¹ã¯ã®è»œæžãšèšºæã®ç²ŸåºŠåäžã
瀺ããã
åŸãããVBAã³ãŒãã¯âã§ãã
Sub CreateSlides()
Dim ppt As Presentation
Dim sld As Slide
Dim shp As Shape
Dim slideTexts As Variant
Set ppt = ActivePresentation
slideTexts = Array("Title ç
é¢å¥èã確å®èšºæåãïŒ#1(ãã³ããŠã€ã«ã¹ææç)ã#2(ç³å°¿ç
)ã#3(é«è¡å§)ïŒ", _
"ã䞻蚎ãåœé çãåŒåžèŠãçºç±ãåŠæ æãçŸç
æŽãç³å°¿ç
ãšé«è¡å§çãæ±ãã52æ³ã®ç·æ§ãè¡æ¶²æ€æ»ã§çœè¡çæ°äžæãææããããã£ããç·åç
é¢ãžç·æ¥ç޹ä»ãããã8æ12æ¥ããã£ããç·åç
é¢ãžã®å
¥é¢ãšãªã£ãã", _
"ãæ¢åŸæŽãç³å°¿ç
ãé«è¡å§ã瀟äŒç掻æŽãã¢ã¬ã«ã®ãŒæŽïŒãªããå«ç
æŽïŒ10ã20æ¬/æ¥ã飲é
æŽïŒãŠã€ã¹ããŒãã¯ã€ã³ãé©éãè·æ¥ïŒã¬ã¹ãã©ã³ãããŒãžã£ãŒãå®¶ææŽãç¶ïŒè³åäžã§æ»äº¡", _
"ãå
¥é¢æçŸçã身é·ãšäœéã¯èšèŒããªãããäžæãäœæž©38.5âïŒèæ100/åïŒæŽãè¡å§150/95mmHgïŒåŒåžæ°22/åãçŒçŒçµèã«è²§è¡ãçŒççµèã«é»çžã¯ãªããèžéšïŒèºé³ã«ç°åžžã¯ãªããå¿é³ã«ç°åžžã¯ãªããè
¹éšïŒå¹³åŠïŒè»ã§å§çã¯ãªããèã»èŸãè§Šç¥ããªããåè¢ïŒäžè
¿æµ®è
«ãèªããªããç®ç¹ã¯ãªãããªã³ãç¯ã®è
«è¹ãåœé çºèµ€ãèªããããæ€æ»æèŠãå°¿æèŠïŒãªããè¡æ¶²æèŠïŒèµ€è¡ç 4.2äž/ÎŒLãHbãªããHtãªããçœè¡ç 9,000/ÎŒLïŒNEãªããLY 20ïŒ
ãMONOãªããEOSãªãïŒãè¡å°æ¿ãªããPTãªããAPTTãªããè¡æŒ¿ãã£ããªãã²ã³ãªããè¡æž
FDPãªããè¡æ¶²çååŠæèŠïŒTPãªããAlbãªãããã§ãªãã³ãªããAST 48 U/LãALT 38 U/LãLDãªããBUNãªããCr 1.3 mg/dLãå
ç«è¡æž
åŠæèŠïŒCRP 25 mg/dLããªãŠããã€ãå åé°æ§ãMPO-ANCA ïŒãªããPR3-ANCA ïŒãªããææ žæäœé°æ§ã", _
"ããããã¬ã ãªã¹ããïŒ#1. ãã³ããŠã€ã«ã¹ææçã#2. ç³å°¿ç
ã#3. é«è¡å§ïŒãéé¢æåŠæ¹ãã¢ã ããžãã³ 5 mg 1Tãå1ãæé£åŸ, ã¡ããã«ãã³ 500 mg 1Tãå2ãæã»å€é£åŸ, ãã£ããããŒãïŒãµãŒã¢ã³å³ïŒ 1猶/æ¥", _
"ãå
¥é¢åŸçµéãšèå¯ããã«ãã®çç¶ãåŸã
ã«æ¹åãå§ããçµéã¯æ¬¡ã®éãã§ãããåœåã®æ žé
žå¢å¹
æ³æ€æ»ã§ãã³ããŠã€ã«ã¹ã«é°æ§ãšå€æããããçç¶æ¹åãããã¡ãããã ãã¢ãžã¹ããã€ã·ã³ãã¬ã ãã·ãã«ãã¹ããã€ããã«ã¹çæ³ã«ãåå¿ãªãã", _
"ãç·åèå¯ãå»ççã¯åºç€çŸæ£ãšææçã®é¢é£æ§ãç ç©¶ãããã«ãã®äºäŸã§ã¯é£äºã®å€æŽãç
ç¶ã«åœ±é¿ãäžããããšãããã£ãããŸãããã¯ã¿ãŒãã£ã³ãœã³ã¯éŒ»èãèšºææ³ã®æ¹åã詊ã¿ãææãªã¹ã¯ã®è»œæžãšèšºæã®ç²ŸåºŠåäžã瀺ããã")
For i = LBound(slideTexts) To UBound(slideTexts)
Set sld = ppt.Slides.Add(i + 1, ppLayoutText)
Set shp = sld.Shapes(2) 'assuming this is the content placeholder shape
shp.TextFrame.TextRange.Text = slideTexts(i)
Next i
End Sub
ãã¡ããPowerPointã®VBAã«è²Œãã€ããã ãã§ãã

ãã¯ãŒãã€ã³ãã¹ã©ã€ããåºåãããŸããã
ãã¡ãã®ææ³ã¯æäœãéåžžã«ç°¡åã§ãã, é·æããã³ããã¯ãšã©ãŒãåºããã, S1, S2ãªã©ã®ããŒãžè¡šèšãèªåã§èšå®ããå¿
èŠããããŸãã
3. ãã¶ã€ã³ã®åŒ·å å¥énote
Office 365 ãã¶ã€ããŒ, èªåçæç³»AIãªã©äœ¿çšããããšã§ãã¶ã€ã³æ§ã®åªããèŠæ ãã®ããã¹ã©ã€ãäœæãå¯èœãšãªããŸããå¥énoteã«ãŠè¿æ¥å ¬éäºå®ã§ããâ
4. äœæã®è§£èª¬
4.1 èæ¯
ããã¹ããã¡ã€ã«ããæç« ããã¯ãŒãã€ã³ããžåºåãã¹ã©ã€ãäœæãåèªåã§è¡ãæ¹æ³ã¯ä»¥åããæå±ãããŠããŸãã
äžã®ãªã³ã¯å
ã«è©³çްãèšèŒãããŠããŸãã, ãŸãšããŸããš
â ããã¹ããã¡ã€ã«ã®å ŽåïŒ
æ¬æãTabããŒæŒããŠå
¥å+UTF-16LEãã¡ã€ã«ã§ä¿åã
â¡ Wordãã¡ã€ã«ã®å ŽåïŒ
ã»ã¿ã€ãã« (èŠåºã) ãã¢ãŠãã©ã€ã³ã¬ãã«1
ã»å
容ãã¢ãŠãã©ã€ã³ã¬ãã«ã2ã«èšå®
ãã®åŸ, ãã¯ãŒãã€ã³ãã§ã¢ãŠãã©ã€ã³ã¬ãã«ããæ¿å ¥ããéžã¶ã ãã§ãã
ChatGPTã®æ®å以åŸ, èªååã®æ³¢ããã£ãŠããŸãããnoteã§ããã§ã«å€ãã®ææ³ã玹ä»ãããŠãŸããã
ChatGPTã«é Œãããšã§, ããžã¥ã¢ã«ããŒã·ã㯠(VBA) ã®ã³ãŒããããã°ã©ãã³ã°ã®ç¥èãªãã§äœãããšãå¯èœãšãªã, ãã¯ã¹ãã®è²Œãä»ã以å€ã«, 衚ãã°ã©ã¹äœæã®èªååãªã©å人ã«åãããã«ã¹ã¿ãã€ãºã®å¹ ãåºãããŸããã
4.2 ã¢ãŠãã©ã€ã³ã¬ãã«ã®èšå® VBA codeäœæ
åè¿°ããæ¹æ³ã®ä»ã«ä»å, èªååã®ä»£è¡šãšããããããžã¥ã¢ã«ããŒã·ã㯠(VBA) ãçšããæ¹æ³ã玹ä»ããŸããããžã¥ã¢ã«ããŒã·ãã¯èªäœã®äœ¿ãæ¹ã¯ä»¥äžã«ãããŸãã
ChatGPTã«Wordçšã®VBAã³ãŒãäœæäŸé ŒããŸãâ
ããã³ããïŒ
ãã€ã¯ããœããWordã®VBAã³ãŒããäœæããŠãã ããã
ãã¹ãŠã®æ®µèœãã¢ãŠãã©ã€ã³ã¬ãã«2ã«èšå®ããŠãã ããã
ãŸããæå®ãããããŒã¯ãŒããå«ã段èœãã¢ãŠãã©ã€ã³ã¬ãã«1ã«èšå®ããŠãã ããã
æ€çŽ¢å¯Ÿè±¡ãšãªãããŒã¯ãŒãã®äŸãšããŠã¯ããTitleãã䞻蚎ããå
¥é¢æçŸçããæ€æ»æèŠã
ããããã¬ã ãªã¹ãããå
¥é¢åŸçµéãšèå¯ããéé¢æåŠæ¹ããç·åèå¯ãããããŸãã
ãã¹ãŠã®æ©èœã1ã€ã®ãµãã«ãŒãã³ã«ãŸãšããŠå®è¡ã§ããããã«ããŠãã ããã
åŸãããã³ãŒãã¯âã§ãã
Sub SetOutlineLevel2()
Dim doc As Document
Dim para As Paragraph
Set doc = ActiveDocument
' ãã¹ãŠã®æ®µèœãåŠç
For Each para In doc.Paragraphs
' 段èœã®ã¢ãŠãã©ã€ã³ã¬ãã«ã2ã«èšå®
para.OutlineLevel = wdOutlineLevel2
Next para
End Sub
Sub SetOutlineLevel1ForMultipleKeywords()
Dim keywords() As Variant
Dim keyword As Variant
Dim targetRange As Range
' ããŒã¯ãŒãã®é
åãäœæããæ€çŽ¢ãããåèªãèšå®ããŸã
keywords = Array("Title", "䞻蚎", "å
¥é¢æçŸç", "æ€æ»æèŠ", "ãããã¬ã ãªã¹ã",
"å
¥é¢åŸçµéãšèå¯", "éé¢æåŠæ¹", "ç·åèå¯")
' é
åå
ã®åããŒã¯ãŒãã«å¯ŸããŠãæ€çŽ¢ãšã¢ãŠãã©ã€ã³ã¬ãã«1ã®èšå®ãè¡ã
For Each keyword In keywords
With ActiveDocument.Content.Find
.ClearFormatting
.Text = keyword
.Forward = True
.Wrap = wdFindStop
.Execute
While .Found
Set targetRange = ActiveDocument.Range(Start:=.Parent.Start, End:=.Parent.End)
targetRange.ParagraphFormat.OutlineLevel = wdOutlineLevel1
.Execute
Wend
End With
Next keyword
End Sub
Sub SetOutlineLevels()
' ãŸããæ¬æã«èšå®ãããŠããæ®µèœããã¹ãŠã¢ãŠãã©ã€ã³ã¬ãã«2ã«å€æããŸãã
SetOutlineLevel2
' 次ã«ãæå®ãããããŒã¯ãŒããå«ãŸããŠããæ®µèœãã¢ãŠãã©ã€ã³ã¬ãã«1ã«èšå®ããŸãã
SetOutlineLevel1ForMultipleKeywords
End Subãã®ã³ãŒããwordãvbaã§å®è¡ãããšãã¢ãŠãã©ã€ã³ã¬ãã«ãèªåã§èšå®ãããŸãã

4.3 è¡šäœæ VBA codeäœæ
ãã¯ãŒãã€ã³ãã§è¡šãäœæããVBA ã³ãŒãäœæã®ããã³ããã¯ä»¥äžã§ãâ
ããã³ãã powerpoint è¡šäœæ
éžæãããPowerPointããã¹ãããã¯ã¹ã®ããã¹ãããã«ã³ãã§åºåãããããŒã¿ãšããŠæ±ãã
ãã®ããŒã¿ãåºã«ããããŒãã«ãæ°ããäœæããVBAãã¯ããäœæããŠãã ããã
ããŒãã«ã®åè¡ã¯ãããã¹ãããŒã¿ã®åèŠçŽ ã«å¯Ÿå¿ãã1åç®ã«ã¯ã©ãã«ã2åç®ã«ã¯å€ãå
¥ãããã«ããŠãã ãã
åŸãããcodeã¯âã§ã
Sub CreateTableFromText()
Dim text As String
Dim data() As String
Dim numRows As Integer
Dim i As Integer
Dim dataTable As Table
Dim slide As slide
' Get the active slide
Set slide = ActiveWindow.View.slide
' Get the text from the selected text box
text = slide.Shapes(1).TextFrame.TextRange.text
' Replace full-width comma with half-width comma
text = Replace(text, "ïŒ", ",")
' Split the text by comma
data = Split(text, ",")
' Calculate the number of rows
numRows = UBound(data) - LBound(data) + 1
' Create a table with numRows rows and 2 columns
Set dataTable = slide.Shapes.AddTable(numRows, 2, 0, 0, 500, 300).Table
' Populate the table
For i = LBound(data) To UBound(data)
' Split the data element into label and value
Dim parts() As String
parts = Split(Trim(data(i)), " ", 2)
' Set the label and value in the table
dataTable.Cell(i + 1, 1).Shape.TextFrame.TextRange.text = parts(0)
If UBound(parts) > 0 Then
dataTable.Cell(i + 1, 2).Shape.TextFrame.TextRange.text = parts(1)
End If
Next i
End Sub
åæ§ã«ãã¯ãŒãã€ã³ãVBAãèµ·åããŠå®è¡ããŸãã
4.4 ããžã¥ã¢ã«ããŒã·ã㯠(VBA) ã®èšå®
wordãŸãã¯powerpointãéãããAlt+F11ã ãæŒããŸãã

Microsoft Visula Basic for Applicationsãèµ·åããŸã

äœæããã³ãŒãã貌ãä»ããŸãã

ä¿åãã¿ã³ãæŒããŠä¿åããŸã

â»æ³šæããã¡ã€ã«ã®çš®é¡ã¯ãWord (Powerpoint) ãã¯ãæå¹ææžããšããŸã

5. ãŸãšã
å®å šèªåãŸã§ã¯ãŸã ãŸã ã§ãã, äžåºŠ, ãã¯ããåã蟌ãã wordãã¡ã€ã«ãäœæããŠããã°æ¬¡åããæéã®å€§å¹ ççž®åãå¯èœãšãªããŸããå®é, çŽã«ã«ããã¹ãã£ããŒãåã蟌ã¿, power pointã®åœ¢åŒãŸã§åºåããã®ã«2-3åã§åºæ¥ãŸããããä»ãŸã§ãªãæ€æ»å€ãæå ¥åããã ãã§æ°å以äžã¯ããã£ãŠããŸããã®ã§äœæ¥å¹çãèŠèŸŒãŸããŸãã