Hi,
I am trying to populate a listbox with Excel worksheet names from a ADO connection to a spreadsheet. What property do I need bring up the worksheet index and then find out the name of that sheet.
Is it somehow possible to do this or do you have to use a different approach?
Thanks
I am trying to populate a listbox with Excel worksheet names from a ADO connection to a spreadsheet. What property do I need bring up the worksheet index and then find out the name of that sheet.
Is it somehow possible to do this or do you have to use a different approach?
Thanks