[joeyward]

I am trying to use an excel myclean function and receiving the error 'myClean' is not declared. It may be inaccessible due to its protection level. C:\Documents and Settings\jcward\My Documents\Visual Studio 2010\Projects\CLSHelpdesk\CLSHelpdesk\Form8.vb 32 33 CLSHelpdesk. I have added the reference to both Microsoft excel 12.0 object library as well as Microsoft excel 5.0 object library. Any help would be greatly appreciated.

Thank you

[modi123_1]

What's your code look like when you are trying to access the file?

[joeyward]

I do not understand what file you are talking about? The String comes from access database that comes from Helpdesk ticket system. And need to remove any unprintable text. Just like Clean does in Excel.

[modi123_1]

... okay so is "Form8.vb 32 33 CLSHelpdesk" a file you are creating or one your project is accessing?

[raziel_]

this error looks to me like your variable "myClean" is not declared. you can however give us a little help and show us the code where you get this error

[lattimer1999]

If I'm reading your post right. See if the below will work.

Dim RegExStr As String = "<[^>]*>"

Dim Myclean As String = Regex.Replace([YourSting], RegExStr, "")

Then the Clean string will be Myclean.

Please let me if you need anymore help.

[joeyward]

lattimer1999, on 02 December 2011 - 12:22 PM, said:

If I'm reading your post right. See if the below will work.

Dim RegExStr As String = "<[^>]*>"

Dim Myclean As String = Regex.Replace([YourSting], RegExStr, "")

Then the Clean string will be Myclean.

Please let me if you need anymore help.

Works great except I also need to remove &nbsp.

[lattimer1999]

Use the below and it will remove that too.

Replace(Myclean, " ", "")

[joeyward]

lattimer1999, on 02 December 2011 - 12:32 PM, said:

Use the below and it will remove that too.

Replace(Myclean, " ", "")

Works like a charm.

Thanks for the help.