Hey Mr.Excel experts,
I'm in need of some assistance here, In order to locate and copy over 1000+ Pdf files I'm trying to create a simple set of strings to apply a wildcard value to a specific column so that each of the entries contains a numerical value (which I already have) and here's the fun part I don't have the alphabetical values which should all be 1 or 2 names. Some of the files may have a Hyphen in between both values.
My goal is to export this list to create a *.bat file so I can run this as needed with little effort.
Anyone have an idea how I can do this?
Here's the excel table I'm using
<tbody>
</tbody>
as for the VB I tried to use the Amendrightafter function to make sure that the ".pdf" is included but this syntax won't take a wildcard value before the .pdf
Thanks in advance for the replies
I'm in need of some assistance here, In order to locate and copy over 1000+ Pdf files I'm trying to create a simple set of strings to apply a wildcard value to a specific column so that each of the entries contains a numerical value (which I already have) and here's the fun part I don't have the alphabetical values which should all be 1 or 2 names. Some of the files may have a Hyphen in between both values.
My goal is to export this list to create a *.bat file so I can run this as needed with little effort.
Anyone have an idea how I can do this?
Here's the excel table I'm using
Output | Current Path folder | File name | Destination folder | |||
Copy | =CONCATENATE($I$2;$E$2;F2;$I$2) | T:\Users\Main\Test1 | test.pdf | T:\Users\Main\Test2 | ||
Copy | ||||||
Copy | ||||||
Copy | ||||||
Copy |
<tbody>
</tbody>
as for the VB I tried to use the Amendrightafter function to make sure that the ".pdf" is included but this syntax won't take a wildcard value before the .pdf
Thanks in advance for the replies