Since access should knowĮverything about excel (excel object library is included), this should not happen anyhow, to bypass the problem and check whether the correct excel file is opened, I inserted This code does not work: I get a compile error, "variable not defined", pointing to LookIn:=xlValues. XlBook.Worksheets("LibroSoci").Cells(rowNo, 37) = Me.Nuova_TessElett XlBook.Worksheets("LibroSoci").Cells(rowNo, 12) = Year(Date) RowNo = xlBook.Worksheets("LibroSoci").Range("C:C").Find(What:=NTes, LookIn:=xlValues).Row Set xlSheet = xlBook.Worksheets("LibroSoci") Set xlBook = (ExcelPath & "LibroSoci.xlsm") Set xlapp = CreateObject("Excel.Application") Private Sub AggiornaLibroSoci(NTes As String)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |