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...
I created a text file (not sure how to create Python file) then changed the extension to ".py" and copied your code into it using Notepad++, but it did not seem to run as expected? Or I have to run it under a specific folder path? I would expect a prompt to show up to let me choose the...
Thanks for the help! I am going to try Python first. Does either of these two methods have some sort of UI that allows me to choose the folder path each time before I run it? Because the folder path will be different every time.