ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Automate Cut/Copy/Paste from Excel Cells (https://www.excelbanter.com/excel-programming/356605-automate-cut-copy-paste-excel-cells.html)

Do it the Easy Way

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?



All times are GMT +1. The time now is 05:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com