sowmya.mr
01-04-2013, 04:44 AM
Hi All,
I am exporting a form to excel and I want two columns to be replaced with Yes/No instead of True/False.
I have written the following code to export to excel and replace true/false with yes/no. But for the first time the code doesn't work.
Can anyone help me regarding this?
DoCmd.OutputTo acOutputForm, "Form1", acFormatXLSX, "", True
Columns("L:M").Select
Selection.Replace What:="True", Replacement:="Yes", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Selection.Replace What:="False", Replacement:="No", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
I am exporting a form to excel and I want two columns to be replaced with Yes/No instead of True/False.
I have written the following code to export to excel and replace true/false with yes/no. But for the first time the code doesn't work.
Can anyone help me regarding this?
DoCmd.OutputTo acOutputForm, "Form1", acFormatXLSX, "", True
Columns("L:M").Select
Selection.Replace What:="True", Replacement:="Yes", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Selection.Replace What:="False", Replacement:="No", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False