none
How to use the path of an excel filevariable in a formula? RRS feed

Answers

  • Your problem can be splitted in below subproblems..

    get the somefilevariable . Which I guess is some path and filename

    prefix a single quote [excel adds whenever space is in any path]

    get folderpath of above variable alongwith drive subfolders

    add opening third bracket

    get the filename from above variable alongwith extension

    add closing third bracket

    -------------

    Rest will be given by user and he has to put the closing single quote manually.

    Not sure why you need this. If you can open the source file once and write the formula normally and then close source file Excel does above all automatically.


    Best Regards,
    Asadulla Javed, Kolkata
    ---------------------------------------------------------------------------------------------
    Please do not forget to click “Vote as Helpful” if any post helps you and "Mark as Answer”if it solves the issue.

    Wednesday, January 7, 2015 2:54 PM
    Answerer
  • Monday, January 19, 2015 10:12 AM

All replies

  • Your problem can be splitted in below subproblems..

    get the somefilevariable . Which I guess is some path and filename

    prefix a single quote [excel adds whenever space is in any path]

    get folderpath of above variable alongwith drive subfolders

    add opening third bracket

    get the filename from above variable alongwith extension

    add closing third bracket

    -------------

    Rest will be given by user and he has to put the closing single quote manually.

    Not sure why you need this. If you can open the source file once and write the formula normally and then close source file Excel does above all automatically.


    Best Regards,
    Asadulla Javed, Kolkata
    ---------------------------------------------------------------------------------------------
    Please do not forget to click “Vote as Helpful” if any post helps you and "Mark as Answer”if it solves the issue.

    Wednesday, January 7, 2015 2:54 PM
    Answerer
  • Monday, January 19, 2015 10:12 AM