Search results

Thanks for your further replies! The GetObject-Method also didn't do the trick for me (as well as CreateObject, which I already used before with a closed Excel-App). I don't understand why the variable "strName" should be a wrong reference to the file in combination with the path, as it should...

Thanks for both of your answers! Unfortunately I forgot to add to the OP, that I already tried to open the workbook with only the "strName"-Variable. The above code was just a variation. Do you have another idea where the problem could be? It seems to be computer-related or directory-related...

Hi, I inserted a button in one Access-form, that is bound to a VBA-module intended to transfer the values of the form's controls to an already existing Excel-worksheet. My problem is, that I simply cannot seem to open this Excel-file, even if this should be a rather simple task. Below, I...