Question about Microsoft Office Standard for PC

1 Answer

VBA not working in all Office products

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.

Posted by on

  • 1 more comment 
  • trevor533 Jan 05, 2009

    Thank you for the reply. I have changed settings in the Trust Center and VBA will still not work. In Excell I get an 'Out of memory' error and it the other Office applications nothing happens.


  • trevor533 Jan 05, 2009

    I have done all that in Excel and still get the 'Out of memory' error. No luck so far.


  • trevor533 Jan 05, 2009

    Well, I have added all the addons but no luck yet. I have installed office at least 5 times so far and that has not made any difference.


×

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that hasĀ over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 19 Answers

There is setting for VBA in office 2007.
Go to Excel options-->Trust center--> trust center setting and configure the required settings

Posted on Jan 05, 2009

  • smartmind_25 Jan 05, 2009

    Check space on active partition and in Macro setting Enable Macros and access to VBA application and Add location in trusted location;

    You have to configure it for other office applications also it will not work automatically for others

  • smartmind_25 Jan 05, 2009

    ok just check whether all add-ins are configured properly in tools menu and other settingd else try reinstalling office with full option or select all options from custom menu I guess this error is because of add-ins

×

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Does office standard 2007 support VBA?


Yes it does, all versions of office 2007 supports VBA.

Oct 05, 2010 | Microsoft Office Standard for PC

1 Answer

How to dov VBA in ms office 2007


Right Click on the sheet name on the bottom left corner of the excel window and on the pop up menu, click on "View Code". It will open a box where you can perform VBA Coding.

Aug 04, 2009 | Microsoft MS OFFICE 2007 SBE MLK (NA) SW....

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

Excel vba


For complete guide please refer to this link
http://www.fontstuff.com/VBA/vbatut03.htm

Thanks and regards

Fixya is educating to educate

May 12, 2009 | Microsoft Office Professional Edition 2003...

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

1 Answer

How to make macro using the VBA


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.

Feb 23, 2009 | Microsoft Office Professional 2007 Full...

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

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?
Microsoft Office Standard for PC Logo

162 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...