【转帖】exporting certain pages to certain file types

yang686526

exporting certain pages to certain file types
i've written up a macro to create a pdf, dxf, and e-drawing file for my active drawing. it's not the most efficient but it's my first foray into vb programming so bear with me/it.
currently the macro:
1) generates a pdf of all the sheets in the drawing
2) generates an e-drawing of all the sheets in the drawing
3) jumps to the last sheet of the drawing, generates a dxf of that sheet, and then jumps back to the first sheet of the drawing and ends
4) all files are saved in the source file folder
what i'd like to add/modify in the macro is:
1) export just the sheet named "dxf" to the dxf file format if it exists
2) export all sheets except the sheet named "dxf" to pdf format
3) export all sheets except the sheet named "dxf" to e-drawing format
4) close the document after the files are created. do not dismiss any "save" pop-ups, let the user decide.
i know it's asking for a bunch of help but at my current skill level and pace it would take me a while to figure this out.
thanks for any/all help. i've attached my macro below.
-jody
mechanical engineer
temptronic corp
.temptronic.com