Copy from clipboard?

[G Lam]

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

 

[arno]

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