Box bearings thiab mus nyob rau hauv kev sib tham sib Excel nrog Microstation

Peb pib ob peb hnub dhau los tham txog yuav ua li cas thiaj li ua tau li no, tab sis ua qhov kev xaus rau hauv Excel rau AutoCAD los yog los ntawm a CSV rau Microstation; ob qho tag nrho cov lus qhia thiab kev tswj hwm. Ces qee qhov kev ua xyem xyav sawv yog tias yuav muaj ib daim ntawv thov uas tsis xav tau daim ntawv muab tshuaj, tab sis qhov ntawd yuav cuam tshuam nrog kev nkag mus hauv Excel thiab tsis muaj cov ntsiab lus tsim cov kab, tom qab tshawb kuv tau nkees, thiab muaj tseeb muaj ntau mdl rau Microstation thiab Lisp rau AutoCAD… hmoov tsis kuv tsis tau nrhiav ntau ... uas yuav ua haujlwm

Qhov tsuas yog kuv yuav nrhiav tau yog ib daim ntawv thov tsim nyob rau hauv Visual Basic rau Moicrostation V8 Rumbosdisttoexcel.mvba, koj tuaj yeem luam tau nws nyob hauv zip hom ntawm no.

1. Yuav ua li cas mus ntsaws nws

• Tom qab daus nws koj yuav tsum zom nws
• Txhawm rau thauj nws, ua raws li hauv qab no: hlauv taws xob / macro / tus tswj hwm phiaj xwm / thauj khoom project / saib rau daim ntawv thov qhov chaw koj tau cawm nws / ces xaiv ok

2. Yuav ua li cas rau txim tuag nws

• Thaum koj tau thauj khoom, koj xaiv nws los ntawm Tus Thawj Saib Xyuas Haujlwm thiab siv lub pob xiav xiav "macros"
• Tom qab ntawd koj xaiv daim ntawv thov "RunApplication.runMainMenu"
• Koj siv lub "khiav" khawm
• thiab lub vaj huam sib luag li qhov no yuav tshwm sim

3. Yuav ua li cas daim ntawv thov ua

Daim ntawv thov no muaj ob txoj hauj lwm, ua haujlwm nrog Microstation Geographics.

• Export rau Excel, rau qhov no, ua ib lub laj kab uas npog lub polygon, tom qab xaiv qhov kev xaiv
• Qhov no ua rau muaj cov ntaub ntawv hauv Excel, nyob qhov twg, cov kab nrig, txoj kev mus thiab cov UTM koom ua ke sib cais.
• Nyob rau tib lub sij hawm nws muab cov kev vertices rau lub polygon pib nrog rau ib qho uas yog ntau rau sab qab teb sab hnub poob.
• Nws tseem tso cai rau koj ua tus inverse, los ntawm cov ntaub ntawv nyob hauv Excel koj tuaj yeem hloov qhov polygon.

Qhov yees duab no Nws qhia tau hais tias nws ua haujlwm li cas.

Yog tias ib tug neeg xav sim nws, rub nws thiab qhia rau kuv paub yog tias nws ua teeb meem rau koj ... pity tias VBA yog nrog tus lej zais, yog tias ib tug neeg xav tsoo nws ... nws muaj peev xwm muab nws ntau dua qhov peev xwm.

Kuv nkag siab hais tias nws yuav tsum ua haujlwm nrog Microstation ib txwm, txawm hais tias nws pom meej tias yuav tsum tau Microstation Geographics nrog qhov qhib qhov project, leej twg. Nws tsis tsim nyog thiab nrog Microstation Cov Ntawv Pom Duab Sau Ntawv Basic nws yuav tsum muaj peev xwm tshem tawm ntu ntawd ... ntawm chav kawm, rau qhov koj yuav tsum tsoo tus password.

Yeej tsis txaus siab:

• Sim nws thiab qhia rau kuv
• Ib tug neeg yuav tsum paub yuav ua li cas muab pov tseg rau hauv tus password, vim hais tias daim ntawv thov yog kub heev
• Yog tias ib tug neeg paub txog ib daim ntawv thov, nws yuav raug txais tos