+ Reply to Thread
Results 1 to 6 of 6

From a macro, Calling anoter macro at a given line

  1. #1
    Forum Contributor
    Join Date
    08-04-2005
    Location
    Madrid, Spain
    MS-Off Ver
    2010
    Posts
    241

    From a macro, Calling anoter macro at a given line

    In a macro I want to insert a line to to go to another macro, but not starting at the beginning of this second one, instead ata certain line which I would have previously identified by a number on its left.
    What command line do I need in the first macro? I guess it would be something like (if this was right, which it isn't): Call SecondMacro. GoTo 3 (say)
    Thanks in advance.
    ACA
    Last edited by aca; 12-13-2007 at 04:29 PM.

  2. #2
    Forum Contributor
    Join Date
    08-04-2005
    Location
    Madrid, Spain
    MS-Off Ver
    2010
    Posts
    241
    I see that my query has been looked at by quite some people, but no replies.
    Am I to understand that what I'm trying to write is not possible ?
    If it can be done, please, HELP.
    My thanks
    ACA

  3. #3
    Registered User
    Join Date
    12-13-2007
    Posts
    13
    Your best bet is to breakdown the original procedure into smaller procedures. More specifcally, each section that will called by another procedure should be a procedure by it self.

  4. #4
    Forum Contributor
    Join Date
    08-04-2005
    Location
    Madrid, Spain
    MS-Off Ver
    2010
    Posts
    241
    Thanks, hemanu.
    I had thought of that, but I wanted to avoid having so many macros.
    But that's what I will do, since it seems that calling a specific line within a longer macro is not an option.
    ACA

  5. #5
    Registered User
    Join Date
    12-13-2007
    Posts
    13
    It is possible to get a particular line in the procedure, but you would need to include conditional staments in the procedue to ensure that only that line is executed.

  6. #6
    Forum Contributor
    Join Date
    08-04-2005
    Location
    Madrid, Spain
    MS-Off Ver
    2010
    Posts
    241
    Ah ah!, hemanu, tell me more about that, please; for in fact it is not only that one line that I would call, but all the rest of that macro from that line all the way downwards.
    Thanks so much for your help so far; most kind of you
    ACA

+ 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