Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.00 seconds.

  1. Thread: excel macro

    by writetoevv
    Replies
    4
    Views
    106

    Re: excel macro

    Thank you, Rick..Let me check..

    Edit: Worked like a charm..
  2. Thread: excel macro

    by writetoevv
    Replies
    4
    Views
    106

    Re: excel macro

    Hi mumps,

    csv doesnot support telugu language..so we cannot do anything with CSV..
    however, we are good with excel..that is fine..

    Now, i have been working on multiple scenarios of data...
  3. Thread: excel macro

    by writetoevv
    Replies
    4
    Views
    106

    excel macro

    excel problem definition has been described briefly in the below snapshot.

    https://www.dropbox.com/s/0v7duejb726laws/dear%20mumps.jpg?dl=0

    Thanks & regards.
  4. Re: VBA script for conditional copy, format & paste from workbook1 to workbook2

    hi mumps

    yes, workbook which contain our macro is always saved as macro-enabled file.
    here, our macro processing specified data of macro-enabled file & creates a new file which has been saved...
  5. Re: VBA script for conditional copy, format & paste from workbook1 to workbook2

    Hi mumps,

    due to certain requirement of further process, i have been converted newly created workbook as excel csv format(Microsoft Office Excel Comma Separated Values File (.csv)). csv file has...
  6. Re: VBA script for conditional copy, format & paste from workbook1 to workbook2

    hi mumps,

    here is the link to sample excel doc with content

    https://www.dropbox.com/s/2719tagw3w5bcfa/Excel%20Content%20in%20Telugu%20Language.xlsx?dl=0
  7. Re: VBA script for conditional copy, format & paste from workbook1 to workbook2

    Dear mumps,

    my excel file may contain either english or Telugu language.
    in MS excel workbooks/sheets, 0809 means English (U.K.), 0409 means English (U.S.), 044A to Telugu language.
    using our...
  8. Re: VBA script for conditional copy, format & paste from workbook1 to workbook2

    Hi Mumps,

    You made my day..Thank you very much..

    Thanks & Regards
    Vishy
  9. Re: VBA script for conditional copy, format & paste from workbook1 to workbook2

    though i updated srcWS, srcWS still showing above error..i think i need to flush cache of excel..
    all other variable default values are good , except our friend srcWS..:biggrin:
    let me restart my...
  10. Re: VBA script for conditional copy, format & paste from workbook1 to workbook2

    thanks..it is working perfectly..Thanks you!!

    but when i manually copy & paste #16 vba code in to a macro, while running macro, my excel has been reporting below issue on that particular line....
  11. Re: VBA script for conditional copy, format & paste from workbook1 to workbook2

    yes, that is correct format..appreciates..

    donot know why im getting w/o values..i used ur vba script as it is except commenting following line..' LastRow = srcws.Cells.Find("*",...
  12. Re: VBA script for conditional copy, format & paste from workbook1 to workbook2

    https://www.dropbox.com/s/m5yfw9e7g75vh4n/Excel%20Snapshot.jpg?dl=0

    please find attached snapshot.. it did not work for me..

    donot know whether it is an issue with excel version..my excel...
  13. Re: VBA script for conditional copy, format & paste from workbook1 to workbook2

    As you said ,i used test(), got 14 as colorindex & used colorIndex as 14 in the macro you provided.
    However, still the o/p remains same. it seems the value of 'val' is nothing on debug..i think it...
  14. Re: VBA script for conditional copy, format & paste from workbook1 to workbook2

    1 obersationi noticed

    code always going to else part of if ..else, because "val.Interior.ColorIndex returning -4142" & we are checking whether it is equal to 43.
    as it is not matching or...
  15. Re: VBA script for conditional copy, format & paste from workbook1 to workbook2

    with bit of hands on, copying Q11111, Q22222,Q33333,Q4444 in B Coloumn of new workbook has been implemented & done.

    however, ith column of new worksheet issue still exist.
    Output on ith Column...
  16. Re: VBA script for conditional copy, format & paste from workbook1 to workbook2

    also, in new workbook , Q11111, Q22222,Q33333,Q4444 needs to be copied on B Coloumn of respective rows . [Pardon me, though i mentioned it in initial post, i missed this part in dropbox excel file....
  17. Re: VBA script for conditional copy, format & paste from workbook1 to workbook2

    Hi mumps

    i got this output on ith column of new book. it seems it is always going to 'else' part of code & not copying content of cells.
    also, Q11111, Q22222,Q33333,Q4444 needs to be copied on B...
  18. Re: VBA script for conditional copy, format & paste from workbook1 to workbook2

    here is the link

    https://www.dropbox.com/s/fjky1l4xjybet8k/Conditional%20Copy%20Format%20and%20paste.xlsm?dl=0

    simple explanation is also provided.
  19. Re: VBA script for conditional copy, format & paste from workbook1 to workbook2

    i myself fixed runtime error 91 by commenting "LastRow" & took static value of 10 to test the macro.

    macro is working, how ever not matching with expected result.
    macro just pasting ::0;; in C...
  20. Re: VBA script for conditional copy, format & paste from workbook1 to workbook2

    hi

    when i tried, i got "runtime error 91" on this line
    LastRow = srcws.Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row

    object variable or with block variable not...
  21. Re: VBA script for conditional copy, format & paste from workbook1 to workbook2

    appreciates for your quick response. manually select a cell of a record & by using fill color feature.

    Actually, either way by fill color or font color is fine to me.
  22. VBA script for conditional copy, format & paste from workbook1 to workbook2

    <tbody>
    In workBook1, i have five columns (A,B,C,D,E) with data. Here, each row is a separate record & is going have unique data.
    sample data is given below.

    A B C D E...
  23. Re: Grid Construction With numeric values & Dates

    Hi Peter,

    Appreciate for all your effort & Time.

    Thanks & Regards,
    Viswa

    PS: I have a vague thought in my mind to further utilise search results .. I am looking for more clarity on my...
  24. Re: Grid Construction With numeric values & Dates

    Hi Peter,

    I tested using normal find(Ctrl + F), it did not work.
    Btw, Could you provide VBA code for search functionality as it will be easy if grid size is big.
    Also, colorize the resulted...
  25. Re: Grid Construction With numeric values & Dates

    Hi Peter,


    1) Yes, Excel version is 2007 & Now colouring of grid working perfectly.
    2) It is a simple search functionality with Excel functions (without VBA).
    Here, User enter either a...
Results 1 to 25 of 52
Page 1 of 3 1 2 3