srakascribe.blogg.se - Microsoft word content control to show as none

MICROSOFT WORD CONTENT CONTROL TO SHOW AS NONE HOW TO
MICROSOFT WORD CONTENT CONTROL TO SHOW AS NONE CODE

If they are, they will be output otherwise, you'll need to provide more details. It's not apparent from your post, though, whether those details are stored in content controls in the documents. You also refer to capturing 'the persons name and date'. If you want to record the document's name as part of the data, change: If (Not oFolder Is Nothing) Then GetFolder = Įnd FunctionAs coded, the macro clears and overwrites rows 2 and following in the worksheet. Set oFolder = CreateObject("Shell.Application").BrowseForFolder(0, "Choose a folder", 0) Set wdDoc = Nothing: Set wdApp = Nothing: Set WkSht = Nothing Set wdDoc = (Filename:=strFolder & "\" & strFile, AddToRecentFiles:=False, Visible:=False)Ĭase wdContentControlDate, wdContentControlDropdownList, wdContentControlRichText, wdContentControlText StrFile = Dir(strFolder & "\*.docx", vbNormal) StrFolder = GetFolder: If strFolder = "" Then Exit Sub

MICROSOFT WORD CONTENT CONTROL TO SHOW AS NONE CODE

'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.

MICROSOFT WORD CONTENT CONTROL TO SHOW AS NONE HOW TO

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.