if you could make the photo name as register number or a unique number, it will easier to use. In the photo column, type the path of the photo, Name and image type. Now go to excel barcode column and enter =code128(column name). just import the VB extension we downloaded and close Visual Basic window If you do not see the Developer tab on your excel, go to File> Option and activate the Developer tab.įrom Visual Basic window, go to File > Import. first click on the Developer tab from the menu. Compile VB Extension to Microsoft Excel sheet. it is included zip folder which we downloaded just now.Īgain go to excel sheet for creating data merge indesign. Extract the downloaded zip folder and Install idAutomation font. Now lets set barcode for create data merge adobe indesign with help of excel spread sheet, download VB Marco extension from idautomation website and download the barcode VB extension. Excel will show error if given only Put an apostrophe to avoid it.) (When entering the path of a photo or image, must give began the title symbol. Kindly check Sample sheet titled as titles Give as Serial number, Name of the students, Register Number, Class of Study, Barcode, photo. Check the screen-short that I made a demo of excel data sheet. Open Microsoft Excel Sheet that contain the information of all students and their Name, Registration number Division etc. Let’s see how to easily make visiting card with different variant names, registration number, photo and barcode etc.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |