Results 1 to 6 of 6
  1. #1
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Some questions for my education (MS-Office All)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Loungers

    OK say what you want, but I always had the itch to get the answers these questions so take a stab at any or all:

    1) Other than ALT+F11 and the Tools | Macro | VBE menu option, are there other ways to start the Visual Basic Editor in any of MS-Office's applications?

    2) Are the old WordBasic, AccessBasic and Excel's Macro Language [XLM] dead with MS-office 2003?

    3) Is VBA still in Office for the Mac? What was the last version that had VBA?

    4) Does other competing Office products, such as Star Office and Open Office, have VBA, or something similar to VBA?

    5) Where can VBA code live? modules, Buttons, menu items, Userforms, ...

    OK this is a bit for my set of questions, lets see how many people I annoy with these.

    <img src=/S/bow.gif border=0 alt=bow width=15 height=15> <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30> <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16> <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23> I guess I can go on and on...

    Cheers

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Some questions for my education (MS-Office All)

    1) You can add a button to a toolbar to start the Visual Basic Editor:
    - Select Tools | Customize...
    - Activate the Commands tab.
    - Select Tools in the list of Categories on the left.
    - Locate the Visual Basic Editor button in the list of Commands on the right.
    - Drag this button to a convenient location on a toolbar. (I have placed it to the left of the Help button)
    - Close the Customize dialog.

    2) WordBasic and the Excel 4 Macro language are still available in Office 2003
    In Word, use the WordBasic object, e.g.

    WordBasic.DisableAutoMacros 1

    In Excel, use ExecuteExcel4Macro with the macro command as a string, for example

    MsgBox ExecuteExcel4Macro("GET.CELL(42)")

    You must download the help files and install them, they are not included in the Office 2003 installation:
    Word 95 WordBasic Help File
    Running Excel 4.0 Macros

    3) Yes, in all versions up to now., but it won't be supported any more in Office 2008 for the Macintosh - see Developer Center.

    4) Open Office has Open Office Basic, which resembles VBA.

    5) VBA lives in modules, which can be
    - Standard modules, created by Insert | Module
    - Class modules, created by Insert | Class Module
    - UserForm modules, automatically created with each UserForm
    - Sheet modules, available for each sheet.
    - The workbook module (ThisWorkbook), available for each workbook.

  3. #3
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Some questions for my education (MS-Office All

    > 4) Does other competing Office products, such as Star Office and Open Office, have VBA, or something similar to VBA?

    By the way, Star Office is a branded and slightly modified version of OpenOffice.

    If you want to move beyond facts to speculation, perhaps you could add this to your list: Will the next version of Office (2009?) continue to run as a stand-alone application or only as an ActiveX control inside Internet Explorer?

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Some questions for my education (MS-Office All)

    1. In Excel you can also right-click a worksheet tab and choose View Code or do the same with the Excel icon on the left of the main menu bar.
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Some questions for my education (MS-Office All)

    You can even type the name of a sub in the name box and push enter to take you there...
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Some questions for my education (MS-Office All)

    1: see other msg
    2: XLM is still available in Excel 2007, you can insert a macro sheet and use it.
    3: IIRC Office 2007 for MAC has no VBA
    4: Yes, openoffice has BASIC, but no object model help and no intellisense. It is a disaster to work with as far as I'm concerned. The lack of help makes the learning curve tremendously steep.
    5: In the VBA project of a workbook asa far as Excel goes. The code BELONGING to a specific object goes in a specific place, depending on what object you have. E.g. event code goes in Thisworkbook and sheet modules and in modules behind userforms (and inclass modules if you know how to use them). Of course there is much more than just this...
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •