Search results

To explain. I'm trying to open an Excel workbook, update its data from the database, save it to a folder and with a filename chosen by the user. All good so far. Code runs fine on first iteration but then fails with runtime error 91 on second iteration (and presumably the following ones)...

I'm what could be called a professional amateur - been progamming Access apps since access 2000, but rarely in a very serious way. Self-taught (never a good thing) and am a code "tart" in that I use code found in this and similar fora (why reinvent the wheel?). Reluctantly about to post a...