Using macros or VBA in MS Word to interrogate the crossref database

Hello!

I am just wondering, does anyone use macros or VBA in MS Word to interrogate the crossref database and replace unstructured citations in Word documents with structured references?

Thanks!

1 Like

Not currently, though it’s something we’re actively looking at. We do already do something similar with the PubMed database, however. We don’t directly query it from the macro, but use the macro to parse text and pass it to an external app which queries the database.

1 Like

Hi Rhiannon,

Thanks for your answer. Which app is it you use, if you don’t mind me asking?

Thanks

It’s something we developed ourselves in AppleScript that takes the processed text from Word and builds Entrez queries and runs them using curl.

1 Like