VBA adding a row (with a few values) to each workbook in a folder

[Vexorg]

Hi Guys,

The purpose of this is to avoid the 'Conversion Type Error' when importing into MS Access.

I need to add a row Above A2 to about 300 files (directory). In the added row I will also have to add the value 'Delete' to cells K2 and Q2. The ultimate goal is to not have to do this manually.

Is this possible?

 

[Trevor G]

Pleased to read this has helped you find a solution.