676
General Software Discussion / Re: how can I do this in excel?
« Last post by TaoPhoenix on March 23, 2015, 11:11 AM »There's some "medium tech" solutions here, but I am thinking of one of my low level hacks.
: )
Last I understood, the excel file is like an "index" to stuff in the folder.
So not counting things like minor diffs between excel I don't currently have and Libre Office, I do think you can do this, "look locally in a folder" by doing a type of "double processor" where one cell grabs the full "hardlink" downloaded or not, then does something like Right$ reading right to left and dumping the rest because the final file name isn't changing but only the initial path.
Maybe I can whack something together as a demo.
I used to do a lot of this kind of thing, so your manager isn't wholly wrong, the question is whether we can "connect all the pieces".
: )
Last I understood, the excel file is like an "index" to stuff in the folder.
So not counting things like minor diffs between excel I don't currently have and Libre Office, I do think you can do this, "look locally in a folder" by doing a type of "double processor" where one cell grabs the full "hardlink" downloaded or not, then does something like Right$ reading right to left and dumping the rest because the final file name isn't changing but only the initial path.
Maybe I can whack something together as a demo.
I used to do a lot of this kind of thing, so your manager isn't wholly wrong, the question is whether we can "connect all the pieces".