Isatifiketi seZikhokelo kunye neMida kwi-Excel exhumana ne-Microstation

Siqalise iintsuku ezimbalwa ezedlule sithetha malunga nendlela yokwenza oku, kodwa ukwenza i-concatenation Excel kwi-AutoCAD okanye kwi CSV kwi Microstation; zombini izikhokelo kunye nezilungelelaniso. Ukususela apho kukho ukungabaza Ukuba une isicelo engadingi ukuba ikopi paste, kodwa ukusebenzisana Excel ukulisika endaweni amanqaku eyenziwe imigca, emva kokuba ufuna ndidiniwe, yaye ngokuqinisekileyo kukho mdl ezininzi Microstation kunye SokufundaName for AutoCAD ... ngelishwa Andikhange ndifumane kakhulu ... ukuba umsebenzi

Inye kuphela ndiyifumanayo isicelo esenziwe kwi-Visual Basic ye-Moicrostation V8 ebizwa ngokuba yi-Visual Basic Rumbosdisttoexcel.mvba, unokuyikhuphela kwifom yefayili ukusuka apha.

1. Indlela yokuyilayisha

  • Emva kokuyilanda kufuneka uyivule
  • Ukuze ukumangalela yenza oku kulandelayo: Izixhobo / macro / umphathi weprojekthi / iprojekthi umthwalo / isicelo ujonge apho usindisiwe / Wena ke ukhetha ok

umfanekiso

2. Indlela yokwenza ngayo

  • Nje ukuba uyilayishe, uyayikhetha kuMphathi weProjekthi kwaye usebenzise iqhosha lesibhakabhaka iqhosha "macros"
  • Emva koko ukhetha isicelo «RunApplication.runMainMenu»
  • Ufaka iqhosha «lokubaleka '
  • kwaye iphaneli efana nale iya kuvela

umfanekiso

3. Yintoni esiyenzayo kwisicelo

Le sicelo inemisebenzi emibini, zombini isebenza ne-Microstation Geographics.

  • Thumela kwi-Excel, ngenxa yoko, yenza ucingo olufaka ipoloni, uze ukhethe okukhethwa kukho ngaphandle
  • Oku kuvelisa iFayile kwi-Excel, apho iibhodi, ukuhamba kunye ne-UTM idibeneyo iyahlukana.
  • Ngexesha elifanayo libeka iifaki kwiipoloni ngokuqala kunye neyona ephezulu kumzantsi-ntshona.
  • Kwakhona kukuvumela ukuba wenze okuphambeneyo, ukusuka kwi-data kwi-Excel unokwakhiwa kwakhona kwipolygoni.

Le vidiyo Ibonisa indlela isebenza ngayo.

Ukuba umntu ufuna ukuzama, download kwaye ndazi mna ngoko ukuba ufumana iingxaki ... nofefe ukuba VBA kukuba kunye nephasiwedi, ukuba kukho bani onobuganga makayiqhawule ... ukuze anike ubunakho enkulu.

Ndiyaqonda ukuba kufuneka isebenze ne-Microstation evamile, nangona kubonakala ukuba ifuna i-Microstation Geographics kunye neprojekthi evuliwe, nokuba kunjalo. Akufanelekanga kunye ne-Visual Basic umhleli we-Microstation kufuneka akwazi ukususa loo nxalenye ... ngokuqinisekileyo ukuba kufuneka uphule iphasiwedi.

Imisebenzi elindelekileyo:

  • Zama kwaye undixelele
  • Omnye kufuneka aqonde indlela yokuphosa iphasiwedi, kuba isicelo sitshisa kakhulu
  • Ukuba umntu uyazi malunga nesicelo, siya kuvunywa

Iimpendulo ze-7 kwi "Uluhlu lweZibheno kunye neMida kwi-Excel Excel kunye ne-Microstation"

  1. Ngaba omnye umntu ungandixelela ukuba balayishe i-macro? okanye ndingayifumana phi? bulela kakhulu

  2. Sawubona! Ikhasi elihle kakhulu. ngcebiso kubo bonke. Ngaba kukho nabani na ukuba babe nale sicelo? Inyaniso kukuba uthi unokukhuphela ukusuka apha kodwa kubonakala ukuba ikhonkco ayisebenzi. Ndiyathemba ukuba unokunceda ngale nto.
    imibuliso evela kwi-chile

    Erick

  3. Ndivile ukuba inika iingxaki nge-Microstation XM, andizange ndivavanye ngeV8i kodwa kufuneka ihambe kakuhle.

  4. Ukubulisa kunye novuyo kwiphepha.
    Ndibe ngumlutha ... kwiphepha.

    Ngaba isebenza ne-Microstation v8i?

  5. Ngaba sele usebenzisa i-XM?
    Kuza kufuneka kubuyiselwe kwakhona, isiqingatha esinzima.

  6. Hi G! njengoko oku sixhobo sigqibeleleyo ukuba uzisebenzisa kakhulu ... kodwa engasekho usebenza MicroStation XM V8i ... unga ukufumana uhlaziyo?

Shiya impendulo

Idilesi yakho ye email aziyi kupapashwa.

Le sayithi isebenzisa i-Akismet ukunciphisa ugaxekile. Funda indlela idatha yakho yokubhaliweyo isetyenziswe ngayo.