Recent content by BUzzbomb23

Thanks Jiri - Unchecking the Excel ref and using Late Binding, I still get 1004 error. Obviously with early binding, if I uncheck the Excel ref I get a compile error & then have to stop the process before recreating the Excel ref... and unsurprisingly once I've re-added the ref it fails with the...

Workbook opens fine via Windows GUI. It also opens fine if I put the code in an .mdb file and run with Access 2003. If I open the same .mdb with Access 2010, the workbook opens, I then get the 1004 error...

Problem occurs irrespective of whether the db was created on x64 or x32 & occurs with any Excel spreadsheet. I and an IT colleague have tried creating db's from scratch & with different spreadsheets. Protection isn't an issue - I often use read-only templates to prevent me from accidentally...

Thanks Adam. I get the same 1004 error at the "Set xlbook..." line. In both cases, the spreadsheet opens & then the error occurs.

Thanks Ranman256. The References are fine - none missing & all the same versions as works from Access 2003. Thanks Gasman - my preferred option would have been to have left everything on Access 2003... (I much prefer the interface to that in 2010), but it's a corporate decision. Access 2003 is...

We're switching over from Access 2003 to Access 2007 & have a mix. of Windows 7 (32 bit) & Windows 10 (64 bit) machines. I'm having problems converting some mdb databases to accdb, where code works on the several machines, but not on my Win 7 (32 bit) work laptop. The problem occurs when I try...