macro to change out specific words with words in corresponding list

Question

hi all, I'm having trouble thinking through this macro

I have 5 website url's  each one has a word or 2 that is in brackets... I want to replace the words in the brackets with corresponding all numbers in given list

i.e  www. mc.com/reports/surveys/{survey id}/questions/question id/

list to replace []

Survey id

18

19

20

21

22

question id

200

201

202

203

204

205

i know this is easy but im having a difficult time thinking through it.

any help would be appreciated

ThornhillTaylor · Answer

Qiu,

yes! exactly... thanks for that.. i probably wasnt as clear as you have made it

Qiu · Answer

@ThornhillTaylor 
Are you trying to generate all the possible URLs of

www. mc.com/reports/surveys/{survey id}/questions/question id/

with all the combination of your Survey id and question id?

LIke

www. mc.com/reports/surveys/18/questions/200/

www. mc.com/reports/surveys/18/questions/201/

www. mc.com/reports/surveys/18/questions/202/

ThornhillTaylor · Answer

Charlie thanks for your response... im not sure that will work...

i currently have 4 url.. they are all connected to an API.. so each pulls hundreds of rows of data

within the api calls, there are

survey ids

questions ids

answer id

response ids

each survey has all questions assigned to them (on individual api calls)

each question id has answers assigned (on api calls..

each API call is a different url

so we are talking about probably 100 API calls daily/weekly

i think a macro is necessary, just having trouble setting it up...