Search:

Type: Posts; User: jamilm

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. thanks. i am not sure how this works but i...

    thanks. i am not sure how this works but i found a suloltion which is this formula =INT((B2-A2)/365.25) & " years " & INT(MOD((B2-A2)/365.25,1)*12) & " months " &...
  2. SnB your code also has problem ...

    SnB

    your code also has problem

    1/31/2014 3/1/2014 between these two dates it shows 1 months and 2 days, while it is just 29 days.
  3. so, buttom line. is there any solution to the...

    so, buttom line. is there any solution to the problem?

    has anyone tested which code is working now the one from Rick or the one from Snb?
  4. i am curious to learn this. would it be possible...

    i am curious to learn this. would it be possible Rick to breakdown this formula. what exactly this multple find and countif did?
  5. Replies
    2
    Views
    5,775

    Hi Admin, this is a very good code. but one...

    Hi Admin,

    this is a very good code. but one issue that it does re calculates and i have to press each time recalculation. is there anyway this could be improved?

    thanks.

    ...
  6. Ok Mr. Administrator. roger that. cheers,

    Ok Mr. Administrator. roger that.

    cheers,
  7. Hi Rick, while i testing this code. i faced...

    Hi Rick,

    while i testing this code. i faced the following problem. once i run the macro it only gets values from sheet2 not all three sheets. i have uploaded the file here...
  8. incredible code. very useful. ...

    incredible code. very useful.

    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.youtube.com/watch?v=zHJPliWS9FQ&lc=Ugz39PGfytiMUCmTPTl4AaABAg.91d_Pbzklsp9zfGbIr8hgW
    ...
  9. very nice. i was looking for this code. ...

    very nice. i was looking for this code. coincidentally, i searched before posting the question in Mrexcel forum and here i got exactly what i needed.

    thank you Rick and Marcelo.
  10. Rick, this is excelllent. i found it very...

    Rick,

    this is excelllent. i found it very useful.

    cheers,
  11. solution worked perfect. Many thanks. payment...

    solution worked perfect. Many thanks. payment sent and confirmed.

    best regards,
  12. Re

    Thank you Lalit.
  13. Replies
    22
    Views
    10,769

    Yes, just to highlight in this forum and express...

    Yes, just to highlight in this forum and express my thanks to Administrator for the extra-ordinary solution. it made my life easy.
  14. sure. i have both files ready with code the excel...

    sure. i have both files ready with code the excel file the word.

    pm me your email and your paypal ID as well. i will send you the files by email.
  15. 10$ for modifying the VBA code to export the excel header and footer to Word Doc

    Gurus,

    i have an excel file that based on the data on excel, it generates a memo, now few modification is required. the Excel file Header and footer is as Picture and a VBA code to be written...
  16. Replies
    22
    Views
    10,769

    Dear Administrator. do not worry about the...

    Dear Administrator.

    do not worry about the task completed date. you can remove that part entirely. all what matters is the received date .

    you shall remove the code intColumnCounter =...
  17. Replies
    22
    Views
    10,769

    Administrator. any luck with my outlook code?

    Administrator.

    any luck with my outlook code?
  18. Replies
    22
    Views
    10,769

    Dear Snb, your code does not do nothing. i...

    Dear Snb,

    your code does not do nothing. i believe that you did not understand what the requirement of my project was. currently the Administrator is working on it. so, please do not bother.
    ...
  19. Replies
    22
    Views
    10,769

    i am sorry to be nagging you on this, but i was...

    i am sorry to be nagging you on this, but i was wondering to know if there is any progress made on my code?

    thanks.
  20. Replies
    22
    Views
    10,769

    hope you can figure out something this weekend...

    hope you can figure out something this weekend for this outlook code which pending for too long ;)
  21. thank you very much. i do not even know your...

    thank you very much. i do not even know your name. but i i guess that our messages have crossed before in mrexcel forums.

    so, please give pm me your paypal ID so that i send you 10 bucks.
    ...
  22. the modified code you provided, worked perfectly....

    the modified code you provided, worked perfectly.

    now only one issue that all the generated workbooks have the default worksheet name as "sheet1" i want the worksheet name to be the same as the...
  23. i use excel 2010

    i use excel 2010
  24. i also checked with other file formats it does...

    i also checked with other file formats it does not work in xlsm as well. it only works in .xls seems like the code only functions in old version of excel only.
  25. i found the problem. it is becuase the source...

    i found the problem. it is becuase the source workbook file format is .xlsb and once i changed it to .xls then it worked.

    all of my source workbooks are originally xlsb is there anyway...
Results 1 to 25 of 43
Page 1 of 2 1 2