In VBA I would Activate and then select the file. But not sure how to access an already open workbook object. I am assuming that I may need to use some public variables. However, I do not know how to activate or access the already open Excel file upon the OK button click event. Then the user clicks OK with the intention of triggering the main routine which is aimed at going through the already open Excel file and extracting information. Once the Excel file is open, the user is then prompted to click a few more controls on the userform. I have a routine which prompts the user with a userform and asks to open an Excel file.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |