Beginner batch macro

[Hamder83]

Hi 

I have a bounch of files with a similar structure.

I want to read them of my folder, like 

c:\Dennis\a.xlsm|||INPUT PARCELS$a1:g7

c:\Dennis\b.xlsm|||INPUT PARCELS$a1:g7

c:\Dennis\c.xlsm|||INPUT PARCELS$a1:g7

Thought i could just add "NPUT PARCELS$a1:g7" to a formula. And then make fullpath = fullpath+|||INPUT PARCELS$a1:g7

But it does not work?

[Maskell_Rascal · Accepted solution]

Hi @Hamder83,

If your files are all the same structure, you don't need a batch macro to accomplish this. You can do it all within the Input tool using a wild card. 

Input Tool configuration:

Data after input:

I added in the FileName to differentiate the files since I just made a copy of the same one three times for this example. 

Let me know if this solves the problem. 

Cheers!

Phil

[Hamder83]

This is great thank you 🙂