Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automate Cut/Copy/Paste from Excel Cells
I write reports in a database (Access based) for work. A bunch of the
fields I fill out are the same entries over and over again. The software is not great, and it slow (company spent little money for a good application). I figured to get things done faster, I could have canned text in paragraph form in Excel Cells. When I am working in the database fields (which is Office compatible), I would like to use hotkey s to cut and paste from the cells. For Example: If cell A1 in an Excel File named "cannedtext" had the entry "Inspections should be performed weekly" is there a script to write where I could be working in the database where I could hit a hot key such as CTL+TAB+W+I that would automatically paste the phrase without me opening the excel file, copying and pasting? Essentially my end goal is to create a checklist where I could check boxes corresponding to comments I want to make in my report, hit enter, and the script/program to write the report for by opening fields, entering canned text, closing, then opening the next field, and on and on. I cannot alter the existing company database application. Is this possible or is there any guidance? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automate copy / paste | Excel Discussion (Misc queries) | |||
automate copy and paste | Excel Discussion (Misc queries) | |||
Any (clever) way to automate ROW:COL in copy/paste??? | Excel Worksheet Functions | |||
Automate copy.paste of standard sections of emails into Excel | Excel Programming | |||
HELP....Is there a way to automate copy/paste special/transpose - | Excel Worksheet Functions |