macro that reads all the files in a directory
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello, I have a macro that reads all the sheets in the fileonea (Table of Query: List of Sheet Names).
The action tool Update the Value as follow:
But I also need that the macro reads all the files (fileonea, filetwoa, filefoura) in the directory :
So, I have created a workflow that starts with directory tool and receives the macro :
For some reason, the workflow doesnt work and I have to upload manually all the files one by one in the macro detailed before. I have tried some different options but with no result.
Would you mind explaining me how read automatically all the files in a directory?.
I think that it could be that the macro receives the list of sheet names but the directory has the path or the filename but not the list of sheet names...i guess
Your help is much appreciated.
Regards,
- Labels:
- Iterative Macro
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, it gives this error while running workflow
