dcsimg
Results 1 to 2 of 2

Thread: [RESOLVED] Excel - Macro in one book, called from another (function in cell)

  1. #1

    Thread Starter
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Resolved [RESOLVED] Excel - Macro in one book, called from another (function in cell)

    Hi

    I have a macro in one workbook. I want to run it via cells function (=xxxxx(cellref) ) but because it is in another workbook excel cannot see it.

    Whats the way to specify to call it from the other workbook?

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...

  2. #2

    Thread Starter
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Re: Excel - Macro in one book, called from another (function in cell)

    Nevermind - got it... My vba had errored... works fine ('macros'!macroname(cellref) )

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...

Posting Permissions

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



Featured


Click Here to Expand Forum to Full Width