+ Reply to Thread
Results 1 to 3 of 3

Code Creating new folder with predetermined filename

  1. #1
    Registered User
    Join Date
    05-02-2012
    Location
    Indiana
    MS-Off Ver
    Excel 2007
    Posts
    33

    Code Creating new folder with predetermined filename

    Hello,
    I am in need of a code to create a new folder. I have the code to rename the folder to a specific name (issue number).

    There are several small things in my code I am not happy with and could use some help.
    Your help is greatly appreciated.

    My (ICAR)workbook contains several sheets.
    As the first worksheet (Report) is filled in, it is linked to the others, populating some of the criteria as needed.
    When every sheet is completed as necessary, a code will make a copy of each sheet, save each as a new book in a specific folder, change the formulas to values, and close out. It then opens a log, log the information on the Report on the original workbook, saves the log, closes this out. Then at last it closes out the ICAR workbook.

    The changes I would like to make are as follows:
    -Update links: none there should be no links once I changed all the formulas to values for each saved worksheet
    -When I save the worksheets individially, the "macro buttons" are saved with them - can I remove them - every time
    - Set rngDetailFound = rngDetailToSearch.Find(What:=wks.Range("IV50000"), _ LookAt:=xlPart, MatchCase:=False) - ALL i want it to find is the next empty cell, I had to eventually reference a cell that I knew would be blank -
    - When one of the sheets I save has a filename beginning with the word "No", then I do not want it to save a copy in the folder.
    And at the very end, I do not want the user to be able to save any changes to the ICAR report workbook before closing out - all the sheets are saved and logged already and this workbook needs to star clear for the next user.

    Here id the code I have so far:
    Please Login or Register  to view this content.
    THANK YOU FOR ANY HELP
    Last edited by arlu1201; 06-18-2012 at 10:55 AM. Reason: Code tags.

  2. #2
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,160

    Re: Code Creating new folder with predetermined filename

    I have put code tags for you this time. Ensure you do so in future.

    Just put [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] after it.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    05-02-2012
    Location
    Indiana
    MS-Off Ver
    Excel 2007
    Posts
    33

    Re: Code Creating new folder with predetermined filename

    Arlette,
    I think I can see why the code tags are needed. It puts the code in a special little window!

    Thanks, and sorry, I did not see that remark prior to submitting the question

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1