Geek Answers Handbook

Is there a difference in VBA versions between Office 2003 and 2007?

Can I use VBA Access 2007 links with impunity (in particular, regarding the base language and old COM interfaces) to develop VBA solutions for 2003 access?

Or is there a new or modified syntax added to the language that I should be aware of?

Has the object model in office 2007 been significantly improved?

Any other reservations?

Thanks.

+5
source share
3 answers

The VBA language itself has not been changed between recent versions of Microsoft Office (and probably it will not change in the future either). Access2000 VBA and later VBA6.

Office . Microsoft OM . , , :

, VBA, Office, . , . - . , , - .

+8

Excel 2007 , .

Excel 2003 Excel 2007

Excel 2003 , Excel 2007.

4 .

  • "Chart.Add" Excel 2007, 1

  • reset , Err.clear , .

            On Error Resume Next
        Intruction_That_Could_be_buggy_1
        if Err.Number <>0 Then
             Err.Clear     '  <<<<==== This command is necessary
             Intruction_That_Could_be_buggy_2                  
             if Err.Number <>0 Then
                   ....

  • (...). (xlFormulas) , ,

        Application.displayalerts = False
    Range(....).Paste(xlFormulas)
    Application.displayalerts = True

  • , Alt + N, Excel 2007. Application.Onkey( "% n", "rotina" ) . ALT + Letra. . .

+2

If you are compiling your accdb / mdb file in accde / mde, you want you to compile them in the same version as your main application. I had problems using Access 2003 MDE with Access 2007 (and obviously vice versa).

0
source

More articles:


All Articles