Macro for CorelDraw Visual Basic
It is necessary to write a macro in the Visual Basic programming language to be used in the graphic program CorelDraw.
Brief description:
There is a catalog template with products in CorelDraw format
There is an Excel file with product data
There are images in 3 different folders
It is required to import data from the Excel file into the CorelDraw catalog template and place the corresponding images from the folders.
Detailed description of the catalog in CorelDraw:
Total number - 8 pages (sometimes there are 16 pages). Products are arranged in a grid with a height of 4 rows and a width of 3 or 4 rows. Products are divided into categories (frozen foods, culinary, grocery, chemicals, canned goods, etc.). The number of products is always different in different categories and in the catalog itself. On the front cover, there are always 6 products in a 3x3 grid. Product images are inserted using PowerClip. The names and prices of the products are on the right.
Detailed description of the Excel file:
There are fields: Product barcode, name, description, weight, price without discount, price with discount, discount percentage. Products are divided into categories according to the catalog in Corel Draw.
Detailed description of the images:
Images are named according to the barcode in the Excel file. Additionally, there is the name of the product. Images are located in 3 different folders.
Detailed description of the task: It is necessary to write a script or macro that will automate the layout work of the catalog. It should read fields from the Excel file and insert the name, description, weight, price without discount, price with discount, and discount percentage of the product into the Corel Draw catalog template. It should also separate products into their categories according to the Excel file when importing into the CorelDraw catalog. The macro should parse the 3 folders with images by the barcode from the Excel file and insert them into the CorelDraw template in a specific square using the PowerClip function. So that the names and images of the products correspond to each other.
Project nuances: Images in the 3 folders may be duplicated, so the script should take only one image, preferably in png if available, or of a larger size. Images are in different formats - jpg, png, tif, psd, jpeg, bmp. When importing into Corel Draw, the image must be inserted inside the square - the program has a function to insert into the Power Clip container. And adjust this image proportionally to the container. If the price is equal to or less than 20%, only the price with a discount is written; in other cases, when the discount is above 20%, all prices are written on the price tag. There are also products that need to be highlighted in yellow; these products are marked in the Excel file.
Applications 2
-
1 day45 USD
1831 46 3 1 day45 USDGood day!
I am interested in your project! I have experience in creating macros in VBA for automating work in CorelDraw, as well as in processing Excel files and images.
I can write a macro that:
- Imports data from Excel (barcode, name, description, prices, discounts);
- Automatically places products in the CorelDraw catalog template according to categories and the specified grid;
- Adds images from the corresponding folders to PowerClip;
… - Designs a cover with 6 products in a 3x3 format;
- Inserts all the necessary text information into the layout.
I am ready to discuss the details and help with the implementation!
-
2 days50 USD
203 2 days50 USDGood time of day. I have extensive experience in writing macros for Corel. From furniture facades to price tags. Can I get a detailed specification?
Current freelance projects in the category Data Parsing
Parsing products, preparation for import to WPScrape the full catalog of these websites: https://svit-mebliv.ua/ https://kompanit.com.ua/ru https://amia.com.ua/ https://mebliromax.com.ua/ https://pehotin.com.ua/catalog/ https://www.sokme.ua/ru/ All products need to be combined into one general table for import into WP.… Web Programming, Data Parsing ∙ 51 minutes back ∙ 21 proposals |
I am looking for a programmer for OpenCart.Good day 1) It is necessary to implement on the website dneprkomfort.dp.ua A module for Ukrainian banks has been purchased, and we have already integrated Mono Bank Here is an example from our competitor It is necessary to implement installment payments, purchase in parts… Web Programming, Data Parsing ∙ 22 hours 11 minutes back ∙ 46 proposals |
A specialist in Telegram promotion is required.
28 USD
Tasks: invite real users from the username database to new chats and send messages to the target database. Only quality traffic and work with a live audience are of interest — performers using bots, fake engagement, or low-quality methods are requested NOT TO DISTURB. Work… Data Parsing, Social Media Marketing (SMM) ∙ 5 days back ∙ 9 proposals |
Consultation on parsing Instagram account subscribersHello. It is necessary to conduct a preliminary assessment of the feasibility of the following task. I have a list of Instagram accounts. The goal is to obtain contact information (primarily email addresses) of users who follow these accounts. Previously, I encountered companies… Data Parsing ∙ 8 days 19 hours back ∙ 13 proposals |
A specialist is needed to find contacts of decision-makers in Ukraine.It is necessary to gather a database (or ready database) of contacts of decision-makers (DMs) in companies in Ukraine. Information Gathering, Data Parsing ∙ 9 days back ∙ 21 proposals |