replace part of string

[Bastien]

I am using vba to dymanically code a series of insert statements via loops. the problem I have is that I sometimes end up with a comma at the end of the sql statement.

How can I use the replace() function to do this? I used the replace function on a ASP page and it works great.

Do I need to reference something specific here?

TIA Bastien

There are many ways to skin this cat,
but it still tastes like chicken

 

[JohnYingling]

Replace is in Office 2000 and up, not in '97. What version are you using?

http://www.VBResizer.com

Forms/Controls Resizing/Tabbing Control

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort Class in VB or VBScript

 

[Bastien]

97 Bastien

There are many ways to skin this cat,
but it still tastes like chicken