independent sheets
Sometimes you work with a lot of data and several of them must go to the same spreadsheet format, is comfortable working from the same excel file, but then there is the need of freeing each of the sheets created the file. In case you have 20 or 100 sheets is difficult to copy each into a new workbook and save it.
To do this more easily, you can use some Excel VBA code. In the following lines expose the code to use.
explained below what this code.
with lines 01 and 17 begins and ends the subroutine. In lines 02, 03, 04 and 05 variables are declared. Line 06 assigns a wb as the active workbook, the book which will create separate files for each of its leaves. In line 07, take the path where you save the active workbook.
Between the lines 08 and 19 makes a loop to iterate through each of the pages of a book and create separate files. On line 09 is assigned the full path where you save the page "i", lines 10 and 11 perform the process of selecting and copying. Lines 12, 13 and 14 saved the file.
can download this file here. Any queries please do it using the form on the right.
0 comments:
Post a Comment