DuKicco https://blog.hatena.ne.jp/DuKicco/ DuKiccoの雑記 https://dukicco.hatenadiary.jp/ エクセル VBA PubmedAPIを利用して文献IDからAbstractやTitleを読み込むFunction Sub Pubmed2() 'Functionの使い方 Dim arr As Variant, PubmedID As Long '情報を取り出したいPubmedID PubmedID = 2644239 arr = GetTitle(PubmedID) MsgBox " Abstract " & arr(1) MsgBox " Title " & arr(2) End Sub Function GetTitle(PMID As Long) As String() 'Microsoft XML. v… 190 <iframe src="https://hatenablog-parts.com/embed?url=https%3A%2F%2Fdukicco.hatenadiary.jp%2Fentry%2F2016%2F11%2F16%2F230534" title="エクセル,VBA,xml,Pubmed,API,abstract,Title - DuKiccoの雑記" class="embed-card embed-blogcard" scrolling="no" frameborder="0" style="display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;"></iframe> Hatena Blog https://hatena.blog 2016-11-16 23:05:34 rich https://dukicco.hatenadiary.jp/entry/2016/11/16/230534 1.0 100%