Search:

Type: Posts; User: gmmdinesh

Page 1 of 3 1 2 3

Search: Search took 0.02 seconds.

  1. Replies
    7
    Views
    2,713

    MsOf13 Re: Problem with loop the VBA

    Hi GBeats and Westconn,
    I have resolved the above issue myself.
    Thank you so much for your Code and help.
    :)
  2. Replies
    7
    Views
    2,713

    MsOf13 Re: Problem with loop the VBA

    Hi GBeats,
    Thanks for your reply, It works fine.
    But it move all the (Read and Unread) to Deleted Items, I want to move only Unread Items.

    Thanks again
  3. Replies
    7
    Views
    2,713

    MsOf13 Re: Problem with loop the VBA

    Hi Westconn,
    Thanks for your code, when i try to your code i'm getting Type mismatch error with i on below line,


    Thanks
  4. Replies
    7
    Views
    2,713

    MsOf13 [RESOLVED] Problem with loop the VBA

    Hi Everyone,
    I have a VBA to save the attachment from unread emails one by one on shared mailbox. but this VBA looping only 2 times. (It will check and save the attachments with 2 mails only). I...
  5. Replies
    1
    Views
    1,041

    MsOf13 VBA for find Empty Text box in Web Page

    Hello Everyone,
    I have to fill some data from Work book to Web page on daily basis. web page looks like workbook, they have sequence order (Element id like...
  6. Replies
    6
    Views
    2,567

    MsOf13 Re: Delete entire row based on Cell value

    Hello Westconn and Zvoni
    Thanks for your code.
    It's working as i want. and Zvoni i have tested your code but i got Error on this line.

    If MyWorksheet.Cells(CurRow, 5)="E" Then
  7. Replies
    6
    Views
    2,567

    MsOf13 Re: Delete entire row based on Cell value

    Hi Zvoni,
    Thanks for your reply.
    Actually I have some data on cells left of column E.. I don't need that...I just want to delete entire row if right of column E is blank.
  8. Replies
    6
    Views
    2,567

    MsOf13 Delete entire row based on Cell value

    Hello everyone,
    I have lot of data in my work book. In that i need to delete the row which contains Letter "E" in column E and the other cells are blank.

    So if the rows having letter "E" on...
  9. MsOf13 Re: Change cell value depends on another cell value.

    Hello vbfbryce,
    It was worked Perfectly .
    Thank you so much.:)
  10. MsOf13 Re: Change cell value depends on another cell value.

    :confused:
  11. MsOf13 Re: Change cell value depends on another cell value.

    Hello vbfbryce,
    Your code is working well...
    It's working only for A1 cell..i want to do the changes on entire cells on Column A...
    Please tell me what changes makes this vba to changes cells on B...
  12. MsOf13 Re: Change cell value depends on another cell value.

    Hi JDC,
    Thanks for your Reply.
    Please see the attached sample file.
    160387
  13. MsOf13 Change cell value depends on another cell value.

    Hi Everyone,
    I have a problem on my dashboard. I want to do the following in my dashboard.
    If A1 cell contains Yes, the a list of drop down should available on Cell B1, If Cell A1 contains No or...
  14. Replies
    10
    Views
    2,682

    MsOf13 Re: VBA not working With Network Drive Path

    Hey Westconn
    I have changed that line as you mentioned on post#9
    But i got the same error..
  15. Replies
    10
    Views
    2,682

    MsOf13 Re: VBA not working With Network Drive Path

    Actually I don't want to run with local drive..If it is working with only for Network drive that's enough.


    Anyone help me please,:confused:
  16. Replies
    10
    Views
    2,682

    MsOf13 Re: VBA not working With Network Drive Path

    Oldpath is \\lte.cell\UMTS\Strat\RTD\Folder\Trans\Misc Folder\@#sam#_

    Ans I'm not aware of vbdirectory
  17. Replies
    10
    Views
    2,682

    MsOf13 Re: VBA not working With Network Drive Path

    Hey Zvoni
    Actually I'm not Expert on VBA..
    My problem is the vba shows error while trying to replace special character.

    Can you please give me the suggestion.
  18. Replies
    10
    Views
    2,682

    MsOf13 VBA not working With Network Drive Path

    Hello Everyone,
    I have a VBA code to replace the Special Characters from folder path.. and this VBA i got from this forum.
    This VBA worked well with Local Drive Path but when i try to run vba with...
  19. MsOf13 Re: Remove special characters from folder file path by VBA

    Hi Westconn
    Thank you so much for your help.
    Now it's working perfectly.
    I have placed two different path in A1 and A2 cell, code was replaced special character in both the path.

    Thank you so...
  20. MsOf13 Re: Remove special characters from folder file path by VBA

    Hello Westconn
    I have tested again the code you posted on post #22. now it's working perfectly.
    I have placed full path in A1 and A2 cell, (A1 Cell Path: E:\temp\123456\a@ujhguy\a@v%bv\@#%
    A2...
  21. MsOf13 Re: Remove special characters from folder file path by VBA

    Hey Westconn
    Can you please tell me,Which 2 variables i have to check.
  22. MsOf13 Re: Remove special characters from folder file path by VBA

    I got the File/Path Access Error on this code.
  23. MsOf13 Re: Remove special characters from folder file path by VBA

    Yes, You are correct westconn, we can rename only one folder at a time.
    This was worked when i placed the path upto one folder,

    Thank you so much.
  24. MsOf13 Re: Remove special characters from folder file path by VBA

    Hey I got same error again..I don't know why the error is coming.
    I did call DIR it shows path exist, but VBA not changed the path.
    Anyway Thanks for your effort, Much Appreciated.

    Thanks again.
  25. MsOf13 Re: Remove special characters from folder file path by VBA

    Hi Westconn
    I got a "File not found Error" on this line , even i have a correct folder names and path as mentioned in A column.
  26. MsOf13 Re: Remove special characters from folder file path by VBA

    Hi Westconn
    Sorry for the misunderstanding, I have tested both the codes as you posted, but i got error on it.
    Please look the attached file.

    157159
  27. MsOf13 Re: Remove special characters from folder file path by VBA

    This is the code i have used,

    Sub Test()
    Dim afind, areplace
    afind = Array("@", "#", "%", "_")
    areplace = Array("AT", "NUMBER", "PERCENT", "UNDERSCORE")
    mypath = "c:\temp\" 'change to suit...
  28. MsOf13 Re: Remove special characters from folder file path by VBA

    Hi Westconn
    I got a "Type Mismatch" Error on this Line
  29. MsOf13 Re: Remove special characters from folder file path by VBA

    Yes these listed folders are placed on E:\Temp\ Path, but i don't know, where i have to put the path in VBA,

    Where i have to paste this code.?
    Please help me ..
  30. MsOf13 Re: Remove special characters from folder file path by VBA

    Hello Leith Ross
    Sorry for the delay and Thanks for your Code,
    I have checked your code and I got a Debug Error as below.
    156717

    I have a work book with folder names on A Column and attached...
  31. MsOf13 Re: Remove special characters from folder file path by VBA

    Thank you so much for provide the Links,
    @ westconn, Leith ross, your code is working perfectly, Thank you so much for your Time.
    I have a Workbook with list of parent folder name with A column, I...
  32. MsOf13 Remove special characters from folder file path by VBA

    Hi Everyone,

    I have a large amount of folder with sub folders, the folder name contains some special characters (@,#,%,_,-) Like that.
    I have to find the folder by Main folder name,then replace...
  33. MsOf13 Re: vba to highlight if column is empty by header

    Exactly..this is working perfectly.
    Thank you so much for your work.
  34. MsOf13 Re: vba to highlight if column is empty by header

    Exactly..this is working perfectly.
    Thank you so much for your work.
  35. MsOf13 Re: vba to highlight if column is empty by header

    It's working perfectly as you told..but it was highlighted the cell which contained "South" but i want to highlight other cells (except the South).
    In actual workbook comes with different values...
  36. MsOf13 Re: vba to highlight if column is empty by header

    Exactly this is what i want...working perfectly.
    One more thing i want to do..could you please tell me how to highlight specific cell by value by header name
    for ex. first we need to find the...
  37. MsOf13 Re: vba to highlight if column is empty by header

    I have tested in same workbook but it doesn't highlight anything.same time I'm not getting any error.
  38. MsOf13 Re: vba to highlight if column is empty by header

    Hi Westconn
    I have checked your code, but it's not working.
  39. MsOf13 Re: vba to highlight if column is empty by header

    Thanks westconn
    It's working. but it was highlight when the whole column is blank, also i want to highlight if any one cell is blank then that whole column should be highlighted.
    In each workbook...
  40. MsOf13 [RESOLVED] vba to highlight if column is empty by header

    Hi Everyone,
    Need help again,. I have a excel worksheet that have so many headers. I want to highlight if any cells are blank on specific column, that whole column should be highlighted.
    This...
Results 1 to 40 of 110
Page 1 of 3 1 2 3



Click Here to Expand Forum to Full Width