Hi, I'm Anand, a beginner in vba programming. I would like to know the code/suggestions, using vba, to replace a particular word in MS Word with another (it should also ask me whether to replace the word or not). I wish to get the code written, or even suggestions, using "if-else" statement. Could you please help with this?
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
Try the help built into Excel and give yourself time to absorb it; Excel has some of the best help in the business. VBA may be more complex than you need to solve a data entry problem. If you're trying to add data input masks in a database, why don't you try Access (the help for which is admittedly weaker because database programming is among the most complex of all productivity apps)? I learned VBA from 3 books I rented from a good public library over the course of a project that was about a month long, (because) at some point Microsoft abandoned the idea of teaching it via help screens. Still, you might join a MS developer site and those are loaded with detailed explanations and many other experts. I hope this helps... I feel your pain.
Egad. Well, first off, I'd suggest splitting the document up if you can. The chances Excel will crash on all those records is pretty good.
Next, you'll need to use VBA I think. Do you know any VBA? I am guessing you probably don't. Anyway, I can't go into it all here, but I'd suggest you snag a local with some VBA skills and then point him or her to this:
There is no indication that VBA should not work in all versions of Excel. There is a new file extension (xlsm), which is used to activate macros and allow usage. If you have, perhaps, opened and saved with incorrect extension (new is xlsx), VBA may be unavailable. Try to resave it with the changed extension. It seems likely that this is the issue (reference http://office.microsoft.com/en-us/excel/HP100141031033.aspx?pid=CH100648071033). Also, if you make sure your Save As option is set at xlsm, this should help to prevent problems. VBA should not be an issue in any version of Excel and custom functions ARE available (see http://office.microsoft.com/en-us/excel/HA102189961033.aspx?pid=CH100645021033). It should be as simple as changing the extension, and I would suggest changing the default save as option. If this helps, please rate "FixYa"! Thanks!
If yes, try copying the code to a new VBA screen and pasting it in.
Do your changes in this screen and save it as a Macro, then delete the original.
Note: I use a blank password on all my protected documents - not real good security, but easy to remember and others don't know that it is to be left blank - so it foils a lot of people. I use the password only to protect the formulas and script from being changed accidentally by the end user - not to prevent anyone from "stealing" my code.
VBA passwords seem to be difficult to crack and the programs to do so seem to be quite expensive for a one time use.
Have you thought of just rewriting the VBA script? Remember, you did it once and went through all the problems of working out the sequence etc so much of this might come back to you and save a lot of time over the original exercise.
Macros for Excel and the rest of the office suite are based on Visual Basic for Applications (VBA) which is a subset of VB programming language.
If your not familier with this language then i would suggest "Googling" VBA Introduction or similar and have a look at some introductory info. If you are ok with VB then you can record doing a task you want to do and then look at the code generated to see what it has created.