joeloyzaga Posted March 21, 2013 Posted March 21, 2013 do I have to open a spreadsheet before attaching to it to use excelSheetList?
abberration Posted March 21, 2013 Posted March 21, 2013 You can open it with the 2nd parameter of 0, which will open it in a hidden fashion, not visible. I have found this method to be much faster as well. Easy MP3 | Software Installer | Password Manager
water Posted March 22, 2013 Posted March 22, 2013 You have to open the Workbook (=the Excel file) before you can get the list of worksheets. Use _ExcelBookOpen and set parameter 2 to 0 as suggested. My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now