+ Reply to Thread
Results 1 to 4 of 4

need help..

  1. #1
    ritu
    Guest

    need help..

    I have an excel file (A) on a shared drive.
    The excel file(A) has a macro coded , which on opening the file,
    creates a worksheet in some other workbook(B). What i am trying to do
    is once the file has been opened and macro creates the worksheet time
    stamped in workbook(B),

    now when some else try to open the excel file(A) as its shared from a
    diff computer, i dont want the macro to run again and create the file..
    this time it should just open without runing the macro..

    can someone please guide me how should i go about with this issue..


  2. #2
    Tom Ogilvy
    Guest

    RE: need help..

    Just add code in the code that creates the worksheet in B to check if the
    worksheet already exists. If it does, then exit. Else create it.

    --
    Regards,
    Tom Ogilvy



    "ritu" wrote:

    > I have an excel file (A) on a shared drive.
    > The excel file(A) has a macro coded , which on opening the file,
    > creates a worksheet in some other workbook(B). What i am trying to do
    > is once the file has been opened and macro creates the worksheet time
    > stamped in workbook(B),
    >
    > now when some else try to open the excel file(A) as its shared from a
    > diff computer, i dont want the macro to run again and create the file..
    > this time it should just open without runing the macro..
    >
    > can someone please guide me how should i go about with this issue..
    >
    >


  3. #3
    ritu
    Guest

    Re: need help..

    THANKS TOM ,THIS IS WHAT I AM DOING , I AM LOOKING FOR A METHOD IF
    THERE IS A WAY , WHERE I CAN HAVE MACRO RUN JUST ONE INSTNACE AND IN
    ANY OTHER CASE IT SHUD NOT RUN. THE MACRO.


  4. #4
    Tom Ogilvy
    Guest

    Re: need help..

    Without looking a the results and writing the code to avoid duplicating them,
    I doubt there is any foolproof way to do it.

    --
    Regards,
    Tom Ogilvy


    "ritu" wrote:

    > THANKS TOM ,THIS IS WHAT I AM DOING , I AM LOOKING FOR A METHOD IF
    > THERE IS A WAY , WHERE I CAN HAVE MACRO RUN JUST ONE INSTNACE AND IN
    > ANY OTHER CASE IT SHUD NOT RUN. THE MACRO.
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1