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.

Macros in Excel from windows


Post Reply New Thread Subscribe

 
Thread Tools
bnoble

 
Member Since: May 01, 2012
Posts: 1
bnoble is on a distinguished road

bnoble is offline
Hi all, I am trying to run macros in an Excel spreadsheet created from a Windows PC. When I hit Ctrl F some numbers are supposed to populate but nothing happens and I get a Microsoft Visual Basic window that reads "Run-time error 68, Device unavailable." Not sure if this question even makes sense but I think you should get the idea.

Any help on whats wrong and how to fix it would be great. Thanks.
QUOTE Thanks
chscag

 
chscag's Avatar
 
Member Since: Jan 23, 2008
Location: Fort Worth, Texas
Posts: 41,387
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, Yosemite

chscag is offline
Macros created in Windows Excel naturally will have to be recompiled before they'll run in Office Excel 2011. (different operating systems) That's why the VB error occurred.
QUOTE Thanks
Slydude

 
Slydude's Avatar
 
Member Since: Nov 16, 2009
Location: North Louisiana, USA
Posts: 6,845
Slydude has a brilliant futureSlydude has a brilliant futureSlydude has a brilliant futureSlydude has a brilliant futureSlydude has a brilliant futureSlydude has a brilliant futureSlydude has a brilliant futureSlydude has a brilliant futureSlydude has a brilliant futureSlydude has a brilliant futureSlydude has a brilliant future
Mac Specs: 2.8 GHz MacBook Pro 10.8,3 8 GB mem, 2.66 GHz Mac Pro - Dead, iPhone 4

Slydude is offline
Which version of Excel is this on Windows? Some versions are almost identical with only minor differences among some of the functions.

It has been a while since I worked with these types of macros at all but I suspect the code is looking for a drive/device based upon the way Windows assigns names. If the code is looking for drive F on Windows for example and there is no such drive on the Mac this is likely the error that would result. hard to tell without seeing the code.

Sylvester Roque Former Contributing Editor About This Particular Macintosh

"Got Time to breathe. You got time for music." Denver Pyle as Briscoe Darling
QUOTE Thanks
chscag

 
chscag's Avatar
 
Member Since: Jan 23, 2008
Location: Fort Worth, Texas
Posts: 41,387
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, Yosemite

chscag is offline
@Sly:

Microsoft recommends recompiling macros (Word, Excel, PP) that are used in the Windows version when bringing the document over to OS X in Office 2011.

However, I've basically dumped my macros and now use the "services" feature in Office 2011. Works great with Word and PP, (I don't use Excel).
QUOTE Thanks
Slydude

 
Slydude's Avatar
 
Member Since: Nov 16, 2009
Location: North Louisiana, USA
Posts: 6,845
Slydude has a brilliant futureSlydude has a brilliant futureSlydude has a brilliant futureSlydude has a brilliant futureSlydude has a brilliant futureSlydude has a brilliant futureSlydude has a brilliant futureSlydude has a brilliant futureSlydude has a brilliant futureSlydude has a brilliant futureSlydude has a brilliant future
Mac Specs: 2.8 GHz MacBook Pro 10.8,3 8 GB mem, 2.66 GHz Mac Pro - Dead, iPhone 4

Slydude is offline
I have not used that feature since probably the 2008 version maybe before. Did not know they were actually compiling them now. services had not really kicked in when I was using them. The cross platform use was a big deal for me at the time.

Sylvester Roque Former Contributing Editor About This Particular Macintosh

"Got Time to breathe. You got time for music." Denver Pyle as Briscoe Darling
QUOTE Thanks

Post Reply New Thread Subscribe


« Which is the highest version of Final Cut that can be used with 10.5.8? | Office Outlook 2011 for mac rules not working ..... »
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
Calling all Windows Power Users consultant Switcher Hangout 6 08-20-2012 05:27 PM
Getting my first Mac. A Few of Questions. Someguy2055 Apple Notebooks 19 08-20-2012 02:18 PM
i need to enable Macros in excel HELP!!! unders0007 Running Windows (or anything else) on your Mac 4 11-30-2010 02:17 AM
Question about Bootcamp Melorock089 Switcher Hangout 12 06-29-2009 08:53 PM
NTFS-formatted Windows XP installed via Bootcamp 1.3 Jrstrdr Running Windows (or anything else) on your Mac 4 06-29-2007 12:46 AM

All times are GMT -4. The time now is 11:27 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?