How to call worksheet name?

[cheer]

Dim xl As Excel.Application
Dim xlWrkSht As Excel.Worksheet
Dim xlWrkBk As Excel.Workbook

Set xl = CreateObject("Excel.Application")
Set xlWrkBk = GetObject(strBOMExcelFilePath)
Set xlWrkSht = xlWrkBk.Worksheets(1)

I have this piece code here http://www.access-programmers.co.uk/forums/showthread.php?t=212746

Can anyone suggest how to call rewrite the code for the highlight in red color so that the above function can call different worksheet. Currently the code only manage to call the FIRST worksheet

 

[boblarson]

Let's say you have a combo box that has the list of worksheets in it (hmm, sound familiar ). You could use

Set xlWrkSht = xlWrkBk.Worksheets(Me.ComboBoxNameHere)

 

[cheer]

Thanks for the info above. How to load worksheet name into combo box?

 

[boblarson]

Thanks for the info above. How to load worksheet name into combo box?

Umm, I already gave you that exact answer here:
http://www.access-programmers.co.uk/forums/showthread.php?t=212746