Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy from clipboard?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy from clipboard?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy/paste without using clipboard? | Excel Discussion (Misc queries) | |||
copy files to clipboard | Excel Discussion (Misc queries) | |||
clipboard copy & paste | Excel Discussion (Misc queries) | |||
Clear Clipboard after Copy | Excel Discussion (Misc queries) | |||
Can't copy ActiveSheet to clipboard | Excel Programming |