Merging Excel Files? - Engraving Etc. Forum

<body> <h1>Full Version: <a href="https://www.engravingetc.org:443/archive/index.php?webtag=EE&msg=4712.3">Merging Excel Files?</a></h1><a name="a4712_3"></a><p><b>From: logojohn</b> [<a href="lmessages.php?webtag=EE&msg=4712.3">#3</a>]<br /> 28 Aug 2006<br /><b>To: Melissa (OAKBROOK)</b> [<a href="lmessages.php?webtag=EE&msg=4712.1">#1</a>] 28 Aug 2006</p> Do you have a way to open excel files?<br /> If not, download open office, that will do it.<br /> <br /> There are several macros that generous members have developed for manipulating the text(replace tabs puts the excel tabbed files on separate lines), duplicating multiple items on a plate(copy xy) and copying and pasting text directly in a coreldraw file(copy paste) before going to the printer. There is also one to remove unwanted characters or spaces at the beginning of each line if the find and replace option won't do it.<br /> <br /> Check them out in the macros folder.<br /> <br /> I was beginning to think I was the only one that had that type of tedious but lucarative jobs to do without spending all day on it.<br /> <br /> <br /> . <hr /><a name="a4712_4"></a><p><b>From: Melissa (OAKBROOK)</b> [<a href="lmessages.php?webtag=EE&msg=4712.4">#4</a>]<br /> 28 Aug 2006<br /><b>To: logojohn</b> [<a href="lmessages.php?webtag=EE&msg=4712.3">#3</a>] 28 Aug 2006</p> <p>All day? We estimate it might take 2 months to get through this. Which is fine with the client, they expect it will take quite awhile to install them all on each correct seat.</p> <p>I will check the macros, Thank you so much!<br /> <span class="e_grin" title=":D"><span class="e__">:D</span> </span></p> <hr /><a name="a4712_5"></a><p><b>From: Shaddy</b> [<a href="lmessages.php?webtag=EE&msg=4712.5">#5</a>]<br /> 28 Aug 2006<br /><b>To: Melissa (OAKBROOK)</b> [<a href="lmessages.php?webtag=EE&msg=4712.1">#1</a>] 29 Aug 2006</p> <p>Can you explain what the text lines will be?<br /> First, liddle, last names? Title?<br /> Do you need to have a serial number as well as the 3 text boxes?<br /> Will the layout matter, as in, if there is only 1 text line, will it be in the same position as if there were 3? Or will the ones with 1 line need to be centered better?</p> <p>What version of Corel are you using?</p> <p>I might be able to help with a macro. I have one that can import up to 4 columns from Excel, but the layout might be a problem as mine expects the layout to already be in place and consistant.</p> <p>Might not be too hard to customize into one centered text box though, just depends on your answers.</p> <p>EDIT: PS, maybe a screen print of what a plate with one line and a plate with three look like. Make one up by hand in Corel then position them so you can see them all, then pres ALT-Prt Scrn (or ALT-Print Screen) on the keyboard. Then go to a graphics program and paste. Then crop and save and post.</p> <p>Shaddy</p><p class="edit_text">EDITED: 28 Aug 2006 by SHADDY</p> <hr /><a name="a4712_6"></a><p><b>From: Pedaler (ROYBREWER)</b> [<a href="lmessages.php?webtag=EE&msg=4712.6">#6</a>]<br /> 29 Aug 2006<br /><b>To: Melissa (OAKBROOK)</b> [<a href="lmessages.php?webtag=EE&msg=4712.1">#1</a>] 29 Aug 2006</p> Melissa,<br /> <br /> The skinny answer is save as a TAB delimited file and open that file in Corel's Print Merge Utility.<br /> <br /> Our only concern is your <br /> <div class="quotetext" id="quote"><b>quote: </b></div><div class="quote">Job can't be split into all three-liners/all one-liners </div><br /> <br /> Depending on what you mean by that, often putting your variable into Paragraph text instead of Artistic text, will be an extremely simple solution. <hr /><p align="center">Show messages: <a href="lmessages.php?webtag=EE&msg=4712.1">All</a>  <a href="lmessages.php?webtag=EE&msg=4712.1">1-2</a>  3-6</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>