Here's how you remove the .txt extensions of text files in a folder
Sub Renamer()
Const strPath As String = "C:\Path of Folder\"
Dim strFile As String
strFile = Dir(strPath)
Do While strFile <> ""
Name strPath & strFile As strPath & Replace(strFile, ".txt", "")
s
Okay Tom..I thought in a different way... Code provided by Sam will work...
Regards
Deepak
On Sun, Nov 27, 2011 at 2:35 AM, Sam Mathai Chacko wrote:
> Tom,
>
> Use this example
>
> Sub NameFile()
> Name "C:\Text.txt" As "C:\Text"
> End Sub
>
> Regards,
>
> Sam
>
>
> On Wed, Nov 23, 2011 at 10:51
Tom,
Use this example
Sub NameFile()
Name "C:\Text.txt" As "C:\Text"
End Sub
Regards,
Sam
On Wed, Nov 23, 2011 at 10:51 PM, tom rowe wrote:
> Good morning Deepak.
>
> The files I'm trying to save are configuration files for a SIP/IP
> telephony call server. The server wants to see the file n
Good morning Deepak.
The files I'm trying to save are configuration files for a SIP/IP telephony
call server. The server wants to see the file naming convention as just the
MAC address of the IP phone, hence the need to drop the file extension.
If I can save the file in my Excel/VBA macro after m
Hi Tom,
Just want to ask you before I answer to your query.. How would you
differentiate between an Excel file and Text file if you don't save
them with file extensions..??
Answer: Every operating system use file extensions to recognize
different types of files, so you have to save your every Tex