Hi friends
i want to know what is macro and how to use it.
Macro is programming code. It powerfull for repeat task and action.
For example, in making ID Card. After design is fix, we must entry data in ID Card. Data can be text, photo, barcode, etc. We entry data one by one.
But, i make some macro (VBA) code to do that automatically.
First. i prepare data needed in table (excel, word, etc.), also prepare photo in specified folder.
When i enter number 1, and i run my code, data in first row of table entered to CorelDRAW. It like mail merge.
Photo automatically import to CorelDRAW, resize and powerclip to frame photo.
Barcode automatically creted and powerclip (or alignmet) to frame barcode.
For doing that task and action: Insert Text, Insert Photo and Insert Barcode, i just need less then 1 second.
It can do simultaneous, for entry data 1 to 100 (or 1000) . It just finish it self.
Interested?
Hello,
I used google and I found your message in this forum.
I am very interested by your macro because it's exactly what I want to do with Corel (just with text file first or data in an excel table).
I'm know Visual Basic because I use it with Excel, but I' m a very new customer of Corel.
So if you can send me your code it would be great.
Thanks a lot
Jeje13
jeje13 said:I am very interested by your macro because it's exactly what I want to do with Corel (just with text file first or data in an excel table).
Here is free training for text only
Did you know, this feature was added in CorelDRAW 2? about 18 years ago... ;-)
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 said: 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 &..................