Jon, here is the code I was using.
Set swApp = Application.SldWorks
Set Part = swApp.ActiveDoc
swApp.LoadFile2 "R:\Cad\Solidworks\SolidWorks 04 Templates\Drawing Templates\Metric Drawing.drwdot", ""
Set Part = swApp.ActiveDoc
Set Part = swApp.NewDocument("R:\Cad\Solidworks\SolidWorks 04 Templates\Drawing Templates\IN9001(M B assy).slddrt", 0, 0, 0)
When I put yours in place my sheet format was not visible. It was there because if I did a edit sheet format it showed up.
It still doesn't seem like the drawing is linked back to the part.