VBA Macros - Engraving Etc. Forum

<body> <h1>Full Version: <a href="https://www.engravingetc.org:443/archive/index.php?webtag=EE&msg=4230.22">VBA Macros</a></h1><a name="a4230_22"></a><p><b>From: Shaddy</b> [<a href="lmessages.php?webtag=EE&msg=4230.22">#22</a>]<br /> 1 Jul 2006<br /><b>To: Carl (CSEWELL)</b> [<a href="lmessages.php?webtag=EE&msg=4230.21">#21</a>] 1 Jul 2006</p> <p>After the holiday break, I'll purdy up the macro for adding text to different objects as a replacement to the print merge. Well, not a replacement, Print merge is a powerful feature. Maybe it's more of a supplement.</p> <p>There's a few macros that support this funtion that coule probably be applied to different processes. One is a macro that changes the "name" of an object of everything selected (the name that you can see in the object manager). That makes it easier for VBA to be selective on the things it alters. Such as, on a name badge you could have a generic company name called "Company", and a personalized name called "Name" or whatever makes sense to you. Then my code can more easily either change all the company names to the next company you make for, or go out and look at your list of names to fill in the other boxes with (sizing font accordingly for longer names).</p> <p>Looking forward to seeing where this goes. Might even warrant a new folder here <span class="e_grin" title=":D"><span class="e__">:D</span> </span></p> <p>Shaddy</p><hr /><a name="a4230_23"></a><p><b>From: UncleSteve</b> [<a href="lmessages.php?webtag=EE&msg=4230.23">#23</a>]<br /> 1 Jul 2006<br /><b>To: Shaddy</b> [<a href="lmessages.php?webtag=EE&msg=4230.22">#22</a>] 2 Jul 2006</p> Hmmm..... sounds like premium content to me! <span class="e_wink" title=";-)"><span class="e__">;-)</span> </span><br /> <br /> (Are you reading this, David?)<br /> <br /> <hr /><a name="a4230_24"></a><p><b>From: Carl (CSEWELL)</b> [<a href="lmessages.php?webtag=EE&msg=4230.24">#24</a>]<br /> 1 Jul 2006<br /><b>To: Shaddy</b> [<a href="lmessages.php?webtag=EE&msg=4230.22">#22</a>] 2 Jul 2006</p> Are you interested in trying a few of my macros AT YOUR OWN RISK? I can e-mail them to you as GMS files. The XYCopy might be a good start.<br /> <br /> I completed a beta version of the print merge last night. It reads from a hard-coded text filename (temporary only!), copies the selected text and replaces the first word (of the selected text) with the name (one per line) in the text file. The copying is an extension of the XYCopy macro. Not at all elegantly encoded, but it appears to work. It doesn't work correctly with first name and last name, just yet, because of the property I selected to make the replacement. There's probably a better way. It might be easier to use a 'FIELD' as you suggested, but that might be too involved for a novice user to set up.<br /> <br /> We'll have to get David to pony up some development funds. ;^) <hr /><a name="a4230_25"></a><p><b>From: Stunt Engraver (DGL)</b> [<a href="lmessages.php?webtag=EE&msg=4230.25">#25</a>]<br /> 2 Jul 2006<br /><b>To: Carl (CSEWELL)</b> [<a href="lmessages.php?webtag=EE&msg=4230.24">#24</a>] 2 Jul 2006</p> <div class="quotetext" id="quote"><b>quote: </b></div><div class="quote">We'll have to get David to pony up some development funds.</div><br /> <br /> Carl,<br /> <br /> I've been following this thread with extreme interest. I don't want to create a stir by mentioning the dreaded "P" word, but these are exactly the types of projects I want to fund. <hr /><a name="a4230_26"></a><p><b>From: Carl (CSEWELL)</b> [<a href="lmessages.php?webtag=EE&msg=4230.26">#26</a>]<br /> 2 Jul 2006<br /><b>To: Stunt Engraver (DGL)</b> [<a href="lmessages.php?webtag=EE&msg=4230.25">#25</a>] 2 Jul 2006</p> Just joking David. Once a macro is released, it can easily be copied. We can protect the source code with passwords, but that only keeps the honest folks out. I guess funding would support development and might bring in some better programmers.<br /> <br /> There are also VB protection schemes. One I've used on my CreateADMx software and it seems to work pretty good. It's based on a 2-key pair. One key is generated at the installation site and the liberation is returned based on the first key. Sounds complicated, but it's fairly easy to implement. I'm not sure how well it would play for CorelDraw macros.<br /> <br /> I guess I'd rather see the code released for further development, but we'll see how it plays out. There may only be a few macros that would beneficial to the engraving industry. <hr /><a name="a4230_27"></a><p><b>From: Stunt Engraver (DGL)</b> [<a href="lmessages.php?webtag=EE&msg=4230.27">#27</a>]<br /> 2 Jul 2006<br /><b>To: Carl (CSEWELL)</b> [<a href="lmessages.php?webtag=EE&msg=4230.26">#26</a>] 2 Jul 2006</p> Carl,<br /> <br /> I wasn't so concerned about the "security" of the macros as much as having something developed for the betterment of the engraving industry.<br /> <br /> If that can be achieved through volunteerism, fine.<br /> <br /> If, as you suggest, a financial incentive would spur things along and increase the quality of the end result (which is often the case) I'm for that as well. <hr /><p>Message 4230.28 was deleted</p> <hr /><a name="a4230_29"></a><p><b>From: Carl (CSEWELL)</b> [<a href="lmessages.php?webtag=EE&msg=4230.29">#29</a>]<br /> 2 Jul 2006<br /><b>To: Stunt Engraver (DGL)</b> [<a href="lmessages.php?webtag=EE&msg=4230.27">#27</a>] 2 Jul 2006</p> <div class="quotetext" id="quote"><b>quote: </b></div><div class="quote">If, as you suggest, a financial incentive would spur things along and increase the quality of the end result (which is often the case) I'm for that as well.</div><br /> <br /> I don't need fame. I can always use more money! Maybe we'll get a REAL programmer to step up to the challenge?!?!?<br /> <br /> Do we need to halt development until the P-word site comes online? ;^)<p class="edit_text">EDITED: 2 Jul 2006 by CSEWELL</p> <hr /><a name="a4230_30"></a><p><b>From: Stunt Engraver (DGL)</b> [<a href="lmessages.php?webtag=EE&msg=4230.30">#30</a>]<br /> 2 Jul 2006<br /><b>To: Carl (CSEWELL)</b> [<a href="lmessages.php?webtag=EE&msg=4230.29">#29</a>] 2 Jul 2006</p> Carl,<br /> <br /> You said the "P" word. <span class="e_embarrassed" title=":-$"><span class="e__">:-$</span> </span><br /> <br /> It's a bad word, depending on which direction the "P" is heading. <span class="e_smile" title=":-)"><span class="e__">:-)</span> </span><br /> <br /> My generosity will be limited, until we take that step. <span class="e_cringe" title=">.<"><span class="e__">>.<</span> </span> <hr /><a name="a4230_31"></a><p><b>From: sprinter</b> [<a href="lmessages.php?webtag=EE&msg=4230.31">#31</a>]<br /> 2 Jul 2006<br /><b>To: ALL</b></p> I've been following this thread and I still haven't found any reasoning of how VBA's would be of true value to engravers. Most of the features are already in Corel that have been mentioned here. VBA's are more suited to CAD designers having to make many repetitive changes over layers, which is not needed for engraving tasks. It takes far longer to write or even evoke the macros than to make a few manual changes for the engravers needs. The only macros I can think of that would be of benefit is to make repetitive templetes or doing gang engraving of multiple items with the same text (golf tees would be an example). Members would be better off learning the advanced features of corel than learning the VBA language. <hr /><a name="a4230_32"></a><p><b>From: Carl (CSEWELL)</b> [<a href="lmessages.php?webtag=EE&msg=4230.32">#32</a>]<br /> 2 Jul 2006<br /><b>To: sprinter</b> [<a href="lmessages.php?webtag=EE&msg=4230.31">#31</a>] 2 Jul 2006</p> Thanks! That's the type of input I'm looking for.<br /> <br /> I happen to use several macros and will definitely use more since my 'style' is based on my many years of using advanced CAD programs and relying on the advanced features that they have. Every shortcut that I can take, even if it takes significant time to develop, has the potential to make me more profitable and improve the service, quality, and accuracy to my customers.<br /> <br /> Starting VBA macros in CorelDraw can be as simple as any other CorelDraw command or tool. They can be added to toolbars in just a few seconds. I have a flyout that has just macros with their own icon that makes them easy for me to run. It would be a good idea to export your workspace so it can be easily(?) restored should a problem develop.<br /> <br /> I wouldn't recommend anyone embarking on learning VBA just for CorelDraw. I think the learning curve would be far too steep for most people that don't have a programming background. Then again, some people might enjoy the challenge.<br /> <br /> I do believe that there is potential for even inexperienced users to take advantage of existing VBA macros, even it is only one or two. And that may not be enough for most people to mess with them. So far, the one that people believe to be the best candidate is an alternative for 'print merge'. Are there any others? <hr /><a name="a4230_33"></a><p><b>From: Carl (CSEWELL)</b> [<a href="lmessages.php?webtag=EE&msg=4230.33">#33</a>]<br /> 2 Jul 2006<br /><b>To: Stunt Engraver (DGL)</b> [<a href="lmessages.php?webtag=EE&msg=4230.30">#30</a>] 2 Jul 2006</p> <div class="quotetext" id="quote"><b>quote: </b></div><div class="quote">You said the "P" word.</div><br /> <br /> So very, very sorry. I'll try to be a better engraver and mind my "Ps" and "Qs".<br /> <br /> {Am I banished forever, or just for a probationary period? I edited my post. Does that lessen the sentence?} <hr /><a name="a4230_34"></a><p><b>From: Stunt Engraver (DGL)</b> [<a href="lmessages.php?webtag=EE&msg=4230.34">#34</a>]<br /> 2 Jul 2006<br /><b>To: Carl (CSEWELL)</b> [<a href="lmessages.php?webtag=EE&msg=4230.33">#33</a>] 2 Jul 2006</p> Carl,<br /> <br /> I'm feeling benevolent today. No time-outs. <span class="e_tongue" title=":P"><span class="e__">:P</span> </span> <hr /><a name="a4230_35"></a><p><b>From: Carl (CSEWELL)</b> [<a href="lmessages.php?webtag=EE&msg=4230.35">#35</a>]<br /> 7 Jul 2006<br /><b>To: ALL</b></p> All;<br /> <br /> I just spent several minutes counting letters on a plaque to see if my guesstimate pricing was even close. It wasn't. So I spent 5 minutes creating a CorelDraw VBA macro that will count all the letters in the current selection set (must be text, not curves). It doesn't count CR, FF, LF, etc. For those that are ASCII literate the range is between 32 and 127, non-inclusive.<br /> <br /> The macro is about 22 lines long, but only about half of them are absolutely necessary.<br /> <br /> Would this macro be of any use to anyone? <hr /><p align="center">Show messages:  <a href="lmessages.php?webtag=EE&msg=4230.1">1</a>  <a href="lmessages.php?webtag=EE&msg=4230.2">2-21</a>  22-35</p> <h4><a href="lthread_list.php?webtag=EE">Back to thread list</a> | <a href="llogout.php?webtag=EE">Login</a></h4> <h6>© 2024 <a href="http://www.beehiveforum.net/" target="_blank">Project Beehive Forum</a></h6> </body>