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]

Show pictures of what you're starting with, and what the final output should look like.

 

[satish78]

I have attached sample input and output files

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]

I can't unpack rar files.

 

[satish78]

Here you can download

files - Google Drive

drive.google.com

 

[GlennUK]

So, the process is just concatenation. But you want it done for all workbooks in a folder ... that is a VBA question ... what have you tried? What have you researched?

 

[satish78]

I did search forum but did not find suitable one to my need.
Yes, for all workbooks in a folder.
I been doing it manually taking countless hours.
Yes, I want to approach with VBA.

 

[GlennUK]

Look here: Macro to open all files in a folder

 

[satish78]

No, Thats not relevant to my task.

 

[satish78]

Look here: Macro to open all files in a folder

Hi GlennUK,

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