Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: File path problems

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Here are some file paths I have:

    H:AccountingBudget 2000Sales
    Department expenses

    H:AccountingBudget 2001 Sales
    Department expenses

    H:AccountingBudget 2002 Sales
    Department expenses

    H:AccountingBudget 2003 Sales
    Department expenses

    The workbooks “Sales” and “Department expenses” in each year are linked.
    Each year I create a new Budget year and copy the previous years files.

    The problem I am having is the links between sales and department expenses refer to the previous years files. For example the 2003 links in sales would read H:AccountingBudget 2002’[Department expenses]….
    This is easy enough to fix with a search and replace. The real pain is the macros I have attached to my custom toolbars they refer to the previous year and I actually have to edit each button I have made.

    Is there a simply way to make Excel look in the current file path automatically when a group of related workbooks are copied?

    Any ideas would be appreciated.



    [ This Message was edited by: Jook on 2002-04-12 12:50 ]

  2. #2
    BatCoder
    Join Date
    Feb 2002
    Location
    Turkey
    Posts
    813
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    if file is "c:windowsdesktopbook1.xls" then

    thisworkbook.Path = "c:windowsdesktop"

    You can use thisworkbook.Path value in code.

    Suat

Some videos you may like

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
  •