Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error when saving as TAB TXT (euro transforms in $)
Hi.
I've made a simple macro to save 2 sheets do a txt tab separated. The problem is that the numbers formated as "currency" (with a euro sign) end up with a dollar sign in the resulting txt. Does anyone knows why this is hapenning? this is my code Sheets("HOLDI").Select ActiveWorkbook.SaveAs Filename:=3D _ ActiveWorkbook.Path & "\..\Dados_holdi.txt" _ , FileFormat:=3DxlText, CreateBackup:=3DFalse Sheets("EMP").Select ActiveWorkbook.SaveAs Filename:=3D _ ActiveWorkbook.Path & "\Dados_emp.txt" _ , FileFormat:=3DxlText, CreateBackup:=3DFalse ActiveWindow.Close Thnks a lot SpeeD |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error when saving as TAB TXT (euro transforms in $)
Try the below macro
Sub Macro3() Dim strPath As String strPath = ActiveWorkbook.Path & "\" Application.DisplayAlerts = False Sheets("HOLDI").Select ActiveWorkbook.SaveAs Filename:=strPath & "Dados_holdi.txt", _ FileFormat:=xlText Sheets("EMP").Select ActiveWorkbook.SaveAs Filename:=strPath & "Dados_emp.txt", _ FileFormat:=xlText Application.DisplayAlerts = True ActiveWindow.Close False End Sub If this post helps click Yes --------------- Jacob Skaria "SpeeD" wrote: Hi. I've made a simple macro to save 2 sheets do a txt tab separated. The problem is that the numbers formated as "currency" (with a euro sign) end up with a dollar sign in the resulting txt. Does anyone knows why this is hapenning? this is my code Sheets("HOLDI").Select ActiveWorkbook.SaveAs Filename:=3D _ ActiveWorkbook.Path & "\..\Dados_holdi.txt" _ , FileFormat:=3DxlText, CreateBackup:=3DFalse Sheets("EMP").Select ActiveWorkbook.SaveAs Filename:=3D _ ActiveWorkbook.Path & "\Dados_emp.txt" _ , FileFormat:=3DxlText, CreateBackup:=3DFalse ActiveWindow.Close Thnks a lot SpeeD |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
xml transforms to rearrange worksheet data? | Excel Discussion (Misc queries) | |||
error on saving | Setting up and Configuration of Excel | |||
Fast fourier transforms | Excel Worksheet Functions | |||
Excel 2007 - error saving file & error loading dll | Excel Discussion (Misc queries) | |||
Saving Error | Excel Discussion (Misc queries) |