What is macro in coreldraw?

I have 2 vba for merging text from Excel. 1. Merge directly from excel 2. Using Word mail merge Word, then "auto copy and paste to" Corel. all of it, available in interactive mode and hidden mode Merge from Excel directly: - When entry record number (e.g. 12) , the text at row 13 of Excel table (usually row 1 is header), will duplicate to Corel (in Artictic/paragrap text) - It can select which coloum will be duplicated ( 1 or more), it's very simple just fill coloum number at dialog box - It can be simaultaneous : - Record from 1 to 100, or rec. from 21 to 30, - For specific paragaraph/artistic text in 1 page or for all pages Example: There is 10 identitcal paragraph text at page 1, if macro run for page 1 and record counter set for 1 to 10, then text from row 2 to 11 of Excel table will be transfered to each paragrap text Merge using Word merge: - Create Word merge file - Record number at dialog box of Corel VBA, will "be" as record number of word merge, - Then data from word copy - And paste to Corel to be continued....... Happy New Year

I 'll send you sample code for "Auto Duplicate" text from Excel to Paragraph Text in CorelDraw. Named Task.gms

Copy the gms file to your gms folder at CorelDraw folder. After startp up Corel, make customization, at Command Bar to show icon of Task.gms.

Click the icon, the CorelDraw Automation Dialog Box will be displayed, select sub menu Labelling.

Open VBA editor, activate Reference for Microsoft Excel Object Library

First, you must create a Excel File, named Data1.xls stored in folder E: (E:\Data1.xls), with minimum 3 coloum. Data filled in row is up to you. 

Click auto record, for read or fill record you want. 

Create paragraph text, select paragraph text the click Apply. Preview of text stored data in excel will be displayed, and duplicate to paragraph text (text in paragrap text will be replaced with preview data). If you set record number to 8, then data at row 9 (from specific coloum/coloums) will replace text of paragraph text. 

All of above for sample, for understanding VBA programming. 

Excel filename, simultaneous running, number of coloum, and etc are available.

I like to send the code, but how to attach my  Task.gms file?. The file have dialog box, so it must send as gms file.  

Thanks

aicaxz

Anjazmoro:

I like to send the code, but how to attach my  Task.gms file?. The file have dialog box, so it must send as gms file.  

Thanks

aicaxz

Right click on gsm file and choose add to gsm.rar (I presume that you have installed winrar).  Upload it to filefactory.com ( or similar file hosting sites) and post the link on this forum.

ayush

For previewing Text at coloum1

Label.DataColoum1.Text = xlSheet.Cells(ManualNo1.Text + 1, Label.Coloum1)

For replacing text in paragraph text

s1.Text.Story = Label.DataColoum1.Text & vbCr &..................

plz send me the macro my id is ahsan_khd@yahoo.com

Here is : http://www.filefactory.com/file/b18b3b8/n/Task1.rar

Password for running macro : arema indonesia

Movie for Auto Text (2 paragraph text) simultaneous.

http://www.filefactory.com/file/b16h462/n/Movie.rar

 

Demo Movie for making card. Auto insert text, photo and barcode.

http://www.filefactory.com/file/b19386a/n/Movie_0001_wmv

Demo movie for simultaneous Auto insert text, photo and barcode.

Running on CorelDraw 12, captured using Corel Capture X4

http://www.filefactory.com/file/b194h7g/n/Movie_0002.rar

Than Ariel for the link,

Dear Friend..

I have read your post in the same website and inspired a lot with your explanation.

This is what i want exactly..

as I am new to corel draw and i want to create id cards for our employees..

with text and photos also, but barcodes are not required..

will you please send me a macro for creating id cards...

my mail id is ramesh.edp@gmail.com

 

With Warm Regards

Ramesh Kumar

This thread is quite old... I can think some easier solutions to do what you want now.

both are commercial macros:

monstermerge

variablestool

ramesh.edp:

as I am new to corel draw and i want to create id cards for our employees.. with text and photos also, but barcodes are not required..

 

Btw, Did you already understand how to run macros in Corel Draw? We are sorry if we were not able to share the macros for free.

Because the macros are very complex and quite time-consuming coding. Some sub- macros I made one into a single dialog box, where the later we choose to live where the macros that will be used. There are sub-Auto Exporting, resizing / resampling, Pasteclip (Copy bitmap from other source and paste it into Corel, including resizing and powerclips.), Croping and Multiple Cropping, Auto numerator, Edit PowerClip (without directly enter edit mode), Auto Insert Text Photo barcodes, etc.. Some printing companies from home and abroad have bought the macros. How about you??

Wacth theese :

http://www.youtube.com/watch?v=xCgaySxay7c

http://www.youtube.com/watch?v=n1YbKfWyS1U

http://www.youtube.com/watch?v=gRI-ef-xHlU

http://www.youtube.com/watch?v=IlMJJazRwBI

Here is a very interesting article on macro how to create cutting or crop using a macro ... you would love this.....

 

How to create Printing/Cutting/Crop Marks in Coreldraw using Macro

Rakeshb:

Here is a very interesting article on macro how to create cutting or crop using a macro ... you would love this..

Rarely needed. You can place them on the page in the imposition layout tool in the print dialog. That's what we do at my shop.