from the menu in the Visual Basic Editor:
Tools, References
will give you the reference libraries -- scroll to the Microsoft Excel #.# Object Library and check it
Warm Regards,
Crystal
Learn Access -6- Create a Continuous Form in Microsoft Access
https://www.youtube.com/watch?v=norAB9QvIls&list=PL1B2705CCB40CA4CA
- includes many tips for designing forms efficiently
https://www.youtube.com/watch?v=norAB9QvIls&list=PL1B2705CCB40CA4CA
- includes many tips for designing forms efficiently
~ have an awesome day ~
On Friday, January 30, 2015 5:51 PM, Crystal <strive4peace2008@yahoo.com> wrote:
Hi Adam,
reference the Microsoft Excel #.# Object Library
WHERE
#.# correlates to your version -- it will be the only one you can pick ;)
Warm Regards,
Crystal
~ have an awesome day ~
On Friday, January 30, 2015 3:43 PM, "runuphillracing@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
The 'Dim xlRng as Excel.Range' doesn't compile. I'm guessing this means I'm missing a key library. I don't see any available at File - Options - Add Ins (2010). Nor do I see an Access library available in Excel. This is a corp owned computer used in a very restrictive environment, I don't have admin rights on the computer, so I may not be allowed to download any DLLs.
Am I stuck?
Adam
__._,_.___
Posted by: Crystal <strive4peace2008@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (18) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar