Hello. I am trying to make a macro, where i can chose a file in the macro, that will then have its "LastWrittenTime" appended.
My problem is, that i want to make it as simple as possible for the user, so all they have to do, is choose their file and the macro should do the rest.
Currently it looks like this, and the user also have to put in the directory that contains the file. I have tried putting the file input on the dir browse tool, but then it will also add filename and file extension which the directory tool cannot read. Any ideas?
The Directory tool is used to extract the meta data "LastWrittenTime" and is then joined on FullPath. (The append tool is appending Fullpath from the fileinput, after removing |||Sheet blabla.) Unfortunately i cannot seem to use this as "input" for the file directory.
// Simon
