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.
Reply With Quote