Changing the file type of exported document

**jj4jj** · 10-14-2015, 07:36 AM

Hello, so i´ve got this code:

stFileLocation = Application.GetSaveAsFilename("Default name of the file")
ActiveWorkbook.SaveAs Filename:=stFileLocation & "xlsx"

Iwould like to export the file as .txt

Is it even possible?

**Kaper** · 10-14-2015, 08:02 AM

Look into: https://msdn.microsoft.com/en-us/lib.../ff841185.aspx

probably:

Please Login or Register  to view this content.

PS. note how code tags (required by our http://www.excelforum.com/forum-rule...rum-rules.html ) improved readability - and edit your post using the tags.