Okay, this time I've got it right--I have an Access question! :-)
I found some VBA code that does exactly what I need in that it sends Query results to an Excel file. The code requires that the Microsoft Excel 14.0 Object Library is available. By default it seems to be unchecked so I've gone in and checked it. Once I do that everything works. But, what I need to do is find a way to "check" this reference on other people's computers who will be using the Access database. There's no way I'd be able to get them to do that the the way I had to so I'm wondering if there is a way to do this with some VBA so they won't have to get into the guts of the database to turn on the Excel Library Reference.
Thanks for any help you can offer!
Jerry
I found some VBA code that does exactly what I need in that it sends Query results to an Excel file. The code requires that the Microsoft Excel 14.0 Object Library is available. By default it seems to be unchecked so I've gone in and checked it. Once I do that everything works. But, what I need to do is find a way to "check" this reference on other people's computers who will be using the Access database. There's no way I'd be able to get them to do that the the way I had to so I'm wondering if there is a way to do this with some VBA so they won't have to get into the guts of the database to turn on the Excel Library Reference.
Thanks for any help you can offer!
Jerry
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar