Forum Discussion
Solved
DataFormat.Error when connecting to folder of Excel workbooks
I need to make a report based on data in a shared folder that contains Excel workbooks for each week. All the workbooks are structured identically (same tabs, headers, etc). Each workbook contains se...
I figured it out. There are N/A and REF errors in some of the workbooks that I'm trying to query from.
I figured it out. There are N/A and REF errors in some of the workbooks that I'm trying to query from.