Dim objExcel As New Excel.Application Dim exWb As Excel.Workbook Dim bookTitle As String Dim bookAutor As String Dim myBooks As Collection Set myBooks = New Collection Set exWb = objExcel.Workbooks.Open("G:\MyFolder\BookShelf.xlsx") Set excelWorkBook = objExcel.Workbooks.Open("G:\Dr Ahmad\Handover\QuickWord.xlsx") ' I need code in this region which could run some kind of Loop on excelWorkBook and give me a collection of book objects ' creating a book from all the records in Sheet1 of excelWorkBook such that the value in column 1 of each row will be the title of ' the book and the value in column 2 of each row will be the author of the book. exWb.Close Set exWb = Nothing
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.
Connect with Certified Experts to gain insight and support on specific technology challenges including:
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE