Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 11-22-2018, 09:31 PM
gmayor's Avatar
gmayor gmayor is offline Read text in a file Windows 10 Read text in a file Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,138
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

It is not clear what the relevance of the keyword is or what the content of the textfile is, but the following provides the additional error trapping you need.
Code:
Option Explicit

 Function TextFile_PullData() As String
'Graham Mayor - https://www.gmayor.com - Last updated - 23 Nov 2018 

 'PURPOSE: Send All Data From Text File To A String Variable
Dim TextFile As Integer
Dim FilePath As String
Dim FileContent As String
Dim fso As Object
    'File Path of Text File
    FilePath = Environ("USERPROFILE") & "\Temp\VFile.txt"
    'or for the User Temp folder
    'FilePath = Environ("TEMP") & "\VFile.txt"
    'However these are not the same folder

    Set fso = CreateObject("Scripting.FileSystemObject")
    If fso.FileExists(FilePath) Then
        'Determine the next file number available for use by the FileOpen function
        TextFile = FreeFile
        'Open the text file
        Open FilePath For Input As TextFile
        'Store file content inside a variable
        FileContent = Input(LOF(TextFile), TextFile)
        'Close Text File
        Close TextFile
        'Report Out Text File Contents
        TextFile_PullData = FileContent
    Else
        TextFile_PullData = ""
        Beep
        MsgBox FilePath & vbCr & " is not available"
    End If
    Set fso = Nothing
End Function

'Second part it takes the Information and adds it to this script in the TextFile_PullData

Sub UpdateSubject()
Dim SaveCode As String
Dim KeyWord As String
Dim objItem As MailItem

    KeyWord = "TSD"
    SaveCode = TextFile_PullData
    If SaveCode = "" Then Exit Sub
    Set objItem = GetCurrentItem()
    objItem.Subject = "[" + KeyWord + "=" + SaveCode + "] " + objItem.Subject
    Set objItem = Nothing
End Sub

Function GetCurrentItem() As Object
Dim objApp As Outlook.Application

    Set objApp = Application
    On Error Resume Next
    Select Case TypeName(objApp.ActiveWindow)
        Case "Explorer"
            Set GetCurrentItem = objApp.ActiveExplorer.Selection.Item(1)
        Case "Inspector"
            Set GetCurrentItem = objApp.ActiveInspector.currentItem
    End Select

    Set objApp = Nothing
End Function
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Read text in a file Macro to read text file and organize data in excel srinidhi.mv88 Excel Programming 5 05-19-2015 12:06 AM
Read text in a file 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 in a file 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:44 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft