Search results

Dear MajP it doesn't work when I save it as module, I got sub or function not defined error. Than I did paste that on my same page with my code, than I saw the code sentence changed the reference but filename was still same. What was my mistake? You can see the pictures attached what happened...

I added more lines below the code for other conditions and I saved that as module. Bu I didn't get the paste where I add the ",replaceInsternationalCharacters(objFile.Name) on my transfer text" :rolleyes:

Dear Majp I think firstly I have to create module Replace International characters than I'll add this line to my transfer text. Is it right?

Thank you the DBguy, I saw that code but don't know to how to use in loop. It's enough to copy these files into a temp folder, rename them file1.csv, file2.csv etc.. after importing delete them. As I said I am not good to solve VB codes 🙏

Hello All I'm not bad on Microsoft Access but I am quite new on VBA codes. I spent almost 24 hours to get solution below. I have several csv files I am importing them to table with bellowing code: Dim FSO As Object, objFolder As Object, objFile As Object Set FSO =...