Hi,

as a first step I would open Excel, start recording a macro, goto the
accounting app., copy the data, go back to excel, insert the data with
all the settings you need, stop recording the macro. Add a button
(forms toolbar) to your sheet and connect it to the macro recorded.
Then make some finetuning in the code recorded.

I think, the macro will do only the insert part for you, you have to
copy yourself and come back to excel with the filled clipboard.

arno

"G Lam" schrieb im Newsbeitrag
...
Hi, the user can copy data from any other (accounting) application
and then
paste them to an Excel sheet. I want to write marco to make the
process more
efficiency. How can I do that.
Thank you
GL