I think that I have some software conflicts in my system. Office will not start any VBA editor. I have re-installed Office several times. Only Excel gives an Out of Memory error while the others just don't do anything. I don't know enough about HijackThis or how to solve this type of problem so need someone to give advice and guid me through the process of trying to solve this hassle. For example, in Word, I select a Macro and click to edit it. Immediately an error "Microsoft Visual Basic" - Unexpected error;quitting pops up. Click OK and Out of Memory error pops up. I have visual basic 6 installed which works perfectly.
- 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.
You can "record" a macro and look at the code or write one yourself. To see code, you'll need to open the VB Editor using <ALT+F11>. You may also enable the "Developer "tab in the Ribbon using the Options dialog and going to the "Popular" tab. From the Developer tab you can access the VB editor. From this tab you can recod a macro too.
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!
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.