Search:

Type: Posts; User: flora

Search: Search took 0.00 seconds.

  1. I found this code below in the internet, this one...

    I found this code below in the internet, this one you can see that it can pick up range with its image, i tried using the technique below into the above code, but i failed. I appreciate your help.
    ...
  2. Modify the VBA code to exclude text only leave logo from signature

    Dear Friends,

    I have got this code below from this website which is a great piece of code form you gurus.

    I need help with modification of this code. I want to add to each email the logo which...
  3. Thank you DocAElstein

    Thank you DocAElstein
  4. Thank you DocAElstein for your willingness to...

    Thank you DocAElstein for your willingness to help. appreciated.

    I downloaded the two files. when i run the macro. it only created two htm files and nothing into the word.
  5. what is the best way to populate word specific locations from Excel Data

    Hello,

    I have a long word documents that has charts, tables, and paragraphs.

    the charts, tables and some numbers in the paragraph comes from an excel file. but the process is very manual. like...
  6. I have tried using =5* =6* =7* but it did not...

    I have tried using =5* =6* =7* but it did not work.
  7. snb thanks a lot

    snb thanks a lot
  8. thank you kenneth

    thank you kenneth
  9. dear Administrator thanks very much. the code...

    dear Administrator

    thanks very much. the code is much faster and it works as i have excel 2016. it has one issue. the condition of product is missing. it ignores that. the condition on the...
  10. any recommendation for best tutorial to learn scripting dictionary in VBA?

    I am very much interested to learn use of scripting dictionary in VBA and use of Arrays in VBA for Excel.

    do you have any recommendation where should i start? blog, book, video tutorial.

    thanks.
  11. thank you very much Administrator. this...

    thank you very much Administrator.

    this excelfox is really the best.
  12. dear Administrator, how can i change this code...

    dear Administrator,

    how can i change this code that instead of hard coded values of "|2001|2002|2003|2011|2012|2017|" i used cell reference

    for example. my 2001 will be in cell A2 and 2002...
  13. Thank you genius

    Thank you genius
  14. to make it work. i added one extra vertical...

    to make it work. i added one extra vertical bracket If Instr(1,"|2001|2002|2003|2011|2012|2017|", "|" & ShD.Cells(C.Row, intYearCol).Value & "|") >0 Then

    thanks alot


    if this is the one to...
  15. this is the sample workbook. original is more or...

    this is the sample workbook. original is more or less the same. if i can make this work, then i can update the original one as well.

    thanks alot Administrator
  16. WOW! Admin you are amazing! it works. ...

    WOW!

    Admin you are amazing!

    it works.

    thanks so much
  17. thanks very much for reply and willingness to...

    thanks very much for reply and willingness to help.

    i replied to the other thread. pivot table is not an option.

    thanks.
  18. thanks very much for reply and willingness to...

    thanks very much for reply and willingness to help.

    i replied to the other thread. pivot table is not an option.

    thanks.
  19. Thanks. Yes, i am familiar with pivot tables....

    Thanks.

    Yes, i am familiar with pivot tables. this code is part of a an application that my predecessor left. i would not use pivot tables.

    thanks.
  20. How To Avoid Using Too Many OR and AND Functions In VBA

    I have this code below,

    now if i have to modify this, add more conditions. for example more years to include for example instead of many OR and AND functions, i simply want to use an array for...
  21. How can you convert this VBA with use Scripting Dictionary, so it becomes fast.

    Hi have the attached solution which works. but it is too slow.

    i was wondering if there is a way to modify the code and use alternative options in VBA for example Scripting Dictionary to make...
Results 1 to 21 of 21