Beginner batch macro

Question

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 Answer

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