Import hidden Excel worksheet
How can I import data from a hidden Excel worksheet? If I use Open() with the option Worksheets("TechnicalData"), then it fails as long as the worksheet "TechnicalData" is hidden in my Excel file. As soon as I unhide the worksheet in Excel, the import works again. (Note: Why do I want to import a hidden worksheet? Because I need to import data from a "user friendly" excel sheet, which is not actua...
vince_faller