I need a couple of simple modifications from my current programs. I would like them done ASAP so ideally within a day, maximum 2 days.
Prepare availability list:
Using the current program “Prepare and email Weekly [login to view URL]”
Currently if a cell = “NA” it locks the cell. I want it to lock the cell if it:
= “NA” or
starts with “20” or
I believe the part of the code that needs changing is this part:
If [login to view URL](i, j - 4).Value = "NA" Then
[login to view URL](i, j + 1).Locked = True
Convert the order to xml:
The program “[login to view URL]” converts my orders to xml but I have modified the spread sheet so the xml code needs to change.
The new code should use cells B2 to B13 in the xml code and the price in column E has been added into the xml code. See “Fragile Delivery Availability List [login to view URL]” for an example of the code which should be generated from “Fragile Delivery Availability List [login to view URL]”
The order now starts on line 20 whereas it used to start on line 14 (I don’t know if this matters).
<OrderNumber> = This is the Account number then the order number in B2. If cell B2 is blank use the same logic as current code.
<DeliveryNet> = Cell F15
<ItemNet> = column E
Added errors to report.
Keep the current errors it reports but also if any of the fields in yellow are blank have a pop up to say the file name and what the issue is. So for example if the account number and the town were blank, a pop up to say:
File Fragile Delivery Availability List [login to view URL] has the following errors:
Account number is blank
Town is blank
With the same “Do you wish to continue box”
Hi . I have read your job description carefully. I have full experience in excel macro and vba. If you give me a chance, I will deliver good result. I hope to discuss more via chatting. Thank you.