Hi Guys,
I would like to save all sheets from all workbooks in a specific folder as value only without opening them all.
Is there a macro available for this?
Thanks in advance.
Hi Guys,
I would like to save all sheets from all workbooks in a specific folder as value only without opening them all.
Is there a macro available for this?
Thanks in advance.
Try this code
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
I don't believe you can do it without opening the workbooks, but you don't have to do anything manually except run the macro. Substitute the folder path for 'ThisWorkbook.Path' in the code below. It is assumed that these are single sheet workbooks or that sheet 1 is the only sheet with data. It is also assumed that only those workbooks you want to remove formulas from are in that folder. If there are other workbooks in the folder that you do not want to change, they will need to be listede as exceptions in the code.
Please Login or Register to view this content.
Last edited by JLGWhiz; 03-06-2018 at 02:50 PM.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
It gives an unknown filename error at the part of :
HTML Code:
Make sure of the folder path that has the excel files ..
Fix the line of path to suit you
I supposed a folder named "TestFolder" in the same path of your workbook ...Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks