View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
vMike vMike is offline
external usenet poster
 
Posts: 7
Default 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