How do I separate worksheets into individual files?
How do I separate worksheets into individual files?
(OP)
I have a whole lot of Solidworks 2010 drawings that have 10 worksheets to each file. My job is to split each worksheet up into individual files instead of the "10 pack" There has to be an easier way to do this than a lot of copy and pasting and renaming.






RE: How do I separate worksheets into individual files?
Meantime;
Save as the drawing to a new name
Repeat 9 times
Open each drawing
Delete the unwanted sheets
Repeat
RE: How do I separate worksheets into individual files?
does anyone know how to use a macro to do the following, in the order its read...
-open new file (after you copy a worksheet)
-paste the worksheet in the new file
-fit to screen (F)
-delete worksheet 1 (Sheet1)
RE: How do I separate worksheets into individual files?
http
DocExport - might be able to be used to automatically export out the sheets of your drawing to new files.
RebuildDrawing - you might be able to add to this macro to do what you want.
-Dustin
Professional Engineer
Pretty good with SolidWorks