I have a problem with macros. Is there a way to cycle saving a file into several folders?
Example, I have to save the "abcd.xlsx" file in all folders of --> ..\MyFolders\data\*
There is one type of For Each ... DirList loop or something like that?
Thanks in advance.
Save the file once, then copy it to the other folders. Search the internet for vbscript code using the FileSystemObject to copy files. See for example: CopyFile Method
I used these commands:
FileSystemObject.CopyFile dir_path&"MyFolders\data\Uno\abcd.xlsx", dir_path&"MyFolders\data\"
but the macro does not work.
Retrieving data ...