Jump from Excel to another application

[Peter]

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

 

[Joel]

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.

 

[Joel]

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.

 

[vMike]

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

 

[vMike]

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

 

[gimme_this_gimme_that]

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.