fivestarsw Posted February 21, 2008 Report Share Posted February 21, 2008 My macro copies cells and fills out a form. One of the cells contain html text and I want to put it into the field and excel always puts quotes (") around the text. How do I get rid of the quotes around the text when posting during the macro? Quote Link to comment Share on other sites More sharing options...
Cory Posted February 22, 2008 Report Share Posted February 22, 2008 Modify String Variables > Replace Substring and replace all instances of the quote mark with nothing is how I usually do it. <TMVAR2:21:01:01:000:000:"> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.