 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / January 2007VBA in Office 2008 for Mac?
Does any one know if VBA will still be supported in the upcoming new versions of Office"? Yes, we know. It WILL NOT be supported in Office 2008 for Macintosh.  SignatureBob Greenblatt [MVP] bobgreenblattATmsnDOTcom > Does any one know if VBA will still be supported in the upcoming new > versions of Office"? That is really bad news. I have a big investment in VBA code for Excel. Are you aware of what the options are for programming in the context of Excel? And how can the VBA code be recycled? Thanks, Jim > Yes, we know. It WILL NOT be supported in Office 2008 for Macintosh. > [quoted text clipped - 4 lines] > > Does any one know if VBA will still be supported in the upcoming new > > versions of Office"? > Are you aware of what the options are for programming in the context of > Excel? And how can the VBA code be recycled? AppleScript or RealBasic will be supported. Other options may be if they can access the XL object model via OLE. Not sure what you mean by "recycled". Note that VBA is being deprecated on the WinOffice side, too, though it will be around longer. > Not sure what you mean by "recycled". I just mean translating old code into whatever is needed to work with Excel. > Not sure what you mean by "recycled". I just mean translating old code into whatever is needed to work with Excel. > > Not sure what you mean by "recycled". > > I just mean translating old code into whatever is needed to work with > Excel. Paul Berkowitz has written a guide for MacTech magazine, "Moving from Microsoft Office VBA to Applescript". A preliminary draft was available at MacWorld. It will be published in MacTech later this year. It gives lots of examples of how to translate VBA to Applescript But the bottom line will be hand-coding. BTW - there's a promotion on MacTech's site (mactech.com) sponsored by MS that will give you a 6-month subscription to MacTech for $9.95. thanks for the info. The migration path is to use Applescript instead of VBA. I think Applescript is already integrated with Excel. See: http://www.microsoft.com/mac/resources/resources.aspx?pid=fordevelopers I really need something that will work on both PCs and Macs. That seems to be the hard thing about solving the problem. On Jan 26, 11:58 pm, "gimme_this_gimme_t...@yahoo.com" <gimme_this_gimme_t...@yahoo.com> wrote: > The migration path is to use Applescript instead of VBA. > > I think Applescript is already integrated with Excel. See: > > http://www.microsoft.com/mac/resources/resources.aspx?pid=fordevelopers On 1/29/07 7:48 AM, in article 1170074923.598695.184210@v45g2000cwv.googlegroups.com, "Jim" <jvbeaupre@knology.net> wrote: > I really need something that will work on both PCs and Macs. That > seems to be the hard thing about solving the problem. [quoted text clipped - 6 lines] >> >> http://www.microsoft.com/mac/resources/resources.aspx?pid=fordevelopers The old XLM macro language WILL be supported in Excel 2008 and it WILL also work cross platform on Windows PCs. SignatureBob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.