Search results

Yeah, I realize what I was doing wrong thanks to chergh. I'm new to programming and the sub procedure above is kind of a Frankenstein of snippets that I've mashed together for my own purposes. Fortunately though, because of this valuable learning experience I don't need a haircut anymore.

Ok, I got this mostly working. The only problem I have left is during importing. Some of the workbooks raise a dialog box asking if I want to save the workbook. I guess because the dialog is raised through excel, the Access macro keeps executing and ignores the dialog. This causes Access to...

Hello, I'm trying to write some vba that will import all excel spreadsheets in a folder into an access database. I had this working yesterday and now today I'm getting this 3051 error, saying the file is either open or has insufficient access permission. The permissions on the folder and...