Recent content by billfold

I got it, just had to move that call to the end of the loop. Thank you making me think on that one!

Thanks for the help everyone! That works, but now I get a run-time error after the last file is moved, because it is still looking for a file when the directory is empty. It fails at the 'SET' line in the code below. I tried the ' Set xlWrkBk = Nothing ' statement in a couple of spots, but...

Just wanted to introduce myself. My name is Bill, and I am a Business Analyst with little experience in MS Access, and VBA in general. I can do just enough to screw things up, but I would like that to change. I have been using these forums for some answers, and finally decided to join. Seems...

I am trying to write a VBA Module that will look in a directory for Excel files with a specific file prefix, and then import specified cells into a temp table. Once it processes the first file, it copies the file to another folder, and then kills the file. However, when I run my current code...