single quote removal

[Serge]

Hi everyone,

Does anyone know how to escape(remove)single quote to
appear before a values, when a report is exported from
Access to Excel. I tried to use "replace", "clean"
or "right" functions but it does not help.

Thank you,

S

 

[Don Guillett]

try
Sub FixRangeValues()
Selection.Value = Selection.Value
End Sub

 

[Guest]

Thank you!
It worked!

Question:
It works on a selected columns range only.
How do I make it to work on every table you open and to
automate this, like a trigger. Also to remove the single
quote from all values in a table at once, without
selecting the table range first. I am novice in VBA. Pls
help.
Pls ask questions, if something is not clear.

Thx

 

[Don Guillett]

glad to help