topic Re: Macro to save a file in multiple folders in QlikView

Macro to save a file in multiple folders

Fri, 01 Apr 2016 10:36:59 GMT

Hello everyone,

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.

Re: Macro to save a file in multiple folders

Gysbert_Wassenaar — Fri, 01 Apr 2016 11:26:34 GMT

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

Re: Macro to save a file in multiple folders

Fri, 01 Apr 2016 13:26:13 GMT

I used these commands:

Sub Multicopy

FileSystemObject.CopyFile dir_path&"MyFolders\data\Uno\abcd.xlsx", dir_path&"MyFolders\data\"

End Sub

but the macro does not work.