Hey Friends, 

So i'm working on a macro that will take and update my company's old drawings from their previous sheet formats to our new one. I was able to find a program of Deepak's and use it to do it manually by clicking a button. I would like to automate this if possible. So the macro would take the sheet paper size and scale from the drawing and change it to our new sheet format with the old paper size and scale.

So it would look something like this(credit for the code goes to Deepak Gupta):

bRet = swDraw.SetupSheet4(swSheetGetName, [old drawing paper size], swDwgTemplateCustom, 1, [old drawing scale], False, sPath, .2794, .2159, "Default")

Is this possible?

Thanks,

Trevor