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:
THANK YOU FOR ANY HELPPlease Login or Register to view this content.
Bookmarks