Welcome to Tek-Tips. You can learn a lot here. Check the FAQs.
Over the decades, I've used Excel VBA to access other application's Object Libraries and send and receive data between Excel and that application.
Have you added the appropriate library or libraries to VBA Tools>References?
Then how can you know what objects to use? You need to know something about object models in general and the object model for any application. Maybe there's a web site that you can find. That's a good start.
I found, in addition to all that, that the Watch Window was/is a great help in discovering what property to use in a particular instance.
faq707-4594.
Don't forget to post your specific questions here at Tek-Tips.
Skip,
Just traded in my OLD subtlety...
for a NUance!![[tongue] [tongue] [tongue]](/data/assets/smilies/tongue.gif)
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein
You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!