Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Dec 2000
    Location
    Massachusetts, USA
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access 2007 (New Release)

    Does anyone know if Office 2007 and Access 2007 will include VBA programming?

    I have read reports that it will no longer be supported and am wondering if it will be included when Office/Access 2007 is released.

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

    Re: Access 2007 (New Release)

    Yes, but it depends on the file format. Office 2007 documents can come in several formats
    1. <LI>The old .doc, .xls etc.
      <LI>A new XML format .docm, .xlsm etc.
      <LI>A new XML format .docx, .xlsx etc.
    1. and 2. will support VBA code, 3. won't.

  3. #3
    New Lounger
    Join Date
    Dec 2000
    Location
    Massachusetts, USA
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 2007 (New Release)

    Hans,

    Thank you. I should have also asked this question.

    Will I still be able to develop VBA modules in Access 2007 as I am currently doing in Access 2003 which interact with Forms,
    Reports, etc?

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

    Re: Access 2007 (New Release)

    I don't know how this will work in the new XML format, but Access 2007 will still support the .mdb format, and I assume VBA will work there much as it does in older versions, i.e. you can create event procedures in the module associated with a form or report, etc.

  5. #5
    4 Star Lounger
    Join Date
    Sep 2004
    Location
    Sacramento, California, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 2007 (New Release)

    I just recently saw a Microsoft presentation of Office 2007. Here is a quote from the Microsoft product update download:

    Individuals with more development and programming skills can enhance an Office Access 2007 application with macros or Microsoft Visual Basic

Posting Permissions

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