Confirm that by saving the Excel file from .xlsx to .xls as solved the issue

Macro Scheduler can open up Excel files just fine, but connecting to them... no

I just created a "New Microsoft Excel Worksheet.xlsx" and the sheet I'm trying to pull data from is Sheet1

And the same error occurred.

Can someone provide sample code to see what could be wrong with my particular system perhaps?

I triple checked the path, file name and worksheet name. Same error, I have no idea what is going on.

Is there any extension or add-on needed?

Hi everyone, I am simply trying to get data from an Excel file and can't seem to get anything. XLSheetToArray>C:\Macro Scheduler\Test\data\Test.xlsx,TestData,sheetArray Wait>2 ArrayCount>sheetArray,numrows MessageModal>%numrows% This script does not go past the first line. I've checked the file and ...