Export Excel Worksheet to File (with Macro)

StrongSteve · Jul 12th 2004

Hi everybody!

I need to export an excel worksheet (just some rows and special cells) to an file with the extention .exs. It should be exported nomally like exporting to a textfile, so that I am able to read it with tools like UltraEdit.

How do I write such a macro, exporting things to a file?

Thx in Advance!
Stef

Jong · Jul 12th 2004

Here is how i accomplish your requested task:
NOTE: You may have to add a reference to Microsoft scripting Runtime in your VBA Editor (Tools > References)

Code

Sub WriteFile()


Dim FileName as String


FileName = ThisWorkbook.Path & "\MyFile.exs"
Open FileName For Output As #1


Print #1, "Enter what needs to be printed here" 
Print #1, "Each Print statement will also give you a Line Feed/CR"
Print #1, "Cells can be printed too" & Range("C4")


'Close stream when done
Close #1


end Sub

Display More

Export Excel Worksheet to File (with Macro)

Participate now!

Share