New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

Visual Basic - Microsoft Excel 2008 For Mac - Help!


Post Reply New Thread Subscribe

 
Thread Tools
lovinthemac

 
Member Since: Jan 12, 2010
Posts: 12
lovinthemac is on a distinguished road

lovinthemac is offline
I need to use Visual Basic for Excel, and from what I can tell (and what I have read) Visual Basic is not supported for Excel for Mac...but a new version will support it? I've heard of people using applescript as a substitute. Can somebody please enlighten me? I would hate to have to use Windows just to use Visual Basic on Excel.

--
My Mac: MacBook Intel Core 2 Duo 2.2 GHz 4GB RAM OS X 10.6 (Snow Leopard)
QUOTE Thanks
chscag

 
chscag's Avatar
 
Member Since: Jan 23, 2008
Location: Fort Worth, Texas
Posts: 39,478
chscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond reputechscag has a reputation beyond repute
Mac Specs: 27" iMac i5, 3.2 GHz, iPad 3, iPhone 5c, 3 iPods, OS X Mavericks

chscag is offline
Break out your Windows disk then.... because MS Office 2008 does not support VB (thanks MS), hence, no macros. (MS Office 2004 does support VB.) Yes, you can use Apple script but it's not the same and IMO, does not work well.

The next version of MS Office (2011) should be on the market sometime this Fall. MS promises VB is back along with some other nice additions. We'll just have to wait until then.

Regards.
QUOTE Thanks
toMACsh

 
toMACsh's Avatar
 
Member Since: Jul 30, 2009
Location: Wisconsin
Posts: 5,498
toMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to alltoMACsh is a name known to all
Mac Specs: Mac Mini Core 2 Duo

toMACsh is offline
If you need it sooner, Office 204 does support VBA, but you'd have to find a used copy since it's not sold by MS anymore.
QUOTE Thanks
lovinthemac

 
Member Since: Jan 12, 2010
Posts: 12
lovinthemac is on a distinguished road

lovinthemac is offline
Quote:
Originally Posted by chscag View Post
Break out your Windows disk then.... because MS Office 2008 does not support VB (thanks MS), hence, no macros. (MS Office 2004 does support VB.) Yes, you can use Apple script but it's not the same and IMO, does not work well.

The next version of MS Office (2011) should be on the market sometime this Fall. MS promises VB is back along with some other nice additions. We'll just have to wait until then.

Regards.
Ouch. I just installed office on Windows running through VMWare Fusion. This is painful. MS is doing their best to force Mac users to use Windows for business applications.

--
My Mac: MacBook Intel Core 2 Duo 2.2 GHz 4GB RAM OS X 10.6 (Snow Leopard)
QUOTE Thanks
shades

 
Member Since: May 20, 2004
Posts: 243
shades is a jewel in the roughshades is a jewel in the rough
Mac Specs: iMac 21" 8GB, MBP 15" 2.5 Penryn, 4 GB/180 GB

shades is offline
Also, with Office 2004, it uses VB 5 which is the same as using MS Office 97. Office 2000/2002/2003 on Windows uses VB 6. So as long as whatever is done on the Windows side is compatible with Office 97, then it should work in Mac Office 2004.

Mellel 3, NWP 2, Scrivener 2.3.1, Tinderbox 5.11.2
LibreOffice 3.6, Accordance 10.0, Adobe CS4, DTP 2.4.3
OS X 10.8.2
QUOTE Thanks

Post Reply New Thread Subscribe


« Steam for Mac - post your username here | Office '08 »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Date localisation in Excel 2008 retro83 OS X - Apps and Games 8 01-03-2014 08:02 PM
EXCEL (Office 2008) running slowly, freezing? Annettest OS X - Apps and Games 4 01-21-2010 05:33 AM
Excel 2008: HTML data being replaced jdu98a OS X - Apps and Games 0 09-02-2008 11:44 AM
Office 2008 for mac SP1 released. Visual Basic to return to next version of Office. Gbeav OS X - Apps and Games 3 05-13-2008 05:32 PM
Excel and visual basic liburary elrussell Running Windows (or anything else) on your Mac 1 02-25-2008 08:30 PM

All times are GMT -4. The time now is 08:37 AM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?