Re: How to create a macro to extract information from other programs like Chainlinx
- From: Jim Gordon MVP <goldkey74@xxxxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 15 Oct 2005 14:17:38 -0400
Microsoft Excel has the ability to interact with AppleScript and Visual Basic. Most other programs have at least some AppleScript functionality. You can check an application's AppleScript dictionary by dropping the application's icon onto the AppleScript Script Editor icon.
AppleScript can even maniuplate programs via the user interface, so there is almost always a way to get Mac programs to work with each other, which is a reason why Macintosh is the best way to go when you need automation.
So the answer is most likely that yes, it's most likely possible to have information from other applications be programatically brought into Excel.
The briefest explanation is that you would most likely be best doing this via AppleScript alone or in combination with Visual Basic.
-- Jim Gordon Mac MVP MVP FAQ <http://mvp.support.microsoft.com/default.aspx?scid=fh;EN-US;mvpfaqs>
Is it possible to create a macro which can extract information from other softwares such as Chainlinx, PMS etc?
If yes, could you please explain briefly, how?
- Prev by Date: Re: Format Cell doesn't
- Next by Date: Re: PC Pivot Tables in MAC won't work
- Previous by thread: How to create a macro to extract information from other programs like Chainlinx
- Next by thread: How to create a macro to extract information from other programs like Chainlinx