Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Jump from Excel to another application
I often want to jump from an excel (2007) cell to an form (screen) in
the erp-system Dynamics Ax 4.0. E.g. You have a pivottable in excel with all itemnumbers. If you rightclick at one of the numbers my idea was that you was offered "Go to Ax" and was send to an Ax screen showing the itemtable. I don't know how it schould be possible, but I am sure that it would be appriciated. Best regards Peter |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Jump from Excel to another application
What you would need to do is the open the application which can easily be
done and then activating the apllication window. Heres is the problem. You would only be able to use short cut keys to move around in the application. So yo can only perform functions where there is a short cut like on excel if you look file menu you will see the shortcut is Cntl+S. This is the shortcut for saving a file. The other option is if the application is web based. You could run the application by opening a web browser and performing the commands you want through a web application. "Peter" wrote: I often want to jump from an excel (2007) cell to an form (screen) in the erp-system Dynamics Ax 4.0. E.g. You have a pivottable in excel with all itemnumbers. If you rightclick at one of the numbers my idea was that you was offered "Go to Ax" and was send to an Ax screen showing the itemtable. I don't know how it schould be possible, but I am sure that it would be appriciated. Best regards Peter |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Jump from Excel to another application
What you would need to do is the open the application which can easily be
done and then activating the apllication window. Heres is the problem. You would only be able to use short cut keys to move around in the application. So yo can only perform functions where there is a short cut like on excel if you look file menu you will see the shortcut is Cntl+S. This is the shortcut for saving a file. The other option is if the application is web based. You could run the application by opening a web browser and performing the commands you want through a web application. "Peter" wrote: I often want to jump from an excel (2007) cell to an form (screen) in the erp-system Dynamics Ax 4.0. E.g. You have a pivottable in excel with all itemnumbers. If you rightclick at one of the numbers my idea was that you was offered "Go to Ax" and was send to an Ax screen showing the itemtable. I don't know how it schould be possible, but I am sure that it would be appriciated. Best regards Peter |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Jump from Excel to another application
"Peter" wrote in message ... I often want to jump from an excel (2007) cell to an form (screen) in the erp-system Dynamics Ax 4.0. E.g. You have a pivottable in excel with all itemnumbers. If you rightclick at one of the numbers my idea was that you was offered "Go to Ax" and was send to an Ax screen showing the itemtable. I don't know how it schould be possible, but I am sure that it would be appriciated. Best regards Peter I think you want to look into the Shell command. for example try typing test = Shell("cmd", vbMaximizedFocus) into the immediate window Mike |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Jump from Excel to another application
"vMike" wrote in message ... "Peter" wrote in message ... I often want to jump from an excel (2007) cell to an form (screen) in the erp-system Dynamics Ax 4.0. E.g. You have a pivottable in excel with all itemnumbers. If you rightclick at one of the numbers my idea was that you was offered "Go to Ax" and was send to an Ax screen showing the itemtable. I don't know how it schould be possible, but I am sure that it would be appriciated. Best regards Peter I think you want to look into the Shell command. for example try typing test = Shell("cmd", vbMaximizedFocus) into the immediate window Mike Also, once activated you would use AppActivate to bring into focus. Mike |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Jump from Excel to another application
Options:
1. Check the Ax documentation and see if it supports either OLE, DDE, COM, or OLE Automation. If OLE Automation is supported then something *can* be made to work 2. Check your Excel dictionary references and see if there are any VB libraries that might be used to send data from Excel to Ax. 3. See if the Ax executable can be open with command line arguments where an item can be designated on the command line. Then see if you can use that. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Execute a Macro from one excel Application to another Application | Excel Programming | |||
How do I jump between sheets in Excel using keyboard? | Excel Discussion (Misc queries) | |||
How do I get Excel to jump to the next row using VB code? | Excel Programming | |||
need to jump down 4 cells, gather data, jump another 4 | Excel Programming | |||
macro to close excel application other than application.quit | Excel Programming |