Set objActiveWkb = objXL.Application.ActiveWorkBook
This format is what Access seemed to accept- I not sure if it did it or not.
Right now i can refer to worksheet(1), worksheet(2) and Worksheet(3) without any problem but when i try to refer to worksheet(4)- i get an "out of range" error.
How many sheets exist before you run the add statement?
Try debugging Sheets.Count before and after the statement. I'm not familiar with the sheets object, and I don't know why access would reject it. The line of code I supplied was direct from a live application.