/// <summary>
/// Prompts user to open XL wbk with latest iClick data.
/// </summary>
/// <returns>
/// Returns name of opened XL workbook (string).
/// If user canceled out of FileDialog returns an empty string.
/// </returns>
public bool PromptUserToOpenQuizDataWbk()
{
bool userSelectedWbk = new bool();
string testDataWbkNm = string.Empty;
Office.FileDialog fd = Globals.ThisWorkbook.Application.get_FileDialog(
Office.MsoFileDialogType.msoFileDialogOpen);
fd.Title = "Latest iClick Results";
fd.AllowMultiSelect = false;
fd.Filters.Clear();
fd.Filters.Add("Excel Files", "*.xlsx");
// Handle user selection...
if (fd.Show() == -1) // ...-1 == file opened; 0 == user cxled
{
userSelectedWbk = true;
fd.Execute();
testDataWbkNm = Globals.ThisWorkbook.Application.ActiveWorkbook.Name;
_wbkTestData = Globals.ThisWorkbook.Application.Workbooks[testDataWbkNm];
}
return(userSelectedWbk);
}
