Problem writing cell contents to text file

[ronnyfo]

I have written a macro which generate a report configuration file (for Safran Project)
the configuration file looks fine in Excel - however when i save it as Tab-separated text file it converts one particular cell contents into a string of #'s
The cell content is only as follows:
000000070000000000000000080100000000000000060000000000000035110100100110320400000000000002011000010300000350000300000080000000000100Times New Roman 0000000000Times New Roman 0000000000Times New Roman 0000000000Times New Roman 0000000000Times New Roman 0000000000Times New Roman 0000000000Times New Roman 0000000000Times New Roman 0000000000Times New Roman 0000000000Times New Roman 0000000000Times New Roman 0000000000Times New Roman 0000000000Times New Roman 0000000000000001677721500167772150016777215<Timenow>


Is there any quick fixes to make Excel write this to the file, instead of #'s
(without having to re-write the macro to write one and one character to the file?)

 

[Ralajer]

Could you post the code you're using. I tried to reproduce the problem but I couldn't. This is the code I used to test

Sub Macro1()

    Dim reportPath As String
    Dim tempPath As String
    Dim wb As Workbook
    Dim wbCopy As Workbook
    
    Set wb = ActiveWorkbook
    
    reportPath = wb.Path & "\" & "TabDeliminated.txt"
    tempPath = Environ("Temp") & "\" & Format(Now, "HHMMSS") & wb.Name
    
    wb.SaveCopyAs tempPath
    
    Set wbCopy = Workbooks.Open(tempPath)
    
    Application.DisplayAlerts = False
    wbCopy.Saveas Filename:=reportPath, FileFormat:=xlText, CreateBackup:=False
    Application.DisplayAlerts = True
    
    wbCopy.Close SaveChanges:=False
    Kill tempPath
    wb.Activate
End Sub

 

[ronnyfo]

Actually i managed to solve the problem late last night.
Originally I had formatted the cell in question as Text, but formatting the cell to General before I save to file, the problem was solved.

Thanks anyway