![]() ![]() The company bought/is in the Office 365 program, so we all have access to Teams, Sharepoint and Outlook and so forth. Hence it is arguably easy to access these files, since it is quite easy to either use a defined path (as a string variable) or have the colleague navigate to the files' folder by using Application.FileDialog(msoFileDialogFolderPicker). They files currently are located on a network drive. Multiple colleagues work with these files. There are a few noteworthy aspects to mention: Because these are 9 files, I use a main "admin" workbook, for the lack of a better term, to keep them all updated in regards to their content, formatting and macros. The files all use macros and activex buttons for arguably fast(er) navigation and automated data processing. ![]() I maintain files for tracking certain items, their workflow statuses and other data related to an entry/item. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |