Question about Microsoft Business & Productivity Software

1 Answer

VBA find and replace using if-else statement

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?

Best,
Anand

Posted by on

1 Answer

Jhtdcfkhgj hh jh vjhv


Posted on Aug 22, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

SysTools VBA Password Remover serial


If you want to remove the VBA password from Excel, Access, Word, PowerPoint and Outlook etc with the help of VBA Password Remover Software rapidly.
http://www.vbapasswordremover.net/
http://www.systoolsgroup.com/vba-password-remover.html
http://www.vbapasswordremover.com/
http://www.vbapasswordremover.org/

May 25, 2011 | Excel-Tool Excel Tool VBA Password...

1 Answer

VBA and macros


To understand VBA, you download HERE and read it.

Jun 22, 2009 | Microsoft OFFICE 2003 BASIC OEM ENGLISH MS...

1 Answer

In Excel trying to compare two ranges


I imagine that the only way is with VBA coding. This is possible if you know programming in Excel (VBA - Visual Basic for Applications).

Apr 17, 2009 | Oracle Database Enterprise Named User Plus

1 Answer

CODES for entering an I.D number using vba


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.

Mar 22, 2009 | Microsoft Office Excel 2003 for PC

5 Answers

Is it possible to use a variable expression in VBA for a form label?


    • hi,,
    •  u could find the link.. for label name..
    • www.functionx.com/​vbaccess/​Lesson09.htm
    •  
        thank u sir..

Sep 12, 2008 | Business & Productivity Software

1 Answer

Excel


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:

http://www.automateexcel.com/index.php/2004/08/14/excel_vba_macro_to_autofill

Jun 11, 2008 | Microsoft Excel for PC

1 Answer

Office 2007 Standard - VBA not working


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!

Apr 03, 2008 | Microsoft Office Standard for PC

1 Answer

VBA Password


Can you read the code at all?

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.

Good luck.

Mar 26, 2008 | Microsoft Excel for PC

1 Answer

Writing macros


Anirbanmj

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.

Feb 02, 2008 | Business & Productivity Software

3 Answers

Excel vba password recovery


You can but you will need software. Search for google for VBA password recovery tools. Search for the appropriate crack you have it all . .

Dec 30, 2007 | Microsoft Excel for PC

Not finding what you are looking for?
Business & Productivity Software Logo

Related Topics:

469 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18304 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...