Removing spaces from a line.

[CD Tom]

This is probably very simple but I'm having a hard time with it. I create a report that is converted into a PDF and it has a name "Preview Final Results.pdf" this name can be anything depending on the report I create. I would like to remove the spaces so the name would be PreviewFinalResults.pdf I think there is also a way to make the name lower case. The reason for this is it gets loaded to a website so it can be viewed but once on the web it doesn't like the spaces. Is there a way to do this.
Thanks for any help,

[Luk3r]

1) Use the Replace() function.
http://msdn.microsoft.com/en-us/libr...=vs.90%29.aspx
2) Use the LCase() function.
http://msdn.microsoft.com/en-us/libr.../gg264497.aspx

[ADezii]

As indicated by Luk3r, the Replace() Function nested within the LCase() Function will do the trick, as in:

Dim strTest As String
 
strTest = "SHE           SELLS     SeaShELLs BY tHe seashoRE!"
Debug.Print LCase(Replace(strTest, " ", ""))
 

OUTPUT:

shesellsseashellsbytheseashore!

[CD Tom]

@ADezii
Worked perfect. Thanks

[ADezii]

You are quite welcome, CD Tom.

[zmbd]

Per ADezii's request:
After reviewing the thread, Luk3r provided the basis for the solution.

ADezii, thank you for pointing this out, as always an Officer and a Gentleman (^_^)

[NeoPa]

ADezii's too modest.

Going by the OP's response I would say that it was ADezii's post he found most helpful.

That said, Luk3r's post provided the basis for the answer so I'm happy it should show as BA.

If ADezii's answer had been provided by the OP then it would not have been allowed as BA in those circumstances of course