Search:

Type: Posts; User: ashu1990

Search: Search took 0.01 seconds.

  1. Get The Large Number From Range By Skipping Values Based On A Condition

    Hello guru's,

    i am not sure if it can be done but any thing is possible for the guru's

    Column A Column B
    I 10
    I 90
    A 30
    B 40
    C 50
  2. Replies
    2
    Views
    2,720

    try setting the files into the variables to work...

    try setting the files into the variables to work on them eg:-




    dim wbk as workbook
    set wbk = workbooks.open(path)
    or set wbk = activeworkbook
  3. i have made this for text comparision you can...

    i have made this for text comparision you can compare with height,width and more. for comparing with your local machine image

    try this




    Sub test()
    Dim pic As Shape, a As Shape, b As Shape...
  4. Replies
    4
    Views
    2,925

    this is because you are using some of the...

    this is because you are using some of the reserved words of acess DB try checking the DB titles or the words which are used in the SQL statement
  5. Replies
    22
    Views
    10,755

    Hi fox, :peacesign: just intersted to know new...

    Hi fox,
    :peacesign:
    just intersted to know new things jamil whats to export all inbox into a worksheet and map the difference between 2 replis is this the task.
    did not know what exactly he wants...
  6. Replies
    3
    Views
    3,705

    Hey thanks transformer.. :rolleyes: i did the...

    Hey thanks transformer.. :rolleyes:
    i did the both adding space and the brackets together so forgot :wakeup: to mentioned that thanks for the reply..
  7. Replies
    3
    Views
    3,705

    for those searching the same answer; i got it...

    for those searching the same answer;
    i got it working the reason error occured was due to no space given after each "=" ;)

    cheers :cheerclink:
  8. Replies
    1
    Views
    1,323

    try this before calling the function if ...

    try this before calling the function
    if instr(your text,"characters") > 0 then
    '''do your stuff'''
    end if
    this will help you to find if char or no char are present in the text
  9. Replies
    22
    Views
    10,755

    hi would like to give a try what exactly do you...

    hi would like to give a try what exactly do you need?
  10. Replies
    3
    Views
    3,705

    Syntax Error In SQL Update Query Statement

    Hi All,

    i am trying to run a update code from vba through adodb connection my Db is .MDB,
    while runnign the update query i am getting "syntax error in update statement" error please help
    As i...
  11. calculate sum of three numbers where the answer should be zero

    Hi guys,

    I am stuck into a following thing i have 3 amount where i need to calculate the sum of three amount and the answer should be zero i tried using loop but no sucess :confused: any...
  12. Replies
    9
    Views
    12,183

    At last i completed it with lots of R&D and...

    At last i completed it with lots of R&D and googling i got it worked posted the code for your refrence.:cheers:


    Set myHTMLDoc = ie.document

    Set myHTMLFrame2 =...
  13. Replies
    9
    Views
    12,183

    Hi fox thanks for the reply when you can be home...

    Hi fox thanks for the reply when you can be home im at office till 8:30 IST so if you get me some code to click on the tabel urls and to change combobox value
    in ie i checked from my end i am...
  14. Replies
    9
    Views
    12,183

    Mr fox i got the code running for taking element...

    Mr fox i got the code running for taking element id from frame and tabels but when clicking the button throught element id code runs but does not click on the button on ie below is the code which i...
  15. Try This Easy and works every time;) Sub...

    Try This Easy and works every time;)


    Sub test()
    Range("A1").Select
    Do While ActiveCell.Address(0, 0) <> Range("A65536").End(xlUp).Offset(1, 0).Address(0, 0)
    If LCase(ActiveCell.Value) =...
  16. Replies
    9
    Views
    12,183

    Hi Fox tried the code but it says object doesnt...

    Hi Fox tried the code but it says object doesnt support the property or method wherein i tried with the innertext but didn't worked.
    as its in a frame on a table does firstly i have to get the frame...
  17. Replies
    9
    Views
    12,183

    Hi thanks for the reply as its a company link it...

    Hi thanks for the reply as its a company link it wont work on your pc as i have attached a image of it and posted the whole source code please if you can provide me the code to click the cutton which...
  18. Replies
    4
    Views
    3,935

    assign the file name to a string and then...

    assign the file name to a string and then activate it.



    wbk = activeworkbook.name
    windows(wbk).activate
  19. Replies
    9
    Views
    12,183

    Unable to Get ElementID In VBA IE Automation

    Hi
    i am really stuck bad in ie automation where m not able to select an combobox option with the element id can any one help.

    i have puted the html code i got from the web page please help me on...
  20. Replies
    7
    Views
    2,137

    try this

    riga = Range("A:C, G:G").find
Results 1 to 20 of 20