Hello,
This is my first VBA attempt so it may not be pretty, but I appreciate any help.
I have a file that contains a toggle which allows the user to select various views. For each view, a tab in the spreedsheet needs to be copied to a new workbook and saved as a text file. I have managed to get the copy / paste / save portion of the code pieced together as per below:
I would like the above action to loop through the data validation options (Data validation list is located in cell B5 of the 'SAP LoadFile' tab - list reference is located on 'Drop Down' tab in cells A1:A71 - range is named 'Store'). until all possible views provided by the drop down list are saved as text files.
One additional teak if possible is that in the above code I have not figured out how indicate which folder to save to - if fix for this is available that would be great as well.
Thank you for your help in advance.
Bookmarks