Excel 2008 has no Macros? Or just no VBA?? - microsoft.public.mac.office.excel

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I am considering buying Office 2008 for Mac. I have heard about the lack of VBA but I am confused if this means there are no macros at all in Excel? In my work I have to access certain spreadsheets created by others on PC which include many macros. Will I be able to use these or not?

> This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --B_3342032225_7579199 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit Then stay with the old version then. No need to upgrade if it lacks the features you desire. On 11/25/09 6:43 PM, in article 59bad9df.-1@webcrossing.JaKIaxP2ac0, "Doctor.Generosity@officeformac.com" <Doctor.Generosity@officeformac.com> wrote: > Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel > I am considering buying Office 2008 for Mac. I have heard about the lack of > VBA but I am confused if this means there are no macros at all in Excel? > > In my work I have to access certain spreadsheets created by others on PC which > include many macros. Will I be able to use these or not? -- Are there errors in the Bible? Do Animals go to Heaven? Is drinking Alcohol a sin? Is the KJV the only translation to be used? If you want to learn, get answers, and be able to defend the faith, CERM is your place. http://www.cerm.info/ --B_3342032225_7579199 Content-type: text/html; charset="US-ASCII" Content-transfer-encoding: quoted-printable <HTML> <HEAD> <TITLE>Re: Excel 2008 has no Macros? Or just no VBA??</TITLE> </HEAD> <BODY> Then = stay with the old version then. No need to upgrade if it lacks the features = you desire. On 11/25/09 6:43 PM, in article 59bad9df.-1@webcrossing.JaKIaxP2ac0, "= Doctor.Generosity@officeformac.com" <Doctor.Generosity@officeformac.= com> wrote: <BLOCKQUOTE>Version: 2008 Operating System: Mac OS X 10.6 (Snow Leo= pard) Processor: Intel I am considering buying Office 2008 for Mac. I have h= eard about the lack of VBA but I am confused if this means there are no macr= os at all in Excel? In my work I have to access certain spreadsheets created by others on PC wh= ich include many macros. Will I be able to use these or not? </BLOCKQUOTE> -- Are there errors in the Bible? Do Animals go to Heaven? Is drinking Alcohol= a sin? Is the KJV the only translation to be used? If you want to learn, ge= t answers, and be able to defend the faith, CERM is your place. <a href=3D"http://www.cerm.info/">http://www.cerm.info/</a> </BODY> </HTML> --B_3342032225_7579199--

Doctor.Generosity@officeformac.com wrote: > Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: > Intel I am considering buying Office 2008 for Mac. I have heard about > the lack of VBA but I am confused if this means there are no macros at > all in Excel? > > In my work I have to access certain spreadsheets created by others on PC > which include many macros. Will I be able to use these or not? There is no Visual Basic For Applications (VBA) in Office 2008. VBA based macros can not be made, edited or used in Office 2008. Add-ins can not be used. There is an old Excel version 4 macro language that is still supported, but few are old enough to be aware of its existence, much less take advantage of it. Spreadsheets that use VBA macros, which is probably what you are getting from your PC friends, will not work in Excel 2008. You will not be able to use these. VBA will return in the next major update to Office for Mac. This should happen during 2010 (most likely near the end of 2010). The new version will have a brand new VBA compiler, which should free Office from Rosetta and might finally make macros run like greased lightning on the Mac (I'm hoping, anyway). Be patient and I think you will find the next Mac Office "the one" to get. -Jim -- Jim Gordon Mac MVP Co-author of Office 2008 for Mac All-in-One For Dummies http://tinyurl.com/Office-2008-for-Dummies

Did you read my question? I asked if Excel 08 would or would not run macros already written in existing spreadsheets. I did not ask if I should buy software I know won't work. Thanks > > Then stay with the old version then. No need to upgrade if it lacks the features you desire. > > > On 11/25/09 6:43 PM, in article 59bad9df.-1@webcrossing.JaKIaxP2ac0, "Doctor.Generosity@officeformac.com" <Doctor.Generosity@officeformac.com> wrote: > > Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I am considering buying Office 2008 for Mac. I have heard about the lack of VBA but I am confused if this means there are no macros at all in Excel? > > In my work I have to access certain spreadsheets created by others on PC which include many macros. Will I be able to use these or not? > > > -- > Are there errors in the Bible? Do Animals go to Heaven? Is drinking Alcohol a sin? Is the KJV the only translation to be used? If you want to learn, get answers, and be able to defend the faith, CERM is your place. > <a href="http://www.cerm.info/">http://www.cerm.info/</a> > > >

Read Jim's answer: it contains the rest of the story :-) Cheers On 27/11/09 10:43 AM, in article 59bad9df.2@webcrossing.JaKIaxP2ac0, "Doctor.Generosity@officeformac.com" <Doctor.Generosity@officeformac.com> wrote: > Did you read my question? I asked if Excel 08 would or would not run macros > already written in existing spreadsheets. I did not ask if I should buy > software I know won't work. > > Thanks > >> >> Then stay with the old version then. No need to upgrade if it lacks the >> features you desire. >> >> >> On 11/25/09 6:43 PM, in article 59bad9df.-1@webcrossing.JaKIaxP2ac0, >> "Doctor.Generosity@officeformac.com" wrote: >> >> Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel >> I am considering buying Office 2008 for Mac. I have heard about the lack of >> VBA but I am confused if this means there are no macros at all in Excel? >> >> In my work I have to access certain spreadsheets created by others on PC >> which include many macros. Will I be able to use these or not? >> >> >> -- >> Are there errors in the Bible? Do Animals go to Heaven? Is drinking Alcohol a >> sin? Is the KJV the only translation to be used? If you want to learn, get >> answers, and be able to defend the faith, CERM is your place. >> http://www.cerm.info/ >> >> >> -- The email below is my business email -- Please do not email me about forum matters unless I ask you to; or unless you intend to pay! John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer, McGhie Information Engineering Pty Ltd Sydney, Australia. | Ph: +61 (0)4 1209 1410 +61 4 1209 1410, mailto:john@mcghie.name

Similiar Articles:

normal.dot file and macros - microsoft.public.word.vba.general ...
... years and had no problem with Macros ... Everything has just been ... time I open an Excel workbook pops up a question to allow macros, or not. Even with files that have no ...

Template- when saved as a new document remove macros - microsoft ...
... incorporated several macros (saved in just the ... opened, if I go into VBA, the macro's ... This document contains macros ... select "View Code" A new ... Excel template has ...

Selecting variable amount of text in Word 2007 macro/VBA ...
... below [with the cursor just ... to print external ... Visual Basic for Applications macro to ... ... In Microsoft Excel 97, when you run a Visual Basic for Applications ...

Word macro running from OL VBA throwing error on Word SaveAs ...
... just fine and runs the macro > >> just fine ... Microsoft Visual Basic for Applications SaveAs ... ... How To Suppress The Macro And Other Dialog In OLE Excel ?

Will Excel 2004 run on SnowLeopard OS X 10.6? - microsoft.public ...
... for automaation and macros. Besides that, my customers use the spreadsheets I develop in Office for PC's. I know Office 2008 has no VBA for Excel ... Actually, I just bought ...

Can typing macros be used in Word? - microsoft.public.word.vba ...
So, I'm just wondering what's a good way to implement these macros using VBA, if at all possible. ... When and why should you use macros? ... Excel macros can be ...

PDF disables Word Macros - microsoft.public.word.vba.general ...
Macro for Calendar - microsoft.public.excel.misc PDF add-in disabled on it ... I put my VBA macros back in Word. Whenever ... public.word ..... the user has set their macro ...

VBA code to run macro in certain file based on name of file in cel ...
... using entries in the same cells and it works just ... Creating VBA Macros to Manipulate Worksheets in Excel 2007... how to write Visual Basic for Applications (VBA) macros ...

Getting Error: Word cannot print. There is no printer installed ...
This has been working perfectly in our Windows 2003 environment. We just switched to Windows 2008 ... public.word.vba ... There is no printer installed ... Excel 2008 ...

array transpose for dynamic data without macros - microsoft.public ...
Just copy n paste the expression direct from ... Change Source Data in VBA - microsoft.public.excel.charting ... array ... array transpose for dynamic data without macros Excel I ...

Excel 2008 has no Macros? Or just no VBA?? Windows 7
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I am considering buying Office 2008 for Mac. I have heard about the lack of VBA but I ...

Excel Blog - Clarification on VBA Support - The Microsoft Office Blog
... accordingly, there is no plan to remove VBA from future versions of Excel. ... it is impossible to imagine Excel without macro ... Just because you have lots of money ...

Excel Macros (VBA) Tutorial
VBA is the programming language used within Excel to develop macros It stands for Visual Basic for Applications ... Labels are just labels. You use them to describe ...

Excel Mac 2008 macros support - MacRumors Forums
Excel Mac 2008 macros support Mac Applications and Mac App Store ... for AppleScript, which takes care of the lack of support for VBA. It should work just ...

Office 2011: the macro is back | Macworld
Office 2004 included support for Visual Basic for Applications (VBA). Office 2008 didn't. ... In my testing so far, Excel 2011 runs older macros just fine. I opened one ...

7/15/2012 11:42:57 AM