Results 1 to 5 of 5
  1. #1


    Member Since
    May 01, 2012
    Posts
    1
    Unhappy Macros in Excel from windows
    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.

  2. #2

    chscag's Avatar
    Member Since
    Jan 23, 2008
    Location
    Fort Worth, Texas
    Posts
    48,818
    Specs:
    Late 2013 27" iMac, iPad 3, iPhone 6s+, iPhone 6+, 3 iPods, El Capitan
    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.

  3. #3

    Slydude's Avatar
    Member Since
    Nov 15, 2009
    Location
    North Louisiana, USA
    Posts
    10,318
    Specs:
    2.8 GHz MacBook Pro 10.11, 8 GB mem, iPhone 6+
    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

  4. #4

    chscag's Avatar
    Member Since
    Jan 23, 2008
    Location
    Fort Worth, Texas
    Posts
    48,818
    Specs:
    Late 2013 27" iMac, iPad 3, iPhone 6s+, iPhone 6+, 3 iPods, El Capitan
    @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).

  5. #5

    Slydude's Avatar
    Member Since
    Nov 15, 2009
    Location
    North Louisiana, USA
    Posts
    10,318
    Specs:
    2.8 GHz MacBook Pro 10.11, 8 GB mem, iPhone 6+
    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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 10
    Last Post: 01-31-2013, 01:00 AM
  2. trouble with macros on excel
    By jc.fischer in forum Switcher Hangout
    Replies: 1
    Last Post: 06-27-2012, 09:18 PM
  3. i need to enable Macros in excel HELP!!!
    By unders0007 in forum Running Windows (or anything else) on your Mac
    Replies: 4
    Last Post: 11-30-2010, 01:17 AM
  4. excel macros
    By fatfish in forum OS X - Apps and Games
    Replies: 2
    Last Post: 02-10-2010, 11:19 PM
  5. OS 10.3.9 Excel Macros
    By PHoMAC in forum OS X - Operating System
    Replies: 0
    Last Post: 05-02-2006, 09:31 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •