Files read
- 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
I need assistance with the following issue. I have a macro that helps me fill in some details within a blob template. The macro works more or less as intended. In my 'Example workflow', I would like to use the macro and also incorporate a directory containing multiple .xlsx files. I need to create a macro that will take the output of the blob macro and the path where the .xlsx files are saved, read them, and allow the user to select which sheet will eventually be appended to the blob file. I'm not sure how to do that since the output of the blob is already saved. I suppose I need to modify the initial blob macro, but I can't pinpoint what needs to be changed. I have attached a FinalOutputExemp.xlsx for reference for the final output representation.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Your use case is a chained app. select a file. Select a sheet = chained app. app 1) - select file. get list of sheet names. 2) app 2 - populate drop down from sheetnames of app 1 - generate drop down - update blob/template.
