Forum Discussion
Implicit intersection operator: impact on opening csv files
- Apr 22, 2020
I'd consider that as a bug, better to send a frown.
I'd consider that as a bug, better to send a frown.
- beermattApr 23, 2020Copper Contributor
Detlef_Lewin: thanks for the suggestion, however that also turns what was previously a simple route to edit a csv file into a multi-step process (from open file, make changes, save & close file to rename file, open excel, start wizard, go through steps of wizard, make changes, save & close, rename file back).
SergeiBaklan: thanks, now done that; in my opinion it is a bug, will see if that has any effect.
In the interim I've now created a macro in my personal macro workbook to mitigate:-
Private Sub xlApp_WorkbookOpen(ByVal Wb As Workbook)
If Wb.Name Like "*.csv" Then
Cells.Replace What:="=@", Replacement:="'@", LookAt:=xlPart, SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False _
, FormulaVersion:=xlReplaceFormula2
End If
End SubNot an ideal solution (especially if I need others to make amendments to these files) but will probably suffice.