How to move all files in a folder to another folder

[nemorick]

Run your attached source code, it only can move files to dest. but the folders or directories under is can not be able to move

[vvaidya (Vinay Vaidya)]

One simple way which will avoid lines of code is to Move the Entire folder (files and subfolders) and Recreate the Source folder.

[nemorick]

this is a quick way but not good for existed folder, Maybe we should use recursive method

[vvaidya (Vinay Vaidya)]

@nemorick

but not good for existed folder,

Yeah if it has any kind of sharing persmissions.

[Venkatesh]

Hi vikas,

Can you please tell me, how to read a file in excel application scope, dynamically?? (File name will change every time)

[vikas_reddy_Vicky (Vikas Reddy Kapu)]

@Venkatesh,

Please refer this

Opening Excel Application Scope within For each row

I am using a For each row actvity where I loop for each row in a data table. Immediately before the For each row activity, I use the Excel application scope and then “Read Range” for one Excel worksheet. Later on within this loop, I need to open the same source Excel worksheet, Execute a Macro, and then call a new variable created by this Macro in a Do while loop. I do this by calling the variable with row(“Column Name”).ToString. The problem is, when I use Write Line to see what value is b…

Regards,
Vikas Reddy

[Venkatesh]

Hi @vikas_reddy_Vicky,

but i have to read only one excel at a time(after reading excel is moved into other location), like that may be 20 in a day . Each file name will be different

[vikas_reddy_Vicky (Vikas Reddy Kapu)]

Hi Venkatesh,

so you have file names in string array (achieved this by using Directory.Getfiles)
now use ‘excel application scope’ inside ‘for each’ loop and pass the file names as variable.

Please let me know if you want any xaml for reference.

regards,
Vikas reddy

[Venkatesh]

throughout the day, files will come. we dont know, when it will come. once it is read, it is moved into another folder.

[Venkatesh]

Hi , @vikas_reddy_Vicky , @badita

I’m using Invoke Method to move folders. But i’m getting ‘access to the path is denied’ when i’m using it.

But i;m able to move folders manually

[Dilli]

Guys,

I’m trying to do a backup of files in a folder and using move activity.

for the property ‘path’ I’m using the directory where the file is located as “D:\folder1\folder 2”

for the property ‘destination’ I’m using the directory where the file is located as “D:\folder1\folder 2\Backup_MMDDYY\abc.txt”

I’m trying to find if a file named “abc.txt” exists in the directory “D:\folder1\folder 2”, If so I’m creating a new directory in “D:\folder1\folder 2” as “D:\folder1\folder 2\Backup_MMDDYY” and trying to move that file to the new directory “D:\folder1\folder 2\Backup_MMDDYY\abc.txt”

I don’t see any error but the file is not moved to the directory.

Any clue ?

“I resolved it” – Thanks.!

[DevJ (Johan)]

Hi,
Can’t get this to work.
Just getting the error message “Directory does not have a public static method named “Move” matching the parameter types, generic type arguments, and generic type constraints supplied in the InvokeMethod”

Can you please attach a workflow showing the correct setup?

[ushu (Usha kiranmai)]

Hello folks,

Whiile I am trying to use invole method it was showing like “Directory does not have public static method named Move directory”. Could any one suggest how can I avoid this error.