![]() StrFile = Dir(strFolder & "\*.docx", vbNormal) StrFolder = GetFolder: If strFolder = "" Then Exit Sub 'Note: this code requires a reference to the Word object model.ĭim wdApp As New Word.Application, wdDoc As Word.Document, CCtrl As Word.ContentControlĭim strFolder As String, strFile As String, WkSht As Worksheet, r As Long, c As Long I'm sorry if this is already in a thread somewhere, I've been reading through them for about 3 hours and haven't come across my situation yet so I thought it was best to just ask. All in all I am wanting them to be self-sustaining and I just have to look at the Excel sheet.īasically, I've seen it done but I have NO idea how to do it! Any help or thoughts you could off would be very appreciated. The ultimate goal is that once the person gains access the check mark will be removed from the content box therefore removing the information from the corresponding column on the excel sheet. Now, I am trying to find a way to easily export what is marked as a 'No' along with the persons name and date to that Excel sheet. I also have an excel sheet with a column titled for each of those 399 boxes. Each person will be using these documents to check securities to different systems, if there is no access they will select ‘No’ then enter the date. These will be opened by 1000's of people, renamed and saved back to the same folder on the SharePoint site. Hi, I have 6 word documents with a total 399 Check Content Control boxes, 399 Date Picker Content Control boxes along with a Rich Text Content Control box at the top requiring a name stored on a SharePoint site.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |