Gives your user ability to select a workbook from list of open workbooks within same session.
Or call "SelectWorkbookWorksheet_ANmar" to give users option to select workbook/worksheet from list of open workbooks.
See examples
If user presses cancel, blank string is returned, in both functions
Call "SelectWorkbook_ANmar" function to show form asking users for a workbook, then return the selected workbook if selected, or null string if cancel.
Call "SelectWorkbookWorksheet_ANmar" function to show form asking users for a workbook/worksheet combination, then return the selected workbook name and worksheet name separated by {{$S$}}.
Call "SelectWorkbook_ANmar" function to show form asking users for a workbook, then return the selected workbook if selected, or null string if cancel.
Call "SelectWorkbookWorksheet_ANmar" function to show form asking users for a workbook/worksheet combination, then return the selected workbook name and worksheet name separated by {{$S$}}.
None
Msgbox SelectWorkbookWorksheet_ANmar()
Msgbox SelectWorkbook_ANmar()
Msgbox SelectWorkbook_ANmar()
Views 2,612
Downloads 962
CodeID
DB ID