Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Writing Macro for extracting info from other softwares
Hi,
Is it possible to create a macro to extract information from other softwares like Chainlinx, PMS etc.? If yes, could you please explain briefly, how to do it? Thanks. |
#2
|
|||
|
|||
first try the macro recorder
|
#3
|
|||
|
|||
i came to this group only after few unsuccessful attempts. anyway the
problem with the macro that i want is that excel's unable to get the info from other software. For eg. if i record a macro after punching a client id and i want excel to get all the information of that client from other software; it simply won't do. As soon as i run it, it repeats with the client id with which it was recorded. Hope i've been able to clarify it. Now would you please tell me if it's possible? Thanks. |
#4
|
|||
|
|||
i came to this group only after few unsuccessful attempts. anyway the
problem with the macro that i want is that excel's unable to get the info from other software. For eg. if i record a macro after punching a client id and i want excel to get all the information of that client from other software; it simply won't do. As soon as i run it, it repeats with the client id with which it was recorded. Hope i've been able to clarify it. Now would you please tell me if it's possible? Thanks. |
#5
|
|||
|
|||
I don't know anything about the programs you listed, but if they are database programs and they are ODBC compliant, then you can get
data from them with some code or by using the external data feature in Excel which uses Microsoft Query, which is a little bit of a dinosaur. By the way, you only need to post your question once in the same thread. If you want to post again later, you should start a new thread instead of replying to your own question. Just a thought. -- RMC,CPA "Skywalker" wrote in message oups.com... Hi, Is it possible to create a macro to extract information from other softwares like Chainlinx, PMS etc.? If yes, could you please explain briefly, how to do it? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Writing a Macro to add decimal | Excel Worksheet Functions | |||
writing macro | New Users to Excel | |||
Adding info in the row at the bottom using macro? | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) |