PDA

View Full Version : VBA many functions



dawidb82
12-16-2015, 03:13 PM
Hi, please check my code and fix please. 14995

VBA must work like below.

1. button XML = download XML to sheet "temp"
2. button Update Price = download and unzip specific file ( this is not case for now )
3. sheet "Podsumowanie" column G - must replace in first step "," to "" and second step "." to ","
4. sheet "Podsumowanie" column H - multiply G * E
5. sheet "Podsumowanie" column I - vertical search column C in sheet "CennikPLN" column A and show column L
6. sheet "Podsumowanie" column J - multiply I * E

Kevin#
12-30-2015, 10:25 AM
Hi Dawid
I have looked at your workbook.

(In Excel 2010 you can format numbers in the way you want for columnG as follows
Options->Advanced, in the first group "Editing options"
- Uncheck Use system separators.
- In the Decimal separator box enter a comma
- In the Thousands separator box enter a dot
- Press OK
- This will affect all future spreadsheets)
Question1 Is your Excel already set up with these defaults?

BUT the values in columnG are NOT numbers, they are text - I think this is the problem

Question2 Are you able to bring the values in columnG into the worksheet as numbers?
(if not possible, then we will need to convert the text to numbers BEFORE multiplying columns G * E - this can be done using the VAL function, numbers will then take your default formatting)

Question3 This does not make any sense. Can you please explain

5. sheet "Podsumowanie" column I - vertical search column C in sheet "CennikPLN" column A and show column L


kevin