How to Combine 3 strings from 2 workbooks

[satish78]

Hi Friends,

I did check other posts on Mrexcel forum but did not find suitable to my needs.
Right now I am doing this manually.
I have Name folder with workbooks names like names1(ColumnA:Adata), names2(ColumnA:A data) and so on. And another workbook on desktop with name Strings(with data in ColumnA1 and ColumnB1).
I need to combine ColumnA1(stringsworkbook) and ColumnA:A(names1) and ColumnB1(Stringsworkbook).
I need to do this for all workbooks in that Names folder and output results in Namesoutput folder
Note: &qs=&format=rss&count=50 in this string, ending number does not change.

Workbooks and sample final out attached to look into.

Hightail Spaces

Hightail Spaces lets you send unlimited files, of any size, to anyone. Collaborate with your team and evolve your work.

spaces.hightail.com

 

[GlennUK]

Hi GlennUK,

Can you help me? I rechecked but does work on my query.

Explain what you checked/tried, and then explain in what way it does not work for you.