Results 1 to 13 of 13

Debugging this error in this macro that takes worksheets and places them into new workbook

Threaded View

  1. 02-13-2013, 06:42 PM #1
    ibabs
    ibabs is offline
    Forum Contributor
    Join Date
    05-07-2009
    Location
    cedar grove
    MS-Off Ver
    Excel 2003
    Posts
    133

    Debugging this error in this macro that takes worksheets and places them into new workbook

    Hello,
    I have this macro that is supposed to create a folder on my desktop and take the current opened excel file with multiple tabs and have each tab make their own workbook.
    There is one line that keeps giving me grief...I have made it bold.
    I am doing this on a mac excel 2011.

    The actual macro is in a newer post

    I am getting stuck at this line:

    MkDir FolderName

    Does anyone have any thoughts?
    Thanks in advance for your help!
    babs
    Last edited by ibabs; 02-17-2013 at 10:00 AM. Reason: Did not put in the code correctly per forum rules
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1