Hi everybody, I finally found a way to build a macro that downloads zip files from a specific website location and subsequently unpacks / unzips the downloaded zip file to an Excel file in a designated folder. The unpacked data is subsequently used as input file for a workflow (the macro is part of this workflow). Each month results in a new unzipped file in the current setup, meaning that I have to adjust the connection configuration manually each month to get the actual data into the workflow (see the input file in control container 15 in attached macro and attached screen print which indicates the monthly unzipped files). Does anybody know how I can automate the connection figuration in the input file (of control container 15 in attached macro) in such a way that the input file in this macro will automatically select the actual / latest unzipped file (provided that this is possible)? Hopefully somebody can help me out here...
thx in advance for your thoughts on this one.
