Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automate copy / paste PAULGOR via OfficeKB.com Excel Discussion (Misc queries) 1 December 24th 09 03:38 PM
automate copy and paste Richard Excel Discussion (Misc queries) 1 September 23rd 08 11:32 PM
Any (clever) way to automate ROW:COL in copy/paste??? Zilla[_2_] Excel Worksheet Functions 7 March 26th 07 02:30 AM
Automate copy.paste of standard sections of emails into Excel Bill Excel Programming 0 May 17th 05 03:36 AM
HELP....Is there a way to automate copy/paste special/transpose - Mel Excel Worksheet Functions 7 March 28th 05 11:17 PM


All times are GMT +1. The time now is 08:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"