I've looked at the xlDialogs and none of them seem to give an output that can be used to return a folder path. It also appears that treeview is incompatible with Excel 97.
Does anyone have any ideas on how I might accomplish giving the user the interactive ability to select a folder path that...
I have set up an automated process. At the end I tidy up the Workbook by deleting a number of worksheets (not all) using the code:
ActiveWindow.SelectedSheets.Delete
Unfortunately this code is activating a message box asking for confirmation of the deletion. Defeats the auto purpose.
I've...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.