InputBox - If input has &, change & to ^&

**heather1209** · 08-09-2012, 08:27 PM

Hello everyone,

I've got something that may or may not be easy, I just don't know how to even begin attempting the code. I'm making an Excel spreadsheet that makes a batch file for a user based on dropdown boxes. Long story short, some dropdown boxes give the option to open specific websites in a new browser window. These websites allow login credentials in the URL so I have the macro asking for the username and password and then it puts the information in the URL, which it then puts into the batch file.
The problem: Batch files and & signs don't get along, at least with what I need to do. I can put a ^ symbol in front of the & symbols in the URLs that I can see to fix them, however if a user has a password with an & symbol, that will cause the batch file to ignore that part of the website.

The solution (at least the only one I can think of based on my research): Somehow make Excel substitute any & signs in a user's input in an inputbox with ^& before it prints it to the batch file.

Is this possible? If so, how do I do it?

**FDibbins** · 08-09-2012, 08:39 PM

have a look at using the =substitute() function, and see if that will give you what you need?

**heather1209** · 08-09-2012, 08:54 PM

Will that work for an inputbox in a macro?

---------- Post added at 08:54 PM ---------- Previous post was at 08:50 PM ----------

Just did it with WorksheetFunction. It worked!!