Excel for Mac is not executing macro

[kevivu]

We have a macro that is working fine in windows, but the same is not working in excel for Mac 2011. Found there is an issue with the following code...

    Dim fso As Object
    Set fso = CreateObject("Scripting.FileSystemObject")
    Dim oFile As Object
    Set oFile = fso.CreateTextFile(ActiveWorkbook.Path & "\preview.html")
    oFile.WriteLine FullText
    oFile.Close
    Set fso = Nothing
    Set oFile = Nothing

Anyone would you please help me to fix.

Thanks.

[AlphaFrog]

I think this will work in a Mac

    Dim FF As Integer
            
    'Write to text file
    FF = FreeFile()
    Open ActiveWorkbook.Path & Application.PathSeparator & "preview.html" For Output As #FF
    Print #FF, FullText
    Close #FF

[kevivu]

Thanks a lot for you response.. But still i am facing some issues.

Herewith attaching my entire code with the change you have suggested... and also attaching the error message.

Code: WordReplacer_Teste (2).xlsm

Error msg: https://dl.dropboxusercontent.com/u/108002926/WR.mp4

Macro Execution:

Steps: copy this lyric ( http://www.azlyrics.com/lyrics/jessglynne/loveme.html )in the first and second text box and click on Processar and then Inserir ... After 30 to 40 seconds it should display the correct translated content in an html file. but now its writing some junk values in the html...

Hence please check and do the needful.

Thanks.

[kevivu]

Anyone would you please help me to rectify this issue

Thanks in advance,.

[kevivu]

All,

It would be grateful if anyone could help me on this..

thanks.

[kevivu]

All,

kindly help me pls..

Thanks.

[kevivu]

Please help me

[kevivu]

All,

I am willing to pay for the help...

Please someone look into this and rectify.

Thanks.