Đã hoàn thành

Add new features to existing Excel VBA Macro

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.

Removed requirement for #5, it is not in the scope of this current bid.

Kĩ năng: Excel, Visual Basic

Xem nhiều hơn: small script vba macro excel, vba macro excel, need someone write vba macro excel, convert vba macro excel menu item, vba macro excel update inventory pricing, vba macro excel text file, vba macro excel googlefinance, vba macro excel freelancer, record list vba macro excel, free vba macro excel stocks, pre written vba macro excel, vba macro excel enable paste protected sheet, vba macro excel display contents, excel 2003 paste clipboard vba macro excel, vba macro excel unicode

Về Bên Thuê:
( 22 nhận xét ) Mebane, United States

ID dự án: #12949728

Được trao cho:

mobiletech1604

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 Thêm

$75 USD trong 1 ngày
(22 Đánh Giá)
5.0

6 freelancer đang chào giá trung bình $109 cho công việc này

P0L

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 trong 3 ngày
(268 Nhận xét)
7.1
dpune

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. Plea Thêm

$100 USD trong 5 ngày
(120 Nhận xét)
6.3
$155 USD trong 3 ngày
(5 Nhận xét)
5.8
GeniuSBraiN

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, Thêm

$60 USD trong 2 ngày
(8 Nhận xét)
4.2
manishadk

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 trong 7 ngày
(17 Nhận xét)
4.1