Search:

Type: Posts; User: zmagic; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Thread: Maintain Format

    by zmagic
    Replies
    3
    Views
    658

    Maintain Format

    Hi,

    Below codes are successful in creating the summary but the format gets destroyed, Please some one help me to maintain the format.
    Create the Summary(Sheet 2) with same format, Column A as...
  2. Replies
    13
    Views
    1,693

    Hi Maud, Uploaded sample files, hope to have a...

    Hi Maud,

    Uploaded sample files, hope to have a favourable response.
  3. Replies
    13
    Views
    1,693

    Hi Maud, Thanks for reply, Uploaded sample...

    Hi Maud,
    Thanks for reply,

    Uploaded sample files, hope to have a favourable response.,

    Thanks in advance.
  4. Replies
    13
    Views
    1,693

    Thanks Maud for helping, and sorry for delay...

    Thanks Maud for helping, and sorry for delay reply.

    The summary in Col D & E are done at every alternate whether they are of group or not, Please group only similar's summary from column A...
  5. Replies
    13
    Views
    1,693

    Thanks Maud. Many Thanks for supporting....

    Thanks Maud.



    Many Thanks for supporting.
    Thanks
  6. Replies
    13
    Views
    1,693

    Thanks Maud. The values are retrieved in...

    Thanks Maud.

    The values are retrieved in order, but in column C decimal places are added it does not convert it. Please look to my sample.xml file the TotalAmount is 603320 when appended in...
  7. Replies
    13
    Views
    1,693

    Thanks Maudibe for the reply. I have attached...

    Thanks Maudibe for the reply.

    I have attached the sample xml file.

    Thanks in advance.
  8. Replies
    13
    Views
    1,693

    Extracting values from XML file

    Hi,

    I have around 50 to 60 .xml files in folder and need a macro to extract only 3 values from xml tags to spreadsheet.

    1. -<Item IQAIgnoreInd..... RoutNo="000002166" value "000002166" in...
  9. Replies
    21
    Views
    1,724

    Hi Maudibe, I am Thankful for your marvellous...

    Hi Maudibe,

    I am Thankful for your marvellous script, words cannot express that.
    Thanks a lot.

    Incontinuation with above topic I have a new question should i continue it or start a new thread....
  10. Replies
    21
    Views
    1,724

    Hi Maudibe, I have uploaded the sample file,...

    Hi Maudibe,

    I have uploaded the sample file, Please if you have time complete the import file of CSV instead of text file.

    Expecting reply.
    Thanks.
  11. Replies
    21
    Views
    1,724

    Hi Maudibe, Many Thanks for helping, ...

    Hi Maudibe,

    Many Thanks for helping,



    With your support and help, I have changed the mind instead of importing a text file i want to import a CSV with all the database so all data will...
  12. Replies
    21
    Views
    1,724

    Hi Maudibe, Let me put it simply, day one we...

    Hi Maudibe,

    Let me put it simply, day one we have some text data we use your script for create & bifurcate for CSV files, job completed.
    day two we receive new data now we only want to bifurcate...
  13. Replies
    21
    Views
    1,724

    Hi, Thanks Maudibe. I have tested the codes...

    Hi,

    Thanks Maudibe.

    I have tested the codes & i need some changes to it.

    Is this possible to only export selected data which we will import daily to those existing CSV file, adding the new...
  14. Replies
    21
    Views
    1,724

    Hi Maudibe, After the last post there is no...

    Hi Maudibe,

    After the last post there is no response from your side, please reply with udpate i am awaiting.

    Thanking you in adavance
  15. Replies
    21
    Views
    1,724

    Hi, Thanks for the response. You are...

    Hi,
    Thanks for the response.



    You are absolutely correct, I don't now the future, please don't bound to 4 columns tomorrow the columns may increase, so what ever must be appended.
  16. Replies
    21
    Views
    1,724

    Thanks Maudibe for helping, I have created...

    Thanks Maudibe for helping,



    I have created the conversion list in the attached workbook sheet.

    Regarding writing directly to their perspective CVS was not in mind, but if its possible than...
  17. Replies
    21
    Views
    1,724

    Thanks Maudibe, Your codes are faster. I need...

    Thanks Maudibe,

    Your codes are faster. I need a small change in Column B (sheet names) in Column B if 3 then create sheet as 100000003, if its 19 then 700000019 i have a list for all of them. Its...
  18. Replies
    21
    Views
    1,724

    Thanks Zeddy, I neeed your advise/decision....

    Thanks Zeddy,

    I neeed your advise/decision.
    This data which we will append in the sheet will grow to large voulme approx. 2/3 Hundred Thousand Serials will be stored from Column F onwards.
    Is...
  19. Replies
    21
    Views
    1,724

    Import, Append and Split

    Hi,

    To import and append the data in the existing master sheet which have records in them, While importing the data, column E all 24 digits to be imported then the zeros are to be trimmed in this...
  20. Replies
    2
    Views
    18,367

    Hello, RG, Thanks for Help, Solved.

    Hello,

    RG, Thanks for Help, Solved.
  21. Replies
    2
    Views
    18,367

    Run Batch files in Powershell script

    Hello,

    I want to run the batch files from powershell script and i searched the net & according to me this is good: [ & 'C:\somefolder\batchfile.bat' ]
    I have 3 batch which i want to run...
  22. Replies
    1
    Views
    386

    Concate email address

    Hello,

    I have a database of our clients wherein from column C to column F i have email address now i want to concate them with a semicolon [;] and to have them in column G. At times i have email...
  23. Replies
    0
    Views
    727

    FTP Download - Needs Help

    Hello Experts,

    I found this VBA script online and i use to download the files from FTP Server, .img & .xml files from an ftp server. It works fine, successfully.
    However, there are some issues...
  24. Replies
    4
    Views
    1,813

    Thanks Paul, It's amazing,amazing i never thought...

    Thanks Paul, It's amazing,amazing i never thought it.

    Thanks.
  25. Replies
    4
    Views
    1,813

    Hi Paul, Well said Paul, if you extend me...

    Hi Paul,

    Well said Paul, if you extend me help, this is scenario the folder contains multiple files and they are infact the response files to xml files.
    File names:...
Results 1 to 25 of 32
Page 1 of 2 1 2