Results 1 to 4 of 4

Creating a Folder and Populating it

Threaded View

  1. #1
    Registered User
    Join Date
    08-18-2008
    Location
    Los Angeles
    Posts
    44

    Creating a Folder and Populating it

    Hi!. I am using a excel 97 and have a macro that generated hundreds of work books on a single run. Due to the extensive number of work books, i would like to save all of this into a single folder. I able to create a folder on my macro by using the "MKDIR" command, however I can not seem to save any of my workbooks on that newly created folder, do i have to release that folder first. I get a message saying "Miscrosoft Office Excel cannot access the file (Folder).

    The command i am using to save the files:
    ActiveWorkbook.SaveAs Filename:=Output_Name, _
    FileFormat:=xlNormal

    The Output_Name contains the full path including the new folder name and the workbook name.
    What do you think i am doing wrong or not doing at all?
    Last edited by teachMeExcel; 05-07-2009 at 10:56 AM. Reason: ressolved

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1