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




Reply With Quote