+ Reply to Thread
Results 1 to 2 of 2

copy and paste

  1. #1
    Registered User
    Join Date
    07-24-2015
    Location
    USA
    MS-Off Ver
    MS Office 2010
    Posts
    3

    copy and paste

    Hello, I am having a little bit of trouble with this idea:

    For work, I create vouchers for payment, and send those vouchers with payment to our cashier.
    When using our program to create these vouchers, I obviously enter in which ever data and info is applicable for the particular case.

    Though, in the "comments" section of the vouchers, I have to write how much of money was paid, payment type, date & time, location, my name & title, etc.
    Instead of having to type in all this information thirty times a day, I thought that I might try to create a shortcut.

    All the information that I normally type in (Cash or Check Transactions) is in the attached Word document.
    No Macros are currently on the document itself, due to my frustration of searching online for a copy macro, copy and pasting it into the VBA, and having it read me back an error message.

    Now, please keep in mind that I am as green to this Macro stuff as someone who just saw a computer for the first time, so I think that I may have a vague grasp on the concept of it, but it still eludes me on many levels.
    That being said, I'm sure that I am probably just making this way harder than what it really is; and if that's the case, then I definitely do feel silly asking for help here.

    At any rate, what I'm trying to see accomplished is simply this:

    1.) When I open the document, the date and time are already automatically there and correct. (I've just figured this step out earlier today. Acutally very simple. Again, feeling silly in lue of. )

    2.) Restrict the document so that only field text may be entered, and selecting for copy and past purposes. (I've figured out how to "restrict" or "protect" the document for the sake of only entering field text, or for the sake of being able to copy and paste, but not both at the same time.)

    3.) When I click on the "Copy Cash" button, it copies everything in the body of text in the top of the document in between the page break lines, which has a green box labeling it as "CASH", so that I may open my program (Not Microsoft affiliated program) for creating the vouchers, and click on the "comments" section in the creation process and just past the information. (The same goes for the situation when I would click on the "Copy Check" button after I would enter in the check number in the field text box)

    NOTE: No "paste" Macro is needed. All I am trying to do is click a button, and have a certain part of the document copied to the clipboard so that I may manually paste it elsewhere. Any help would be greatly appreciated.

    Like I said before, I'm sure this is probably a very simple task that I'm turning into something more complex than what it has to be.
    Thanks in advance for any advice on how to proceed!
    -Matt
    Attached Files Attached Files

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: copy and paste

    I think it's time you learnt to use Word templates and forms:
    • Fill in a single payment document with your location, name & title, etc.
    • Change your two DATE fields to CREATEDATE fields (select each and press Shift-F9 to expose the field code for editing, then press F9 again when you've changed DATE to CREATEDATE.
    • add formfields, if required for the input of the amount paid (there doesn't seem to be any provision for this in your document).
    • apply 'filling in forms' protection.
    • save that as a new Word template (NOT as a document).
    From now on, whenever you want to create a new payment document, simply double-click on the template and it will generate a new one with your location, name & title, etc. already filled in, together with the current date & time. As for automatically copying data, that can only be done via a macro. In a form, such a macro might be attached to the amount paid fields, as 'on exit' macros, so that any time you exit them the macro will automatically copy the designated data to the clipboard. That said, such copying isn't going to give you a bunch of separate blocks of data for input into whatever your other software is - all it will do is dump the lot into the first place you do a paste in that application.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 01-01-2015, 06:26 AM
  2. How do I make the copy/paste of one column contingent on the copy/paste of another?
    By Kwasimitsu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-23-2014, 01:51 PM
  3. [SOLVED] Copy Paste Loop ends before copy/paste is finished
    By brgr4u in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-08-2013, 04:01 PM
  4. Automate copy and paste and copy and paste back to excel
    By Bmw318be in forum Access Tables & Databases
    Replies: 0
    Last Post: 02-23-2013, 05:42 AM
  5. Replies: 1
    Last Post: 01-16-2013, 05:36 AM
  6. 2 Macro's: only vertical copy/paste action and copy-paste 14 columns to the right.
    By vdongen in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-08-2010, 10:34 AM
  7. Replies: 1
    Last Post: 01-04-2005, 06:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1