I need to get the Excel worksheet name using VB6 to enable me to import the spreadsheet into an Access DB without having the worksheet name hardcoded in the VB program. Can anyone tell me how to do this?
Many thanks for any help.
Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!
Or try our Ask An Expert service to answer any of your questions!