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

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

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

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

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

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.