Error Reading in file with dynamic input, looking for a sheet that doesnt exist,

[wonka1234]

hi all,

1) I have a dynamic input reading an excel file,  looking for a tab that isnt there.

2) I get error  Error: Dynamic Input (177): 1_Due Next 30 Days does not match a sheet or named range in previous_week.xlsx or the file is corrupted.

How can I bypass this? is there a way to insert headers and sheet in my workflow if a tab cannot be read in?

Thanks.

[Raj]

@wonka1234 
you can add a dynamic part into the macro where you can union the headers template as text input so in case you do not have data into the sheet it will not give you the error and you will have the headers

[apathetichell]

use a batch macro - not dynamic input.