Posts by youtham

    Hi All


    i am facing a strange problem, the below code works fine in one computer and gives error in another computer.


    Both the computers have EXCEL 2007, both have installed the OBIEE office feature in the computer.


    Set cbTaskPane = Application.CommandBars("Oracle BI EE")
    cbTaskPane.Controls("Refresh &All").Execute


    do you know what we are missing,


    thanks

    hi geeks


    i have a text file with 500,000 lines about 240 MB


    i already have a macro to read thru the text file and filter (OPEN, READ, CLOSE). It takes lot of time to process.


    I go to the text file for 10,000 times to fetch data.


    is there any alternates and utilities to fasten this process


    thanks
    youtham

    Re: encountered a ....... and needs to close


    this is the function code


    there was no error untill i protected the sheet by locking the cells which have the formula "=+DCVAL($B$16,B49,C49,D49,E49)"


    if i change anything in cell c49, the error occurs
    c49 has a validation list


    dear techies


    the following error occurs when worksheet_change() event is triggered from a particular cells


    "microsoft office excel has encountered a problem and needs to close.
    we are sorry for the inconvenience"


    that particular cell has link to a private FUNCTION created by me


    if u want the file i can send thru pm


    pls help me


    thanks
    Youtham

    Dear Techies


    the below code is not hidding and unhidding row
    event enters the if condition and executes the code



    Re: various versions of MSOUT.olb


    hi roy,


    i m using the below code and add reference to outlook 11.0 library and send it across to my users sitting in different versions of excel ranging from 97/2003. users having outlook library version below 11.0/10.0 have object reference error.


    so i have to manually ask them to add references