![]() |
|
#4
|
||||
|
||||
|
You need to change the following section - the rest seems OK
Code:
Sub UpdateSubject()
Dim SaveCode As String
Dim KeyWord As String
Dim objItem As Object
Dim strSubject As String
KeyWord = "TSD"
SaveCode = TextFile_PullData
If SaveCode = "" Then Exit Sub
Set objItem = GetCurrentItem()
strSubject = objItem.Subject
objItem.Subject = "[" & KeyWord & "=" & SaveCode & "] " & strSubject
Set objItem = Nothing
End Sub
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Macro to read text file and organize data in excel
|
srinidhi.mv88 | Excel Programming | 5 | 05-19-2015 12:06 AM |
Read only file
|
NienkeG | Word | 2 | 08-03-2014 03:57 PM |
| Read the newest file in a folder, how? | DID | PowerPoint | 1 | 07-09-2014 01:40 AM |
Read text Report file with VBA and write parsed fields to Excel workbook
|
tpcervelo | Excel Programming | 1 | 01-05-2012 10:14 PM |
| PowerPoint can't read x.ppt file? | chronic student | PowerPoint | 0 | 05-30-2006 05:35 AM |