Macro in one book reading another
Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Macro in one book reading another

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Foster City, Calif
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    A macro in workbook 'A' opens workbook 'B', copies a few data cells from 'B' and pastes them in 'A'. When the macro is run via Tools,Macro,Run, it works just fine. When I use the shortcut key, workbook 'B' opens and the macro stops at the open 'B'. Is there somthing different between the shortcut key and tool bar execution?

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Chippenham, UK
    Posts
    136
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    On 2002-02-21 20:26, ArtK wrote:
    A macro in workbook 'A' opens workbook 'B', copies a few data cells from 'B' and pastes them in 'A'. When the macro is run via Tools,Macro,Run, it works just fine. When I use the shortcut key, workbook 'B' opens and the macro stops at the open 'B'. Is there somthing different between the shortcut key and tool bar execution?
    There shouldn't be any difference in the execution of the macro. Make sure that the shortcut key is pointing to the correct macro and not a different one or an earlier version that you may have written and not completed.

    Regards,

    Gary Hewitt-Long

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com