in csvhttp://blogs.technet.com/b/heyscriptingguy/archive/2005/03/22/how-can...
>
> http://www.ozgrid.com/forum/showthread.php?t=92436&page=1
>
> On Tue, Jun 14, 2011 at 5:19 PM, Major Bandwith
> wrote:
>
>
>
>
>
>
>
>
>
> > After a few days looki
:
MsgBox (Err.Description)
writeOut2 = 0
Exit Function
finish:
writeOut2 = 1
End Function
Note the new function which, instead of inserting a new line of text
into the stream capability, opens a whole file into it. The stream is
then saved as a UTF8 file.
On Jun 13, 11:43 am, Major Bandwith w
Hi all,
I have some Excel sheets that I want to save as a UTF8 file in .txt
and .csv formats, using a VBA macro. I've found the following code:
'Function saves cText in file, and returns 1 if successful, 0 if not
Public Function writeOut(cText As String, file As String) As Integer
On Error GoT
