SaveAs File Type

[christian2016]

Hi Guys,

In excel I save the file type as "Test".

Putting quotation marks around Test allows me to save the file type as a basic file.

Through VBA i'm unable to get this to work correctly

Example save path
C:\Temp\Testing"Test"

This gives me an error and i believe in may have something to do with the quotation marks.

Is there any way to save file type as a plain file.

Any help is greatly appreciated

Thanks

 

[mrshl9898]

This works for me.

    ActiveWorkbook.SaveAs Filename:= _
        "C:\Temp\Testing.test"

 

[christian2016]

Sorry the directory path should be

C:\Temp\Testing \ "Test"

How am i able to save this as a basic file type.

Thanks for your help

 

[mrshl9898]

ActiveWorkbook.SaveAs Filename:= _
        "C:\Temp\Testing\Test.test"

?

Directory is "C:\Temp\Testing"
File is"Test"
Extension is ".test"

 

[christian2016]

nah so the extension should be a a basic file extension.

Example when I save it in the dialog save as box as "Test" it will save with a file type extension as File.

 

[mrshl9898]

There's a communication barrier here I cannot seem to get past. Maybe an Excel version issue giving us different visuals.

The above will save it as ".txt" (what happens when the extension is ".test"). Not sure what "basic" or "file" extensions are.

When you save as:

File name: Test?
Save as type: is what?

Alternatively, Have you tried the macro recorder?

 

[christian2016]

So basically i need it to save the file type as a windows generic file extension which is a file with no extension.

Web definition
A FILE is a generic file extension that may be appended to a Windows file that does not have an extension. It is an unknown file type and no associated program will automatically open it.

Yes tried the macro recorded unable to get it working the way i want it to.

 

[mrshl9898]

Ok, kind of following now, apologies.

How's this? actually saves it as a FILE File.

ActiveWorkbook.SaveAs Filename:= _
        "C:\Temp\Testing\test.file"

 

[christian2016]

yer done that but i need it not to show the File file extension.

I have been going crazy seems the only way is for the dialog box to open and the user to type the correct format.

I can't seem to achieve the same result in other way

 

[mrshl9898]

Interesting issue here, there's no Enumeration for the file type either...