Office Drops VB Macros

Jump to First Reply
Posted:
in Mac Software edited January 2014
Read about it here:



http://www.macworld.com/2006/12/opin...soft/index.php



Here's a chance for me to display my technical incompetence. Anyone here a programmer?



Since Visual Basic is difficult to support, and MS wants to make a Universal Application, why not do the following? Write a translator for the macros, to make and execute an Apple Script to do the same thing? Sure, it wouldn't be a native macro, but everything else in Office would be native. I'm fairly sure a macro translator would not slow things down.



Comments

  • Reply 1 of 2
    Marvinmarvin Posts: 15,585moderator
    Quote:
    Originally Posted by snoopy


    Since Visual Basic is difficult to support, and MS wants to make a Universal Application, why not do the following? Write a translator for the macros, to make and execute an Apple Script to do the same thing? Sure, it wouldn't be a native macro, but everything else in Office would be native. I'm fairly sure a macro translator would not slow things down.



    I don't know about the requirements inside the program but Visual Basic is generally more powerful and probably faster than Applescript. Ideally what they would do is scrap both of them and use a standard cross-platform scripting language like Python, Perl or Ruby.
     0Likes 0Dislikes 0Informatives
  • Reply 2 of 2
    snoopysnoopy Posts: 1,901member
    Quote:
    Originally Posted by Marvin




    I don't know about the requirements inside the program but Visual Basic is generally more powerful and probably faster than Applescript.




    Yes, Visual Basic is a programming language so it is more powerful. However, I think it is only used to write macros in Office. In that case any scripting language should be able to do 99 percent of these tasks. I think the question would be whether a translator could be made to convert VB macros to Apple Script macros. Off hand, I see no reason it couldn't.



    Now ideally, if Office takes plug-ins, someone could write a plug-in to do this task and we don't need to rely on MS to do it. I don't use Office, so I don't know the answer.





    Quote:



    Ideally what they would do is scrap both of them and use a standard cross-platform scripting language like Python, Perl or Ruby.




    The earth's core will be frozen by the time that happens.



     0Likes 0Dislikes 0Informatives
Sign In or Register to comment.