Find Jobs
Hire Freelancers

Add new features to existing Excel VBA Macro

$30-250 USD

Завершено
Опублікований about 7 years ago

$30-250 USD

Оплачується при отриманні
There is an existing Excel VBA script that we are using to export Shopify CSV files from, based on data we add to the spreadsheet. It already works pretty well but it needs a few updates to address some improvements we need to make to it. #1 update saving of CSV files from ANSI to UTF-8 format [login to view URL] #2 hardcode a subfolder (/CSV) to output CSV files to so it doesn't export to the same folder that the CSV file is located and also modify the NP output to go to (/CSV-NP) folder instead as well so it is easier to keep those separate Maybe this change for those two above folders? It should check to ensure that folder exists before doing this and if it does not, then just save to the same folder as the main CSV. ( If sInc = "" Then sCSVPath = [login to view URL] & "\CSV\" & "XXXXXX-" & Format$(Now, "MMDDYY-hhmmss") & "[login to view URL]" sCSVNoImgPath = [login to view URL] & "\CSV-NP\" & "XXXXXX-NP-" & Format$(Now, "MMDDYY-hhmmss") & "[login to view URL]" Else sCSVPath = [login to view URL] & "\" & Format$(sInc, "000000-") & Format$(Now, "MMDDYY-hhmmss") & "[login to view URL]" sCSVNoImgPath = [login to view URL] & "\" & Format$(sInc, "000000-NP-") & Format$(Now, "MMDDYY-hhmmss") & "[login to view URL]" ) #3 option (checkbox) that when selected (it is unselected by default), doesn't export anything in Column H, "Collection" for certain specific collection upload - maybe place this in cell H1 to keep it out of the way? #4 add 9 columns (CL through DC) to the XLS file for size and other variables to be integrated into HTML before all of the CSV outputs (%a, %b, etc). This script needs to insert those cell values into the code from Column I labeled "Body (HTML)" when it is creating the CSV so those values appear in the CSV output. #5 new columns (DE through DN) for up to 10 photo URLs that are already uploaded to Shopify, new tab (CSV Output CDN) and new CSV output file for listing hosted shopify images, a means to input a CSV to match up the pictures and when the CSV is updated, match up the images and save shopify CDN photo URLs to DE through DN if they exist so making changes is quicker. It should overwrite those DE through DN URLs if a new CSV is uploaded. It might be necessary to better sync up ALT text with image URLs in a different or better way? #6 when the script runs and if it does generate any errors, highlight the background of all of the *specific* cells that caused that error to occur. Also, remove the errors of any cells that no longer produce an error (typically because the correct values have been inserted or corrected). Having it say that there was an error isn't helpful in tracking down what caused that error and reviewing the Error tab helps some but still doesn't easily pinpoint things.
ID проекту: 12949728

Про проект

6 пропозицій(-ї)
Дистанційний проект
Активність 7 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
Доручений:
Аватарка користувача
Dear sir Thank you for posting this project. I'm Hoang and I'm experience and hard-working developer. I have checked your requirements and I believe I could make changes in your current VBA within 2 days. Please send me your current VBA and spreadsheet so I could review in details. Looking forward to hear from you Thanks & B/R
$75 USD за 1 день
5,0 (22 відгуки(-ів))
5,0
5,0
6 фрілансерів(-и) готові виконати цю роботу у середньому за $109 USD
Аватарка користувача
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$150 USD за 3 дні(-в)
4,9 (268 відгуки(-ів))
7,1
7,1
Аватарка користувача
Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Let us discuss more details so that I can estimate cost and time better. I have completed more than 300 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$100 USD за 5 дні(-в)
4,8 (120 відгуки(-ів))
6,3
6,3
Аватарка користувача
Hello, I can do this task in less time, and 100% accurate - I have a long experience with MS-Excel (formulas & VBA macros). Also: - I'm an experienced software developer specialized in desktop applications, tools, and scripts. - I write programs using .NET since 2013, and using classic VB6 since 2007. - Have long experience with web scraping applications, socket communications, FTP connections, mathematics & formulas, applications that manipulate files & folders, and creating mini-tools that automate tasks while working in background. - Very good experience with multi-threaded applications. - Very good Experience with database based applications (MS-Access, SQL Server, and MySQL). - Accuracy and precision is one of my principles, also one of my best advantages. - Commitment to deliver tasks in time. I I'm looking forward to working with you, helping you to solve problems :) Please feel free to contact me to discuss any further details.
$60 USD за 2 дні(-в)
5,0 (8 відгуки(-ів))
4,2
4,2
Аватарка користувача
Hi, I have good experience in excel VBA macro programming. I can work for you on this project. Please provide sample excel file and also provide more information on point# 3 to 6. Thanks, manishadk
$111 USD за 7 дні(-в)
4,8 (17 відгуки(-ів))
4,1
4,1

Про клієнта

Прапор UNITED STATES
Mebane, United States
5,0
22
Спосіб оплати верифіковано
На сайті з лют. 2, 2009

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.