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
Bookmarks