Hello,
Is there a way to incorporate a third party application using excel macro.
I have made a macro to filter few values at a said time daily and it is working perfect. I have to copy value line by line to paste into a third party application and press ok about 500 plus times a day.
Can I some how add this to existing macro or get a new one.
If it's a 3rd party that is "known" to Excel, then yes. In the VBA window, select Tools - References, and scroll down the list to see if your product is in there. For example, if you wanted to write VBA code that would interact with a Word document, you would select Microsoft Word 14.0 Object Library. That gives you access to the objects, methods, and properties within the Word app, which are similar but different from those within Excel. You will need to search online or contact the vendor for more info.
Acts 4:12
Salvation is found in no one else, for there is no other name under heaven given to mankind by which we must be saved.
Thank you very much for the detailed reply. I will try and if it works fine else I will look into 3rd party task repeat programmes.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks