PDA

View Full Version : Solved: Problem with textfile save



callen2468
05-29-2009, 05:57 AM
I have a userform that has a textbox that contains a formatted display of a document that is created using excel vba. I save the contents of the textbox to a text file. I can then email the text file to a recipient and they can open it with notepad. The problem I am having is that when I save teh contents of the textbox to a textfile the string is saved with quotation marks (") before and after the string. I tried saving textbox.value and textbox.text but I get the same result. Is it posible to save this information so that it does not contain the quotation marks around the content? Do I need to create my text file with a shell call to notepad instead of Open file for Output?

Sorry, guess I did not stay at it long enough - problem solved.

callen2468
05-29-2009, 06:17 AM
If anyone wants to know - I created a text file using a scriptiing object.