Click here to Skip to main content
15,867,330 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
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
Posted
Updated 29-Nov-22 0:20am

1 solution

Your starting point is crossref.org - e.g. A non-technical introduction to our API - Crossref[^]
Plenty of examples of using VBA to interact with an API - see vba api call - Google Search[^]
When you have written some code do come back if you get stuck, but please read the posting guidelines - you will need to give details of your problem, and include the code that you have tried
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900