PING: Visual Basic question
 

Hi all- I hope someone can help... I have data in excel that I am copying into a IBM Mainframe via VB. To keep the original formatting of the data, I had to add an ' to each cell, and it is saved in .csv format. what is the best way to remove the ' when putting the data back in to the mainframe? On some cells I can use " .TransmitANSI Right$(BrandCode, 8), but if there are more or less than 8 digits plus the ', that doesn't work. Any thoughts?

Would this work?

Replace(txt,"'",""))

i'll try it out. still learning vb on the fly... thanks for your response.

lighthousekeeper- that did it. thanks for your timely response!