I am just trying to copy the AVI files from a source folder into the corresponding destination folder based on the folder names.
For example, the multiple AVI files under Folder C should be copied into Folder xx based on the name"10Q_2P".
I guess the trick here would be the name folders...
How about the file names? I just did a test... the code worked fine with the file names A,B,C but not for a bit more complex names. And the code also worked fine for the folders with existing non-xlsx files. SO the only issue left would be the file names. Is it possible to make some tweaks on...
Does this code work for the file name like 22B_1? Also the folder already contains files before I run the code. Will these two conditions affect the code? Because the code worked for the example I had previously (file A->Folder A, etc) but it did not seem to work for a bit more complicated case.
Following is what I have in the py file, but it does not seem to work:
Add-Type -AssemblyName System.Windows.Forms
$SourceLocation = New-Object System.Windows.Forms.FolderBrowserDialog
$SourceLocation.Description = "Z:\Files"
$DestinationLocation = New-Object...