I would like to create VBA script for fetching the details from online. If Input DOC files are less than six authors(Pl. find Voesenek L, Rijnders J, Peters A J M et al.) with et al., need the VBA Script should retrieve the remaining authors from the crossref web site and fill the authors to DOC files back to Ms-word.
Input DOC files with References are:
Voesenek L, Rijnders J, Peters A J M et al. (2004). Plant hormones regulate fast shoot elongation under water: from genes to communities.
Now you are found only 3 Authors are found with et al. text. Need to found this text to CROSSREF WEB and fetch the Remaining Authors and paste to DOC files back. Should be like below:
Expected Output below:
Voesenek L, Rijnders J, Peters A J M, van de Steeg H. M. and de Kroon H. (2004). Plant hormones regulate fast shoot elongation under water: from genes to communities.
How to do through VBA Script. Any ideas greatly helpful for me.
What I have tried:
I would like to connect MS-Word to CROSSREF WebSite Link