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]

GOTHIM!!!

Ran this:

Sub Macro2()'
' Macro2 Macro
'
Dim fstring As Long
Dim fname As Long


fname = 1
fstring = 0




On Error Resume Next
'
Do Until fname = 1000


    ActiveWorkbook.SaveAs Filename:= _
        "C:\Users\andrew.marshall\Desktop\Testing\" & fname, FileFormat:=fstring
        
fname = fname + 1
fstring = fstring + 1
Loop
        


End Sub

It is FileFormat 42

    ActiveWorkbook.SaveAs Filename:= _
        "C:\Users\andrew.marshall\Desktop\Testing\yes", FileFormat:=42

 

[christian2016]

Thats perfect.

Thanks you so much