copy data from excel for Microsoft Dynamics AX

[Alaa_Ali]

Hi all,

is there any way to copy data from excel to another system like MS AX

If there is available code it will do the following :

in the other system right arrow go right open drop menu choose ob-111

then go right open drop menu choose 1

then copy data in column X to next box ( I will press arrow key to right too before copy)

then right arrow twise , then copy form column X to next box

then go down (down arrow)

then repeat the process until the data is ended in excel

Thanks in advance

 

[Chihiro]

Have a read of links below.
https://technet.microsoft.com/en-us/library/aa570108.aspx
https://technet.microsoft.com/en-us/library/gg731845.aspx
https://technet.microsoft.com/en-us/library/hh575254.aspx

You'd have better luck asking your question in MS Dynamics AX forum. This is Excel forum and most of us don't have access to MS Dynamics AX I'd imagine.

https://community.dynamics.com/ax/f/33

 

[samwilliam]

You can copy information from some grids in Microsoft Dynamics AX and paste that information into a Microsoft Excel worksheet.

1. In the grid of the active form, select the rows to copy.
   To select several rows, hold down the CTRL key while clicking the individual rows to select. To select several consecutive rows, select the first row, hold down the SHIFT key, and then click the last row to select. To select all the rows in the grid, click File > Edit > Select all.
   Note
2. Click File > Edit > Copy to copy the selected rows.
3. Open a Microsoft Excel worksheet, select the cell where the information should start in the worksheet, and then press CTRL+V to paste the information from the grid in Microsoft Dynamics AX to the worksheet.

Note

In some grids, you cannot select multiple rows at the same time.