Office Macros

What is the latest about when we will be able to upgrade our Office
for Mac so that it can run all of our spreadsheets with VB macros?

-- 
"In no part of the constitution is more wisdom to be found,
than in the clause which confides the question of war or peace 
to the legislature, and not to the executive department." 

- James Madison
0
howard4064 (121)
10/19/2009 6:25:51 PM
mac.office 7017 articles. 0 followers. Follow

6 Replies
1504 Views

Similar Articles

[PageSpeed] 7

The only official word from Microsoft is that VBA will return in the next 
release of Mac Office which is tentatively scheduled for "Holidays 2010" - I 
take that to mean late 4th quarter of next year. I would not expect to see 
anything more definite on a release date before early in that same time 
frame.

-- 
Regards |:>)
Bob Jones
[MVP] Office:Mac

"Howard Brazee" <howard@brazee.net> wrote in message 
news:inbpd51heb2u0kdpbbftmnhmsqenat3i2a@4ax.com...
> What is the latest about when we will be able to upgrade our Office
> for Mac so that it can run all of our spreadsheets with VB macros?
>
> -- 
> "In no part of the constitution is more wisdom to be found,
> than in the clause which confides the question of war or peace
> to the legislature, and not to the executive department."
>
> - James Madison 

0
10/19/2009 6:52:35 PM
CyberTaz wrote:
> The only official word from Microsoft is that VBA will return in the 
> next release of Mac Office which is tentatively scheduled for "Holidays 
> 2010" - I take that to mean late 4th quarter of next year. I would not 
> expect to see anything more definite on a release date before early in 
> that same time frame.
> 

Indeed.  However any implementation of VBA on the OSX side will be 
spotty at best.
Not something I would want to rely on.
There has to be a better option for macros.
0
justin9659 (30)
10/20/2009 7:34:55 PM
Justin wrote:
> CyberTaz wrote:
>> The only official word from Microsoft is that VBA will return in the 
>> next release of Mac Office which is tentatively scheduled for 
>> "Holidays 2010" - I take that to mean late 4th quarter of next year. I 
>> would not expect to see anything more definite on a release date 
>> before early in that same time frame.
>>
> 
> Indeed.  However any implementation of VBA on the OSX side will be 
> spotty at best.
> Not something I would want to rely on.
> There has to be a better option for macros.

I'm willing to wait and see what Microsoft does about VBA. A slightly 
modified VBA version 5 was in 2004.

-Jim

-- 
Jim Gordon
Mac MVP
Co-author of Office 2008 for Mac All-in-One For Dummies
http://tinyurl.com/Office-2008-for-Dummies
0
goldkey74 (611)
10/21/2009 5:29:30 AM
On 10/20/09 3:34 PM, in article ugMvnxbUKHA.3720@TK2MSFTNGP02.phx.gbl,
"Justin" <justin@nobecauseihatespam.com> wrote:

> CyberTaz wrote:
>> The only official word from Microsoft is that VBA will return in the
>> next release of Mac Office which is tentatively scheduled for "Holidays
>> 2010" - I take that to mean late 4th quarter of next year. I would not
>> expect to see anything more definite on a release date before early in
>> that same time frame.
>> 
> 
> Indeed.  However any implementation of VBA on the OSX side will be
> spotty at best.
> Not something I would want to rely on.
> There has to be a better option for macros.
How can you possibly know that "any implementation of VBA on the OSX side
will be spotty at best"?

I don't know about you, but I make my living developing VBA soutiions, and I
am certainly planning on relying completely on the VBA implementation in the
next version of Office. And, I think you should too; particularly as there
is absolutely no evidence to the contrary.

If there is a better option, I'd like to hear about it. You sound like you
know of one. What is it?

-- 
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

0
bob6686 (387)
10/21/2009 11:54:10 AM
On Wed, 21 Oct 2009 01:29:30 -0400, Jim Gordon MVP
<goldkey74@warmerthanwarmmail.com> wrote:

>> Indeed.  However any implementation of VBA on the OSX side will be 
>> spotty at best.
>> Not something I would want to rely on.
>> There has to be a better option for macros.
>
>I'm willing to wait and see what Microsoft does about VBA. A slightly 
>modified VBA version 5 was in 2004.

The delay corresponded with a big security push - I wonder if there
could be a basic redesign of the underpinnings.

-- 
"In no part of the constitution is more wisdom to be found,
than in the clause which confides the question of war or peace 
to the legislature, and not to the executive department." 

- James Madison
0
howard4064 (121)
10/21/2009 3:43:27 PM
Howard Brazee wrote:
> On Wed, 21 Oct 2009 01:29:30 -0400, Jim Gordon MVP
> <goldkey74@warmerthanwarmmail.com> wrote:
> 
>>> Indeed.  However any implementation of VBA on the OSX side will be 
>>> spotty at best.
>>> Not something I would want to rely on.
>>> There has to be a better option for macros.
>> I'm willing to wait and see what Microsoft does about VBA. A slightly 
>> modified VBA version 5 was in 2004.
> 
> The delay corresponded with a big security push - I wonder if there
> could be a basic redesign of the underpinnings.
> 

The underpinnings (the VBA compiler for Mac Intel processors) is being 
built from scratch. It's a complete redesign!

-Jim

-- 
Jim Gordon
Mac MVP
Co-author of Office 2008 for Mac All-in-One For Dummies
http://tinyurl.com/Office-2008-for-Dummies
0
goldkey74 (611)
10/22/2009 1:00:01 AM
Reply:

Similar Artilces:

Macro or Function to make text size to suite text Length?
I would like to find Macro or Function that will make text size to suite text Length? eg. if the first cell has "bill smith" then the text size would be 10. But if you had "Christina Vandermear" then the text size would be as small as 7 in order to fit in that same size cell. I know it's a bit of an odd request, but is there a way to do that? thanks Hi only possible with VBA. You may download the following addin for this extension of the conditional format (as Excel's build in format can't change the font size): http://www.xldynamic.com/source/xld.CF...

Using 2 versions of Mac Office 2004 (Japanese and English). How do I set the default for which version my machine uses to open office files?
I using 2 versions of Mac Office 2004 (Japanese and English). How do I set the default for which version my machine uses to open office files? It would of course be better if MS allowed users to switch menu languages within the program just as Mac does with its OS and associated software. But since that is not the case, I have had to purchase install the English version of Office 2004 (at great expense both monetarily and memory wise). When I open files already on my computer it always opens them with the "default" version of Office 2004 which is in Japanese. I can't seem to ...

Out-of-office twin replies
I've seen some posts here with regards to OOO replies generating two replies, one of which is blank. This is happening on at least two different versions of Outlook and Exchange 5.5/2000 so it appears to be a server side problem. Does anyone have a solution to this? ...

Importing Data
Hello, I have a series of excel documents being sent to me over a period of time, and I would like to import this information into one sheet automatically. The documents being sent to me are all identically designed, so importing is no problem. Here is an example of what I am receiving: ALPHA 1 0 0 1 1 BETA 2 1 0 1 0 OMEGA 0 0 1 0 2 Each line represents a single excel doc I get back. ALPHA, BETA, etc are the names of the people who sent it in. The filenames are always ALPHA_01_01_2006.xls or BETA_02_04_2006.xls, etc. What I would like to do is create a MASTER sheet that contains a...

Vista
I have just purchased a PC with Windows Vista already installed, and have installed Microsoft Office 2003 on it & registered it. However, whenever I launch Excl I am confronted with a screen showing a Microsoft Office End Users Licence Agreement which requires me to agree to each time before the programme will launch. Does anyone know how to stop this happening? You registered but did you activate? Gord Dibben MS Excel MVP On Thu, 6 Dec 2007 22:55:54 -0000, "Gunga" <scohen@btinternet.com> wrote: >I have just purchased a PC with Windows Vista already installe...

Run a Macro after a cell changed due to a calculation
I'm sorry but i posted this already in programming. Yet i noticed the remark that it would be better to post it here. As it isn't the most simple question around. Goodday, I tried to use the worksheet change functions, yet they only seem to act when you actively enter into a certain cell. However i need to call a certain macro when the output in a certain cell changes due to the change in the specific if function. Therefore without user intervention. Is there any way to do this? Kind regards, Ivo Geijsen --- Message posted from http://www.ExcelForum.com/ Take a look at the w...

cell reference changes after macro runs
I have two workbooks with simple identical formulas that update control number after the macro runs. One workbook is ok. The other wil not update the control number. Instead, it changes the cell referenc to one row higher and returns the previous control number. Here's wha each workbook looks like: Sheet one: cell C7 is the control number:20040004.formula for C7 i :=sheet2!'B5+1' Macro: Insert new row 5 on sheet 2,cut data from sheet 1 row 7, past into sheet 2 row 5. After the macro runs, the cell ref. on sheet 1, C7 changes to =B6+1. tried adding $ around $B5$+1, locking cel...

Office Macros
What is the latest about when we will be able to upgrade our Office for Mac so that it can run all of our spreadsheets with VB macros? -- "In no part of the constitution is more wisdom to be found, than in the clause which confides the question of war or peace to the legislature, and not to the executive department." - James Madison The only official word from Microsoft is that VBA will return in the next release of Mac Office which is tentatively scheduled for "Holidays 2010" - I take that to mean late 4th quarter of next year. I would not expect to see anything m...

Office 2007
I have Office 2007 installed on an WinXP machine. I've added to my start menu the following short-cuts: New Microsoft Office Document Open Microsoft Office Document I have a few questions, 1. What is the default location of the files listed in the New Microsoft Office Document window? 2. Can I add tabs to the New Microsofot Office Document window? If so, how? 3. What is the default location for the Open Microsoft Office Document window? Assume I've made no changes to the install of Office 2007. Your assistance and help is greatly appreciated! (B^>)-]=[ ...

Send Exchange 2003 Out of Office Replies to non Exchange mail serv
Hi, I am new here, so please bear with me. I am hoping someone can help me. I have looked and looked and looked for the answer to my question with no luck. I am wondering if it is possible to setup Exchange 2003 Out of Office replies to respond to a non-Exchange mail server within the same domain without opening up to the internet. The reasoning is to prevent spam programs from detecting legit addresses. Main Mail Server for Staff & Faculty: Exchange 2003 Enterprise Edition Main Mail Server for Students: SurgeMail from NetWinSite.com They are in the same domain, but I am wanti...

Force users to enable macros on a protected workbook?
Hello! I found this code for ensuring that users always enable macros, but I have a few questions about it: http://www.vbaexpress.com/kb/getarticle.php?kb_id=379 a) What would needed to be added to the code to make it work on a protected workbook? b) Does the code need some kind of error handling? (For my workbooks, there is a "Print" button on each sheet that when you push it, autofits the rows, pops up the spell checker, compares a few cells to make sure there are no duplicates, end dates don't come before start dates, etc. So without macros being always ...

Run a macro that applies to any selected row
I want to be able to start a macro and have it do some copy/past functions on the cells in the specific row that I am in when the macr is started. In other words, lets say I move down Col A and stop in ro A23, I want the macro to do some copy/paste in that specific row. If decided to stop in A45, I want to do the same copy/paste functions i the same columns relative to the selected row. Can I do this with single macro? I'm still learning..but who isn't. Thanks in advance...Gre -- Message posted from http://www.ExcelForum.com The keyword here is activecell. You didn't say i...

Categories disappeared after upgrade from Office 2k3 to 2k7??
After upgrading from Office 2003 to Office 2007 all of my categories are gone. I still have a complete backup of my system containing Office 2k3 with working categories, is there a way to manually transfer the Categories to Office 2k7? Any help in this area would be completely appreciated. Thx NewsReader2k;115976 Wrote: > After upgrading from Office 2003 to Office 2007 all of my categories > are > gone. > > I still have a complete backup of my system containing Office 2k3 with > working categories, is there a way to manually transfer the Catego...

How do I change the data set on the X axis? (office 2003)
OK, so I created a frequency histogram (bar chart) by selecting the values for the Y-axis, but I can't figure out how to change the values on the X-axis to fit the rest of my values.... When I make the graph using both sets of data, it gives me two separate bar charts on the same plane. Help please :) Thanks Remove the text in the top cell over the x-values; now make the chart. Excel thinks you have two data series best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "jrexattack" <jrexattack@discussions.microsoft.com&...

Opening/importing data from database takes forever after upgrading office!
Hello. I recently reinstalled a users computer and upgraded his office version from 2000 to xp. Now when he imports data from a database it takes forever. It can take several minutes and before the reinstallation the operation only took seconds. What could be wrong? I did the same on his coworkers computer with the same result so there must be something that can solve the problem. I just can't figure it out. The run windows 2000 sp4. Please help. :^) //Johan Anyone? It never hurts to empty the windows temp folder (with excel closed), but it may not help. You may want to take...

office 2003 eula comes up each time you open word,excel
...

Re-installation of office
I need to re-install office on my pc after resetting the pc to the original settings. HELP! Insert Office cd, install. Dont have cd? ....explain "Lisa Lucey" <Lisa Lucey@discussions.microsoft.com> wrote in message news:D935368F-BFC7-4C04-96BA-FEAFABC6E358@microsoft.com... >I need to re-install office on my pc after resetting the pc to the original > settings. HELP! ...

Office 12.2.1 update/Reentering Product Key
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I attempted to update my Microsoft Office 2008 from 12.2.0 to 12.2.1 today; however, after the installation was complete, when I went to open a Microsoft Office application, an error message appeared stating: "Office for Mac has determined that your product key is not valid. To use Office for Mac, you must enter a valid product key" and refers me to this link: <http://www.microsoft.com/mac/help.mspx?MODE=pv&CTT=PageView&clr=99-0-0&target=f2d51b70-f7d6-4a3c-ae8b-b90597d7530e1033> After deleti...

Office 2003 and mac office
I have a workbook with some macros and such that i made on my XP computer. I sent it to a friend of mine to use, but he has a mac. The macro i made to sort runs into a problem when he runs it, however when he sent me the workbook and i ran the macor it worked fine. It had a 1004 runtime error. Is this a common problem due to it being made on a pc and ran on a mac? what changes need to be made to make it work on a mac? Selection.Sort Key1:=Range("IA3"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ Da...

Can I update from Office 98 to Office X
Can I update from Office 98 to Office X for mac? I should of said upgrade from Office 98 to Office X for mac? > From: Aggregates & Roadbuilding Magazine <rock@sympatico.ca> > Newsgroups: microsoft.public.mac.office > Date: Wed, 14 Jan 2004 14:37:48 -0500 > Subject: Can I update from Office 98 to Office X > > Can I update from Office 98 to Office X for mac? > According to the Mactopia site: You can upgrade to Office v. X for Mac if you already own any of the following products: Office�98 Macintosh Edition Entourage�2001 Special Edition <http://www.micr...

Macro to extend a pivot table range
Evening all! I have a worksheet that uses an ODBC link to create a table. The table gets longer each time it's refreshed, but it's width stays the same. I also have a pivot table based on this worksheet. What I need is a macro that updates my pivot table to include the extended range of the table. I've tried naming the input range, then using a macro to update the extent of the range and using that to update the pivot, but it never works. If I look at the new range, the "refers to" panel always says =TRUE - which is meaningless to me! What I need is a routine that up...

office xp
I have a soccer club database that weas created using access xp and I need to be able to run it on my home computer that uses office 2000. Certain parts of the database such as the listing of teams will not work. please adivse When you switch between database versions many times the new computer does not have the appropriate references set or is missing references it needs in order to run. Assuming you can open the database on your machine with Access 2000, you need to open the database and open the code editor window. Select Debug | Compile. Generally, a 2002 database won't run u...

Upgrade to Power Point 2010 from Microsoft Office 2008
How can I upgrade from Power Point in Microsoft Office 2008 for Mac to Power Point 2010? unfortunately the Beta version is only available on windows platforms. Preliminary system requirements for Office 2010 include the following: • Windows XP SP3, Windows Vista or Windows 7 check out: http://www.microsoft.com/office/2010/en/faqs/default.aspx#29q Emma Bannister PowerPoint Specialist www.presentationstudio.com "4jswest" <4jswest@discussions.microsoft.com> wrote in message news:15B53B5E-1A57-4E46-8CBA-5A7BDD9D71C7@microsoft.com... > How can I upgrade fr...

Restrict view & edit of macro code
Hi, Suppose we have a few macros in a particular workbook. How can we protect the macros such that viewing and edit of the macro code is restricted ???? The solution could be either via code or just some settings. Your help for the above is appreciated. Thank You. Regards, Giri Tools/VBAEditor Properties. Set a password. --- Message posted from http://www.ExcelForum.com/ ...

How can I get Dictionaries for Office XP?
I find vague references online to to an "Office XP Proofing tools" but the online stores seem to have no references to it - only Office 2003 Proofing tools. Is that compatible with Office XP? If not, where can I find proofing tools for XP. Or alternatively, where can I get dictionaries and grammar checkers for individual languages for Office XP. No, they are not compatible. If you can still find Office 2003 Proofing Tools online, then I would advise upgrading to Office 2003 so you could use Office 2003 Proofing Tools. You have very little chance of finding Office XP...