Hi
I have 4 sheets in workbook, I open as
In code below I must choice sheet when change monthCode:Set objBook = objXl.Workbooks.Open(sNovo_Arquivo, , , , "")
Set objSheet = objBook.ActiveSheet
This code is inside VBCode:nSheet =0
Do While Not rsEvento.EOF
nMesAnterior = Month(rsEvento!DATA_INICIO)
nSheet = nSheet + 1
objBook.Sheets(nSheet).Select
.....
But when I open file all data are in unique sheet, I have data for month 1,2,3 and April
How can I to choice sheet when change month
