I’m looping through a local folder loading excel files into a SQL database.
I’m getting errors when the tab names are different.
Can someone help me adjust the Read Range sheet name to a IF condition?
I would like it to read range if the activesheet is “Sheet1” or “Travelers”.
Any help would be greatly appreciated.