Search:

Type: Posts; User: thejas

Page 1 of 2 1 2

Search: Search took 0.12 seconds.

  1. Replies
    1
    Views
    782

    MsOf13 VBA Support on Outlook

    Hi Everyone,
    I'm trying to modify the VBA that i found in InterNET, I need to save the attachments to specific folder by Automatically.
    But This Script will check only the Inbox, I need to check...
  2. MsOf13 Re: Copy the Data one by one till the cell is empty

    Okay.. Thank you so much westconn..
    I'll try with your code.


    Thank you so much for your code.
  3. MsOf13 Re: Copy the Data one by one till the cell is empty

    Thank you so much Westconn.

    Its working, but i got an issue,

    I run the code using F8 key (Step by Step), and found at first time it's not copy the data to the target, it just skip the below...
  4. MsOf13 Re: Copy the Data one by one till the cell is empty

    Thank you so much Westconn.

    Its working, but i got an issue,

    I run the code using F8 key (Step by Step), and found at first time it's not copy the data to the target, it just skip the below...
  5. MsOf13 Re: Copy the Data one by one till the cell is empty

    Hi Westconn,
    I did changes on code, now its working for schenario 2.
    but this always copy and paste the last row data only, i want to paste each row ony by one.

    copy and paste the fist row, then...
  6. MsOf13 Re: Copy the Data one by one till the cell is empty

    Hi Westconn,

    Thanks for your code. Its working but it's adding the data (Row) in same sheet (Sheet2) instead of transfer the data into sheet 1.
    I have change the sheet no in code as below

    ...
  7. MsOf13 Re: Copy the Data one by one till the cell is empty

    Hi westconn,

    Thanks for your reply,
    The code that i attached is maybe wrong... because i tried for various scenarios... please never mind that code.

    I have find the code on below link.
    ...
  8. MsOf13 Re: Copy the Data one by one till the cell is empty

    Hi Everyone.

    Can any one Help me on this :confused::wave:
  9. MsOf13 [RESOLVED] Copy the Data one by one till the cell is empty

    Hello Everyone,

    I have an Workbook with some data. in that i need to copy some data by manually to another sheet to run another VBA. now i'm looking for if i get the data from sheet 2 by...
  10. Replies
    13
    Views
    2,139

    Re: Formula for Vlookup to get two same value

    Thank you so much westconn..
    It's working fine now...
    :)
  11. Replies
    13
    Views
    2,139

    Re: Formula for Vlookup to get two same value

    Yes... I've tried the same thing already...but i got an error like..." Method Open' of object'_Recordset' failed.
    On this line


    rs.Open Sql, cn ', adOpenStatic, adLockReadOnly
  12. Replies
    13
    Views
    2,139

    Re: Formula for Vlookup to get two same value

    Thank you so much Westconn...
    It's working perfectly...
    One more thing...if i want to update end date column from dashboard sheet along with name and task...for that where/how i need to change in...
  13. Replies
    13
    Views
    2,139

    Re: Formula for Vlookup to get two same value

    I got an Error on below mentioned line..Do i need to Check anything in Tools-->References option?


    170365170367

    Thanks
  14. Replies
    13
    Views
    2,139

    Re: Formula for Vlookup to get two same value

    Hi Westconn,
    Thanks for your code.. it's working fine for first name (first cell)...but i want to get all the names and task for the specific Project...is it possible.?

    170333
    Thanks
  15. Replies
    13
    Views
    2,139

    Re: Formula for Vlookup to get two same value

    Hi Westconn,
    Thanks for your code.. it's working fine for first name (first cell)...but i want to get all the names and task for the specific Project...is it possible.?


    170331

    Thanks
  16. Replies
    13
    Views
    2,139

    Re: Formula for Vlookup to get two same value

    Hi Westconn
    Actually In my Dasboard, some project has done by the Same person but different Task (Task is not in Default Letters). I want to fetch the list of person who all are working in the...
  17. Replies
    13
    Views
    2,139

    Formula for Vlookup to get two same value

    Hello Everyone,
    I've a dashboard...in that first column has projects and second column has name of the employee. Some of the projects has done by same employee by various date.
    For ex. In sheet2
    ...
  18. MsOf13 Re: VBA to Cut and Paste entire Row to New sheet based on Cell Value

    Hi Westconn,
    Exactly, your code working awesome.
    Thank you so much.
    Hello Ecniv,
    I have tried your code, but it's not remove the entire row, again it just copy the data from that row to next...
  19. MsOf13 Re: VBA to Cut and Paste entire Row to New sheet based on Cell Value

    Hi Westconn,
    Exactly, your code working awesome.
    Thank you so much.
    Hello Ecniv,
    I have tried your code, but it's not remove the entire row, again it just copy the data from that row to next...
  20. MsOf13 Re: VBA to Cut and Paste entire Row to New sheet based on Cell Value

    Hi Westconn,
    Thanks for your Reply,
    I have a below code now but there is some error.

    Sub Test()
    Dim sht1 As Worksheet, sht2 As Worksheet
    Dim i As Long
    Dim Msg As String, Ans As Variant

    Msg...
  21. MsOf13 Re: VBA to Cut and Paste entire Row to New sheet based on Cell Value

    Hello Ecniv,

    Actually I don't Any code for this.
  22. MsOf13 Re: VBA to Cut and Paste entire Row to New sheet based on Cell Value

    Hello Ecniv,

    Actually I don't Any code for this.
  23. MsOf13 VBA to Cut and Paste entire Row to New sheet based on Cell Value

    Hello Everyone,
    I have a dashboard with lots of details, in that i have to cut and paste the completed row's to new sheet.(Manually)
    Could you please anyone help me out to complete the below steps...
  24. Replies
    8
    Views
    2,405

    Re: Lock Cell range based on Cell value

    Hello Westconn,
    Thank you so much.
    It's working as what I want.

    Once again, Thank you:)
  25. Replies
    8
    Views
    2,405

    Re: Lock Cell range based on Cell value

    Hello Westconn,
    Thank you so much.
    It's working as what I want.

    Once again, Thank you:)
  26. Replies
    8
    Views
    2,405

    Re: Lock Cell range based on Cell value

    Hello Westconn,
    The code for #2 is working well.
    and when i try for #1, i got a Compile Error.
    160485
    and Please tell me , how to run both Worksheet Change code in Same Sheet?
    I have combined...
  27. Replies
    8
    Views
    2,405

    Re: Lock Cell range based on Cell value

    Hello Westconn,
    Thank you for your code, and it was worked well.
    Could you please do some modifications for below steps?
    1. Actually, if column 1 has other than Sales, then it is Locked the Entire...
  28. Replies
    8
    Views
    2,405

    Re: Lock Cell range based on Cell value

    Hello Westconn,
    Thank you for your code, and it was worked well.
    Could you please do some modifications for below steps?
    1. Actually, if column 1 has other than Sales, then it is Locked the Entire...
  29. Replies
    8
    Views
    2,405

    Lock Cell range based on Cell value

    Hello Experts,
    I have a Trouble with Lock the Cells Based on the Cell Value.
    If column A has Value as "Sales" then cells on Column B and C (on same row of the Column A Cell) should Unlock with...
  30. MsOf13 Re: Remove first character from folder and file names

    Hi Westconn
    Thank you so much.
    You are the genius.I have tested this code... working perfectly...

    Thanks a lot again:)
  31. MsOf13 Re: Remove first character from folder and file names

    Hey Westconn
    This is the code i have found from and tested
    In this i want to do some changes..i have a lot of file path on A:A column but this code is working with only one path...
    And also i...
  32. MsOf13 Re: Remove first character from folder and file names

    I don't have code Westconn...
  33. MsOf13 Re: Remove first character from folder and file names

    Hi Westconn
    I'm not a Expert on VBA Scripts, Could you please tell me how to modify the Code?

    Thanks you so much.
  34. MsOf13 Re: Remove first character from folder and file names

    Hey Westconn
    I tried that code..but that's replace all the special character from file path..but i need remove the special character if it is first letter on folder name.
    Even the folder name has...
  35. MsOf13 Re: Remove first character from folder and file names

    Hi Zvoni
    Please find the sample file.
    158939
  36. MsOf13 Re: Remove first character from folder and file names

    Thanks for your reply Zvoni,

    Actually i have a lot of file path in sheet1 A:A column on my workbook.
    Few files and folders contains a special character as first letter.
    I want to remove these...
  37. MsOf13 Remove first character from folder and file names

    Hi Everyone,

    I want to remove the first letter if it is a Special character from folder and file name.
    For Ex. File path like "@documents/#_file.pdf"
    Then it should be like "documents/file.pdf"....
  38. MsOf13 Re: Automatically open the userform when the cell value meet 7 digits

    Thank you so much Elroy.
    Perfect it was worked what i want.:)
  39. MsOf13 Automatically open the userform when the cell value meet 7 digits

    Hello Everyone,

    Anyone Help me, i want open the userform automatically when the cell A2 having 7 digits number or else the the message
    should display like "Please enter 7 Digit".

    Thanks in...
  40. MsOf13 Re: Check the Cells Blank or Not when saving file

    Yes..i made wrong.
    Actually i have placed the code on module instead of this workbook..

    Now its working good.
    Thank you so much Westconn for your help.
Results 1 to 40 of 54
Page 1 of 2 1 2



Click Here to Expand Forum to Full Width