Jump from Excel to another application

P

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
 
J

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.
 
J

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.
 
V

vMike

Peter said:
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
 
V

vMike

vMike said:
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
 
G

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top