Search results

yes, i have this in the code.

yes, i have this in the code.

the way it work is when i go to import, i get the windows dialog box to select the files to import. then vba opens each file not at the same time but individually, imports the information and then closes that files and moves on to the next one. but for some reason when i select mora than 36...

Here is the code to select the files, yes it does loop through all the files and closes each one after each import. Function FindFileLocation(initDir As String, header As String, Optional onlyFileName As String) As String Dim gfni As adh_accOfficeGetFileNameInfo FindNewFile: If...

right now i can select all the files i want imported but after the 36th file i get the msg and it stops importing. so basically i can do 36 at a time.

Hello everyone, i have an access database which i use to import data from multiple excel files into 3 different tables. However, i am limited on the number of files i can import without getting the msg "("The current file " & currentExcelFile & " is not in Excel or Lotus format and will be...

Hello everyone, i'm a newbie from Dallas, TX