+ Reply to Thread
Results 1 to 4 of 4

Taking path name from another excel sheet

  1. #1
    Registered User
    Join Date
    05-30-2011
    Location
    Iowa
    MS-Off Ver
    Excel 2010
    Posts
    23

    Taking path name from another excel sheet

    Hi
    I need help in these. I have attached an excel file which enables to import sheets and other stuff(Thanks to tigeravatar) What I would like to do now is assume that there is a new sheet called the path name with the path in the range (A1). So whatever is in the range A1 would be the path name, thus the person would not need to change it through the coding. Please help! Thanks
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor MaczaQ's Avatar
    Join Date
    06-03-2011
    Location
    Poland
    MS-Off Ver
    Excel 2003 / XP
    Posts
    510

    Re: Taking path name from another excel sheet

    Hello,

    I think that you can just replace [in macro btn_ImportSheets_Click()]:
    Please Login or Register  to view this content.
    and in place where worksheets are delated you have to secure your path sheet so please consider to change one more line:

    Please Login or Register  to view this content.
    Best Regards
    maczaq

  3. #3
    Registered User
    Join Date
    05-30-2011
    Location
    Iowa
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: Taking path name from another excel sheet

    Sorry, I don;t quiet understand the first part. How to change the "path name" into a text?

  4. #4
    Valued Forum Contributor MaczaQ's Avatar
    Join Date
    06-03-2011
    Location
    Poland
    MS-Off Ver
    Excel 2003 / XP
    Posts
    510

    Re: Taking path name from another excel sheet

    the cell contain path should be formatting as "text"

    maczaq

+ 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