Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Forums » Excel Forums » Data Exchange » How can an XL file know if its on Sharepoint?

How can an XL file know if its on Sharepoint?

Previous | Next
Latest post Fri, Apr 4 2008 2:59 PM by Alex J. 0 replies.

  • Fri, Apr 4 2008 2:59 PM

    • Alex J
    • Top 25 Contributor
    • Joined on Wed, Jan 9 2008
    • Posts 21
    • Points 349

    How can an XL file know if its on Sharepoint?

    Reply |Contact

    Not sure if this post belongs in the XL Services forum or here....

    Using pathnames in VBA (for instance to change directory or open another file in the same directory) gets more complicated when the file resides on SharePoint.

    XL2003 has a new (at least to me) parameter [ThisWorkbook.FullNameURLEncoded] which makes it easier - but the file might be on a standard drive or on SharePoint. How to know whether to use [ThisWorkbook.FullName] or [ThisWorkbook.FullNameURLEncoded] ?

     

    Regards, Alex J
    • Post Points: 5
Page 1 of 1 (1 items) | RSS
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.