For some reason, maybe because it's created from a text file?
The type style is always saved as Courier New with a font size of 10.5, often too small for people to read, especially on a mobile device.
The type style is always saved as Courier New with a font size of 10.5, often too small for people to read, especially on a mobile device.
Code:
Sub SaveAsTextFileFixedSilentClose()
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs FileName:=strFile & "_Word" & ".txt", _
FileFormat:=xlText, CreateBackup:=False
SaveasDoc
strSavedFiles = strSavedFiles & ";;" & strFile1 & ".doc"
Application.DisplayAlerts = False
ActiveWorkbook.Close
Kill strFile & "_Word" & ".txt"
End Sub