docmanagement

文件管理

這些是用於管理 Office 文件的範例 vba 程式碼。有些依賴 Access 資料庫。

所有代碼均按原樣提供，不提供任何保證。

我將在我的部落格 https://transcription.aquoco.co/ 上解釋所有這些程式碼的工作原理以及更多內容。

目前就讀於 Lambda School 全端 Web 開發軌道。
freeCodeCamp：https://www.freecodecamp.com/evoingram
駭客排名：https://www.hackerrank.com/evoingram
Pluralsight：https://app.pluralsight.com/profile/erica-ingram
公司：https://www.aquoco.co

我是一名自學成才的程式設計師，正在編寫一個作品集，但現在這裡是我的一些 VBA 程式碼。這裡有一大堆好東西。

簡短的功能描述：

 AcrobatGetNumPages:
	gets number of pages from PDF and confirms with you

AddAQCExamStyle:  
	finds specific phrases in activedocument(transcript) and applies a specific style

BuildRCWsAndRCWHyperlinks:
	Acquires RCWs and their hyperlinks, validates them, and adds an entry for each one to CitationHyperlinks table
	
BuildUSCRulesandUSCHyperlinks:
	validates U.S.C. code citations and builds corresponding hyperlinks, no front matter, no appendices
	
AutoCalculateInterest:
	add 1% interest cost after every 7 days payment not made
	
AutoCorrect:
	adds autocorrect entries as listed on form (from matching table row) to rough draft autocorrect in Word
	
CDLabelMergeF:  
	makes CD label and prompts for print or no
	
CommunicationHistoryAdd:  
	adds entry to CommunicationHistory table in Access DB
	
CreateIndexBMKs:  
	replaces #TOC_# notations in transcript with bookmarks and then places index at bookmarks
	
CreateIndexesTOAs:
	creates several TOCs that are marked differently and several sections of tables of authority.
	example: separate TOCs for exhibits, witnesses, and a general index
		 separate TOAs, three sections, one for cases, one for rules/regs/statutes/code/etc, one for other authority
	
CreateWorkingCopy:
	creates "working copy" sent to client
	
FPJurors:  
	does find/replacements of prospective juror shorthand in transcript

FillInPDFfromDatabase:
	inserts page count & other transcript info into invoice PDF

FindAndReplaceCitationHyperlinks:  
	adds citations and hyperlinks from CitationHyperlinks table in transcript
	
GenerateInvoiceAndEmailWithPPButton:
	generates invoice and Outlook e-mail body to include a linked PP button
	
GenerateInvoiceNumber:
	generates invoice number
	
GenericExportandMailMerge:  
	exports to specified template from T:Document GeneratorTemplates and saves in T:In ProgresssCourtDatesID
	
HeadersFooters:  
	programmatically adds headers and footers
	
OneNoteVBA-CreatePage:  
	Creates pages in a specified OneNote notebook
	
OneNoteVBA-GetNotebooks:  
	Returns list of OneNote notebooks
	
OneNoteVBA-GetPages:  
	Returns pages of a OneNote notebook
	
OneNoteVBA-GetSectionGroups:  
	Returns section groups of a OneNote notebook
	
OneNoteVBA-GetSections:  
	Returns sections of a OneNote notebook
	
OneNoteVBA-SearchPageTitlesReturnResults:  
	Returns OneNote pages that match a search result
	
ReadXML:  
	reads shipping XML and sends "Shipped" email to client
	
SendWordDocAsEmail:  
	sends Word document as an e-mail body with optional attachments

TCEntryReplacementPARENT:
 	parent function that finds certain entries within a transcript & assigns TC entries to them for indexing purposes

TCEntryReplacementCHILD-SingleReplaceAll
	one replace TC entry function for ones with no field entry

TCEntryReplacementCHILD-FieldReplaceAll
	one replace TC entry function for ones with field entry

WordIndexer:  
	builds word index in separate docx & PDF from transcript

WunderlistAdd:
	arguments sTitle as string, sDueDate as string, due date format YYYY-MM-DD
	adds task to Wunderlist
	
WunderlistGetAllLists:
	gets all lists from Wunderlist
	
WunderlistGetList:
	gets tasks from an existing wunderlist list

~MySQLExamples
	samples of actual queries from my database.