Shafin Sadarwar Siffa na Microstation da Rarraba Chart

Mun fara 'yan kwanaki da suka wuce game da yadda za a yi haka, amma yin kaddamarwa a Excel don AutoCAD ko daga CSV zuwa Microstation; biyu kwatance da hadewa. Daga can wasu shakka sun tashi Idan kana da wani aikace-aikace cewa ba ya bukatar copy manna, amma hulɗa tare da wani yankan Excel, kuma maimakon maki generated Lines, bayan kasancewa neman na gaji, kuma lalle ne akwai da yawa mdl for Microstation da guragura for AutoCAD ... abin takaici ban sami yawa ... shi aiki

Iyakar abin da zan iya samuwa shine aikace-aikacen da aka samo a cikin Kayayyakin Kayan Na'urar V8 Rumbosdisttoexcel.mvba, zaku iya sauke shi a zip daga wannan.

1 Yadda za a dauka

  • Bayan saukar da shi dole ne ka cire shi
  • Don kaddamar da shi kuna yin haka: ayyuka masu amfani / macro / aikin sarrafawa / aikin / kuna neman aikace-aikacen inda kuka ajiye shi / sannan ku zaɓi ok

image

2 Yadda za a kashe shi

  • Da zarar ka ɗora shi, za ka zaba shi daga Mai sarrafawa da kuma amfani da maballin arrow button «macros»
  • Sa'an nan kuma ka zaɓi aikace-aikacen "RunApplication.runMainMenu"
  • Kuna amfani da button «gudu»
  • kuma kwamitin kamar haka zai bayyana

image

3 Abin da aikace-aikacen ya yi

Wannan aikace-aikacen yana da ayyuka biyu, duka aiki tare da Microstation Geographics.

  • Fitarwa zuwa Excel, saboda wannan, yi shinge wanda ke kewaye da polygon, sannan zaɓi zaɓi na Export
  • Wannan yana haifar da fayil ɗin a Excel, inda aka raba raguwa, nesa da kuma UTM.
  • A lokaci guda kuma yana sanya tsaunuka zuwa polygon farawa da wanda ya fi kudu maso yamma.
  • Har ila yau yana ba ka damar yin kuskure, daga bayanan da ke cikin Excel zaka iya sake gina polygon.

Wannan bidiyo nuna yadda yake aiki

Idan wani yana so ya gwada shi, sauke shi kuma ya sanar da ni idan ya baka matsaloli ... tausayi VBA yana tare da kalmar sirri, idan wani yayi ƙoƙari ya karya shi ... yana yiwuwa ya ba shi damar.

Na fahimci cewa ya kamata yayi aiki tare da Microstation na al'ada, ko da yake yana nuna Microstation Geographics tare da aikin budewa, ko dai. Ya kamata ba tare da Editan Kayayyakin Kasuwancin Microstation ba zai iya cire wannan sashi ... hakika saboda haka dole ka karya kalmar sirri.

Ayyukan masu jiran aiki:

  • Gwada wannan kuma gaya mani
  • Ya kamata mutum ya san yadda za'a jefa kalmar sirri, saboda aikace-aikacen yana da zafi sosai
  • Idan wani ya san game da aikace-aikace, zai zama maraba

7 tana maida hankali ga "Shirin Gudun hanyoyi da Gyara a cikin Excel Excel da Microstation"

  1. Shin wani zai gaya mani idan sun sauke Macro? ko ina zan iya samun shi? na gode sosai

  2. Hi! Very kyau page. shawara ga kowa. Shin wani yana da wannan aikace-aikacen? Gaskiyar ita ce, tana cewa za ka iya saukewa daga nan amma a fili alamar ba ta aiki ba. Ina fatan za ku taimake ni da wannan.
    gaisuwa daga chile

    Erick

  3. Na ji cewa yana haifar da matsaloli tare da Microstation XM, Ban gwada shi ba tare da V8i amma ya kamata ya yi kyau.

  4. Gaisuwa da taya murna a shafin.
    Na zama mai kamu ... zuwa shafin.

    Shin yana aiki tare da Microstation v8i?

  5. Kuma kuna riga kuna amfani da XM?
    Dole ne a sake dawo da shi, rabi mai rikitarwa.

  6. Sannu G! yadda wannan kayan aiki yake da kyau na yi amfani da shi mai yawa ... amma ba ya aiki tare da Microstation V8i XM ... zan iya samun sabuntawa?

Deja un comentario

Your email address ba za a buga.

Wannan shafin yana amfani da Akismet don rage spam. Koyi yadda aka sarrafa bayanan bayaninka.