【转帖】autocad rev block to sw rev block

yang686526

autocad rev block to sw rev block
it's been way too long since i've delved into vb. as of now i'm able to get revision table information from autcad into an excel spreadsheet without too much trouble. once there however i'm at slight loss on how to get it from there to a solidworks drawing revision table. i'm thinking the clipboard will be a good way to go. i know how to set values in the rev block so that's not a problem. i think that reading the array from the clipboard will be my biggest roadblock. if anyone has a tips or example code they can post/point me to i'd be very greatful.
cad monkey
sw2k7 sp5.0
sw2k8 sp3.0
you can com into excel from solidworks and read the cells using excel api, that will be much simpler. however, if you are not familiar with solidworks api nor excel api you may struggle a bit,
as i stated it's been a long time since i last dabled with vb and the sw/excel api's. i'm sure some struggling is inevitable. right now i'm just wanting to find a simple way to copy an activeregion in excel into a multidimentional array.
cad monkey
sw2k7 sp5.0
sw2k8 sp3.0