Moving file confuses macros
Manage your personal finances in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Moving file confuses macros

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Clovis, NM
    Posts
    334
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have developed a file in Excel 97 on my local PC that contains about 20 Subs all located in "This Workbook". I moved the file to a network where it is opened in Excel 2002 (OfficeXP). When attempting to execute any of the macros, an error box opens saying that a file with the same name is already open. None of the macros points to any file by name or path but obviously there is something doing that. I'd be grateful for ideas.

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Clovis, NM
    Posts
    334
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    I might have figured this out. I could run any of the macros from Alt-F8. Seems the macros assigned to my custom toolbar buttons were still pointing to the same file name on the a: drive. I can reassign all the macros to the custom toolbar buttons but is there an easier way?

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