vba - SolidWorks 2013 Macro - String manipulation? -

-

solidworks uses vba macros, different excel vba (which i'm accustomed to). made difficult (and quite possibly impossible) manipulate strings in sw. i've tried using left() function , mid() function, can not figure out how make work. need do, save .dxf file , name title, without sheet name. sheet name causing problem , i'm trying cut out. can use

part.gettitle

to string of title which, example like

pa0000 - sheet1

and want 

pa0000

sometimes length different, i've tried using 

left(part.gettitle,instr(part.gettitle, " ")-1)

but gives type mismatch error. doing wrong? that's left macro cut out " - sheet1".

i have made changes code @ help.solidworks.com; should work you. change folders needed.

dim swapp object  dim part object dim boolstatus boolean dim longstatus long, longwarnings long 'http://help.solidworks.com/2012/english/api/sldworksapi/save_file_as_pdf_example_vb.htm sub main()     dim swapp                       sldworks.sldworks     dim swmodel                     sldworks.drawingdoc     dim swpart                      sldworks.partdoc     dim bret                        boolean     dim mypath                      string     dim myfolder                    string     dim longstatus                  long     dim filename                    string     set swapp = application.sldworks      set swmodel = swapp.activedoc      myfolder = "c:\temp" ' change temp drive since curdir write protected.     myfile = left(swmodel.getpathname, instrrev(swmodel.getpathname, ".") - 1)     myfile = right(myfile, len(myfile) - instrrev(myfile, "\"))     mypath = left(swmodel.getpathname, instrrev(swmodel.getpathname, "\") - 1)     mypath = right(mypath, len(mypath) - instrrev(mypath, "\"))      debug.print "filename = " & myfile     debug.print "file = " & swmodel.getpathname     debug.print "folder = " & mypath     debug.print "current folder = " & curdir$     debug.print (myfolder & "\" & myfile & ".dxf")     filename = myfolder & "\" & myfile & ".dxf"     longstatus = swmodel.saveas3(filename, 0, 0)     ' pdf generation     ' longstatus = swmodel.saveas3(myfolder & "\" & myfile & ".pdf", 0, 0)  end sub

Comments

Post a Comment

Popular posts from this blog

PHP DOM loadHTML() method unusual warning -

-
i had following code works fine on localhost: $document = new domdocument(); $document->loadhtml($p_result); $form = $document->getelementsbytagname('form')->item(0); // code continues using $form variable after same code updated on outside server, loadhtml() failed , issued warning. warning: domdocument::loadhtml() expects parameter 1 valid path, string given in path/name/to/script.php returned null instead of object code pretty gets fatal error. note contents of $p_result absolutely same on outside server , on localhost. but why displays kind of warning , why not work? doesn't loadhtml() expects argument 1 string in first place? why method expects parameter 1 valid path ? just make clear i'm not calling loadhtmlfile() , i'm calling loadhtml() . thanks. you're affected one of php bugs . issue present in php 5.6.8 , 5.6.9. have affected php version on server, , bug-free version on localhost. the bug forbids null
Read more

python - How to create jsonb index using GIN on SQLAlchemy? -

-
here's current code creating index jsonb. index("mytable_data_idx_id_key", mytable.data['id'].astext, postgresql_using='gin') but got error. sqlalchemy.exc.programmingerror: (psycopg2.programmingerror) data type text has no default operator class access method "gin" hint: must specify operator class index or define default operator class data type. [sql: "create index event_data_idx_id_key on event using gin ((data ->> 'id'))"] is there way create index on sqlalchemy? the postgresql specific sqlalchemy docs @ http://docs.sqlalchemy.org/en/latest/dialects/postgresql.html#operator-classes mention postgresql_ops dictionary provide "operator class" used postgresql, , provide example illustrating use: index('my_index', my_table.c.id, my_table.c.data, postgresql_ops={ 'data': 'text_pattern_ops',
Read more

c# - TransactionScope not rolling back although no complete() is called -

-
i'm using transactionscope rollback transaction fail bool errorreported = false; action<importerrorlog> newerrorcallback = e => { errorreported = true; errorcallback(e); }; using (var transaction = new transactionscope()) { foreach (importtaskdefinition task in taskdefinition) { loader.load(streamfile, newerrorcallback, task.destinationtable, processingtaskid); } if (!errorreported) transaction.complete(); } i'm sure there no transactionscope started ahead or after code. i'm using entity framework insert in db. regardless state of errorreported transaction never rolled in case of error. what missing ? transactionscope sets transaction.current . that's does. wants transacted must @ property. i believe ef each time connection opened reason. probably, connection open when scope installed. open connection inside of scope or enlist manually. ef has nasty "design decision": default opens
Read more