removing " when running load scripts

  • Thread starter Thread starter tim
  • Start date Start date
T

tim

I need to code something , not sure what/now.

I load schemas from a database
my current code runs in several steps, ( imports, macros
and queries) I need to add one more thing.

I need to remove the ".

how do I code the repace_all ( edit replace)

Thanks
 
If you've the code in a variable strCode, the following will remove all
quotes from it:

Replace(strCode, Chr$(34), vbNullString)

or

Replace(strCode, """", "")

However, might there be legimate quotes in the code?
 
Thanks
-----Original Message-----
If you've the code in a variable strCode, the following will remove all
quotes from it:

Replace(strCode, Chr$(34), vbNullString)

or

Replace(strCode, """", "")

However, might there be legimate quotes in the code?

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)





.
Click to expand...
 
Back
Top