Saving workbook without extension?

[K_Man95]

I have a column of data that I copy out of an active workbook from sheet1. I copy this one column to be saved seperately in another workbook. This column will NOT be reopened in Excel. Right now, when I save the file

ColFilename = "C:InputTV_Files_012303s1tp1tv1"

it is saved as: "s1tp1tv1.txt" in the above folder. I want to save it without the extension: "s1tp1tv1" with no .txt on the end. Is there such a way to do that in Excel?

 

[Damon Ostrander]

Hi K,

No, I don't believe Excel will save without assigning a file type, but you can rename a file after the save from VBA using the Name statement (see the Name statement in the VBA helps), and you can remove the file type (extension) in the process.

Of course, if you remove the extension from a file Windows will no longer recognize the file as having any application associated with it, so I'm not sure of the utility of removing the extension. Why do you want to do this (just curious)?

Damon

 

[K_Man95]

Hey D,

Thanks for the reply. I didn't think Excel would be able to do what I was asking without some intervention. Thanks for getting back to me. I will have to look up the Help on Naming and get that removed. The reason I need the file saved with no extension, I don't care about using the file in a Windows application. I am actually creating the file in Windows to be exported into a Linux OS. I am generating binary files in Excel based on user input (converting the input into binary/hex), saving the file (with NO extension), going into Linux, doing a dos2unix convertion, then generating the files with a "snoop" header to be view in Ethereal. Sounds like a LONG process, but the tool that I am developing in Excel will cut down a lot of time.

Thanks for the response and if you have any questions on what I am doing, feel free to email me or reply back again. Thanks again. I am sure I will have more postings when the need arises.......

Later,

K_Man95